CONNX for Excel module provides secure, real-time, read/write access to Excel enabling it 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.
Extend Excel to other Data Sources: CONNX for Excel is a powerful tool that facilitates fast data repairs and data cleansing within the easy-to-use, familiar Excel application. Data can be manipulated, cleansed, and modified manually, using Excel formulas and other Excel features. After completing the data manipulation, CONNX for Excel takes over and performs the requested updates in the data source table.
CONNX for Excel turns Excel into a user-friendly 'disconnected recordset' that can help you save time and money by enabling your users to handle data with ease in a familiar setting. It eliminates re-keying of data, and was designed with both business and IT users in mind. In addition to simplified update capability, CONNX for Excel also has the ability to validate data and provide statistics regarding the Excel data and the data source table(s).