connx Generix
telephone +44 (0) 1924 500 151
products

evaluation

faq

support

contact

news

home

CONNX for Oracle

The CONNX for Oracle module provides secure, real-time, read/write SQL access to Oracle 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 two or more supported disparate databases.

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.

The CONNX distributed SQL engine reduces the workload placed on the Oracle database server by performing CPU intensive operations on the PC, while allowing the database engine to perform tasks for which it is best suited. CONNX imports the metadata directly from your Oracle RDBMS. In addition, CONNX and 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.

overview

architecture

details

case studies

info request
C-ISAM

D-ISAM

DataFlex

DataSync

DB2

Desktop Adapter

infonaut

informix

microfocus

OLEDB Adapter

Oracle

DBMS

Rdb

powerflex

RMS

SQL

Sybase

VSAM