Founded in 1994 in San Jose, California, HiT Software is a commercial software development company with headquarters in San Jose, California and offices in Italy, Hong Kong and Chile. HiT Software produces Data Integration

Data integration

Data integration involves combining data residing in different sources and providing users with a unified view of these data.This process becomes significant in a variety of situations, which include both commercial and scientific domains...

 and Change Data Capture

Change data capture

In databases, change data capture is a set of software design patterns used to determine the data that has changed so that action can be taken using the changed data...

 software tools. HiT Software was acquired by BackOffice Associates, LLC in April 2010.

Products

DBMoto - a graphical database replication software product for heterogeneous relational databases, that provides real-time data migration, data mapping

Data mapping

Data mapping is the process of creating data element mappings between two distinct data models. Data mapping is used as a first step for a wide variety of data integration tasks including:...

, data updates, bi-directional data synchronization

Data synchronization

Data synchronization is the process of establishing consistency among data from a source to a target data storage and vice versa and the continuous harmonization of the data over time. It is fundamental to a wide variety of applications, including file synchronization and mobile device...

, change data capture, data transformation

Data transformation

In metadata and data warehouse, a data transformation converts data from a source data format into destination data.Data transformation can be divided into two steps:...

, mirroring, refresh and batch support for production servers, operational data stores, data marts, data warehouses, and business intelligence. DBMoto supports IBM DB2 for i (iSeries/AS400), IBM LUW (UDB), IBM z/OS (mainframe), Oracle, Microsoft SQL Server, MySQL, Sybase, Informix , Netezza TwinFin data warehouse appliances and others. DBMoto uses transaction log

Transaction log

In the field of databases in computer science, a transaction log is a history of actions executed by a database management system to guarantee ACID properties over crashes or hardware failures...

-reading and triggers for mirroring and synchronization.

Allora - a graphical software product that maps XML

XML

Extensible Markup Language is a set of rules for encoding documents in machine-readable form. It is defined in the XML 1.0 Specification produced by the W3C, and several other related specifications, all gratis open standards....

 to databases bi-directionally with a modular design.

DB2 Connectivity - a set of middleware

Middleware

Middleware is computer software that connects software components or people and their applications. The software consists of a set of services that allows multiple processes running on one or more machines to interact...

 that connects IBM DB2 data to applications . Supports JDBC, ADO.NET

ADO.NET

ADO.NET is a set of computer software components that programmers can use to access data and data services. It is a part of the base class library that is included with the Microsoft .NET Framework. It is commonly used by programmers to access and modify data stored in relational database systems,...

, ODBC and OLE DB

OLE DB

OLE DB is an API designed by Microsoft for accessing data from a variety of sources in an uniform manner. It is a set of interfaces implemented using the Component Object Model ; it is otherwise unrelated to OLE...

 standards.

See also

• Data integration
  Data integration
  Data integration involves combining data residing in different sources and providing users with a unified view of these data.This process becomes significant in a variety of situations, which include both commercial and scientific domains...
  
  
• Database replication
• Data transformation
  Data transformation
  In metadata and data warehouse, a data transformation converts data from a source data format into destination data.Data transformation can be divided into two steps:...
  
  
• XML Schema
  XML Schema
  XML Schema, published as a W3C recommendation in May 2001, is one of several XML schema languages. It was the first separate schema language for XML to achieve Recommendation status by the W3C...
  
  
• Change data capture
  Change data capture
  In databases, change data capture is a set of software design patterns used to determine the data that has changed so that action can be taken using the changed data...
  
  
• open database connectivity
  Open Database Connectivity
  In computing, ODBC is a standard C interface for accessing database management systems . The designers of ODBC aimed to make it independent of database systems and operating systems...
  
  

External links

• Official website http://www.hitsw.com
• "EFCO Case Study: DBMoto" http://www.hitsw.com/about_hit/case_studies/DBMoto_CS_EFCO.pdf
• HiT Software's DBMoto 6.5, a product review by James Koopmannhttp://www.databasejournal.com/features/oracle/article.php/3810821/HiT-Softwares-DBMoto-65.htm
• HiT Software, An Expert’s Guide to Database Solutions, blog of James Koopmann http://it.toolbox.com/blogs/database-solutions/database-and-data-integration-for-the-dba-29561
• IBM Advanced Partner, http://www.ibm.com/developerworks/wikis/display/im/Hit+Software,+Inc.+(IDS)
• Woodie, Alex (2009-03-10). "HiT Touts Real World Work of IBM i Data Provider" ITJungle - Four Hundred Stuff, http://www.itjungle.com/fhs/fhs031009-story07.html
• Smith, Chris (2009-03-06). "Avoid the Hassle of Accessing DB2 Data from .NET Applications" MCPress Online, http://www.mcpressonline.com/database/db2/avoid-the-hassle-of-accessing-db2-data-from-net-applications.html
• "DBMoto 6.5" IBM Systems Magazine, http://www.ibmsystemsmag.com/aix/februarymarch09/productnews/23889p1.aspx
• Deemer, Cassandra (2009-01-01). "DBMoto: Simplifying the Sport of Database Replication" System iNetwork, http://systeminetwork.com/article/dbmoto-simplifying-sport-database-replication