 |
 |
 |
|
 |
|
 |
|
 |
|
 |
|
 |
Integrate Any Data Source with IBM DB2 through ODBC Wrapper
Many organizations are using the power of products like IBM DB2 to implement a federated data management solution where data can reside in various sources but be exposed as a virtual database for querying by client applications.
A DB2 federated system is a special type of distributed database management system (DBMS). A federated system consists of a DB2 instance that operates as a federated server, a database that acts as the federated database, one or more data sources, and clients (users and applications) that access the database and data sources. With a federated system, you can send distributed requests to multiple data sources within a single SQL statement. For example, you can join data that is located in a DB2 Universal Database table, an Oracle table, and your custom application data in a single SQL statement.
IBM DB2 allows access to data sources through the various pre-built wrappers and by allowing the implementation of custom wrappers. The use of the pre-built ODBC wrapper allows the DB2 to pass portions of a SQL query down to an ODBC/SQL enabled data source for processing.
The use of DataDirect® OpenAccess™ to implement a custom ODBC driver with full SQL capability is a viable solution for implementing efficient federated database management systems based on IBM DB2.
|
