CONNX for DB2The CONNX for DB2 Module provides secure, real-time, read/write access to DB2 databases running on any platform using 64-bit and 32-bit ODBC OLE DB JDBC and .NET. In conjunction with other CONNX modules, you can perform seamless joins between DB2 and CONNX supported databases.
With CONNX for DB2 a single metadata model can be created that spans all enterprise data sources and applications requiring data access. The result is an enterprise-wide view of data that provides a reusable standards-based framework for information access.
The CONNX for DB2 distributed SQL engine reduces the workload placed on the server by performing CPU-intensive operations on the client, while allowing the database engine to perform tasks for which it is best suited. This distributed SQL engine facilitates truly scaleable application development because of the additional processing power gained by the use of the client in addition to the database server.
CONNX for DB2 supports the creation of views, which facilitates hiding table relationships from the end user. CONNX views facilitates the creation of heterogeneous joins between multiple disparate databases.
Add CONNX DataSync and replicate your DB2 database to supported data sources without impacting the performance of your DB2 database. CONNX DataSync delivers near real-time data synchronization by incrementally updating only those records that have changed.