CONNX provides simplified data access and replication solutions that preserve and enhance your underlying data sources. CONNX enables heterogeneous, secure and real-time access to disparate data sources through a single driver. This means that multiple data sources of different structure and file type can be managed as one federated relational database, allowing broad flexibility for enterprise data integration, data warehousing, data virtualization, data migration, data replication, reporting, and metadata management.
The CONNX product line provides access to virtually any legacy non-relational or relational data source through open data access technologies including ODBC, OLE DB, JDBC and .NET, providing nearly limitless user development and reporting/query flexibility.
The power of CONNX lies in its simplicity. CONNX approaches data access by unifying all data sources into a single virtualized database via a single open-standards based driver. The connection provides fast, stable, and dependable read/write access to the underlying data sources, greatly simplifying both data access and data management.CONNX Architecture diagram
CONNX Distributed SQL Engine
Data access is often a highly resource-intensive effort. While it may be critically important for users to run their reports or launch queries, it is equally if not more important to preserve the computing capacity of the database servers for the applications that own them; put simply, you wouldn't want to slow down your e-commerce platform just so you could run a sales report.
The CONNX approach to avoiding this scenario is to distribute SQL execution across both the client and the server, taking advantage of the priorities and processing powers of each one.
There are five main components to the CONNX data access model:
The CONNX Data Server translates SQL statements into the native language of the underlying data sources, rendering it invisible to the client using ODBC, OLE DB, JDBC and .NET. The CONNX Data Server provides complete user and group level security while preserving existing data source level security. It is built to minimize memory and disk resource utilization, providing low-latency, low-impact access.
The CONNX Data Dictionary (CDD) is a master repository of information on all the tables and fields to which you are connecting. It contains metadata on all underlying data sources, providing an intuitive GUI for easy table and field labeling and querying. The CONNX Data Dictionary lets you assign different names to the tables and fields, so you can create more business-relevant labels without changing anything in the underlying data sources. Use it to create multiple views of the same data depending on user needs. The CONNX Data Dictionary can reside on a shared server or directly on a client computer.
The CONNX Client orchestrates the data requests, submitting them to the appropriate data sources and returns results. It is tightly linked to the CONNX Data Dictionary, and uses standard SQL statements for data access. The CONNX Client lets you use any ODBC, OLE DB, JDBC and .NET compliant application to access your data sources.
The CONNX JDBC Thin Client provides read/write access to your data sources. It can be installed on any client computer using a Java Development Kit.
The CONNX JDBC Server works in conjunction with the CONNX JDBC Thin Client and enables access to multiple data sources from Windows, Linux and UNIX platforms.CONNX Data Dictionary
The CONNX Data Dictionary (CDD) is a repository of information describing the data tables and fields in the accessed databases, including security. The CDD contains the metadata information about each data source and provides a graphical user interface for easy maintenance of the metadata, stored procedures, integrated security and views.
The CONNX Data Dictionary: