Data Integration


Quickly integrate data from multiple sources to enable business decisions.


  • Microsoft Access allows access to data stored in the Access MDB files and to external data sources accessible through ODBC. It then allows the user to report and query data as if it all exists in the Microsoft Access data store--all without having to move the actual data into Access or some other common data store.
  • Present an integrated view of data through middleware or a RDBMS such as SQL Server, Oracle, or DB2. For example, SQL Server offers a distributed query processing feature that allows external OLE DB compliant data sources to be included in queries. This allows data in SQL Server to be joined with data residing in one or more external data sources. Oracle and DB2 offer similar functionality.
  • Middleware from companies like IBM, Metamatrix and XAware allows creating a virtual layer on top of existing data stores. These products contain application-specific adapters to access data from popular ERP and CRM applications and ODBC/JDBC adapters to access data from relational data stores.


All of the above scenarios require data sources to offer ODBC/JDBC and SQL capability. Using DataDirect OpenAccess SDK, you can make all your data sources accessible using SQL through ODBC, OLE DB, JDBC, or ADO.NET.


Empowers both ISVs and enterprises to quickly integrate data from multiple sources.