CONNX for Oracle
The CONNX for Oracle module provides secure, real-time, read/write SQL access to Oracle® databases running on any platform using ODBC OLE DB JDBC and .NET. In conjunction with other CONNX modules, you can perform seamless joins between Oracle tables and CONNX supported data sources.
With CONNX, 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. To the user or application, data appears as if it existed in a single federated relational database.
The CONNX distributed SQL engine reduces the workload placed on the Oracle database server by performing CPU intensive where the CONNX client resides, 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 CONNX client in addition to the database server.
CONNX imports the metadata directly from your Oracle RDBMS. In addition, CONNX for Oracle includes support for stored procedures, BLOBs, and pass through SQL execution.
Add CONNX DataSync and replicate your Oracle database to supported data sources without impacting the performance of your Oracle database. CONNX DataSync delivers near real-time data synchronization by incrementally updating only those records that have changed.