connx Generix
telephone +44 (0) 1924 500 151







CONNX Architecture

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.

For example, data retrieval is performed on the server, but sorting and grouping of query results happens on the client side.

This approach has several advantages:

  1. No duplicate data is ever sent across the network, reducing network traffic and optimizing query execution.

  2. Tasks ideally suited for a client CPU are executed there, reducing server workload and maximizing the performance of the entire network.

  3. True parallel processing is made possible by running multiple user queries on the client side, enhancing the scalability of the CONNX architecture while minimizing the need to expand server infrastructure.
The CONNX Data Access Architecture At Work

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:

  • Describes the structure of the tables or files being accessed.
  • Creates a single metadata model that spans enterprise data sources and applications requiring data access. The result is an enterprise-wide view of data and a reusable standards-based framework for information access.
  • Imports metadata directly from existing file layouts.
  • Enables multiple views of the same data.
  • Allows access to data sources, including databases, flat files and OLE DB or ODBC compliant data sources.
  • Offers access to CONNX views, which combines tables from one or more data sources.
  • Facilitates automatic conversions of legacy data types to SQL data types.
  • Supports Occurs Clauses.
  • Allows importation of existing data definition information.
  • Resides on a shared server disk or on a client computer.
  • Respects all existing database security and provides additional user, group, row, field, table and database security. Encrypted metadata security.
  • Offers Password security to prevent unauthorized users from modifying the CDD.
  • Provides Wizard Assistance for common tasks.




case studies

info request





Desktop Adapter




OLEDB Adapter