CONNX Desktop Adapter
The CONNX Desktop OLE DB 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, enabling 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.
CONNX 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.
CONNX imports the metadata directly from your OLE DB or ODBC compliant data source.