CONNX Desktop Database Adapter
The CONNX Desktop Database Adapter module provides secure, real-time, read/write access to desktop databases such as MS Access, FoxPro, dBase, Approach and Paradox as well as read access to document files such as MS Excel and delimited text files allowing them to be integrated with other CONNX supported enterprise data sources. In conjunction with other CONNX modules, you can perform seamless joins between two or more supported disparate 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.
The CONNX distributed SQL engine reduces the workload placed on the data source 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 OLE DB or ODBC complaint data source.
All members of the CONNX family have the following features:
RMS, Oracle Rdb, VSAM, IMS, C-ISAM, D-ISAM, Micro Focus, DB2, Oracle, Oracle DBMS, Dataflex, POWERflex, SQL server and any OLEDB or ODBC data source
CONNX is used by more than 3000 organisations world-wide to enable enhanced reporting, business intelligence, web/application development, data warehousing, synchronization and migration.