telephone +44 (0) 1924 500 151
CONNX Architecture

CONNX is a Data Access and Integration solution that preserves and enhances database systems by providing heterogeneous, secure and real time access to disparate databases through a single driver. This means that disparate data sources can be treated as one relational database, allowing the enterprise complete database flexibility.

The CONNX product line provides access to several types of databases through open data access technologies including SQL, ODBC, OLE DB, .NET and JDBC. CONNX is compatible with ANY ODBC, OLE DB, .NET and JDBC compliant front-end application, thus providing flexibility for end users. CONNX also supports a vast amount of database specific data types for data conversion.

Enterprise database solutions with CONNX include:

Connectivity "pipe" for SQL, ODBC, OLE DB, .NET and JDBC compliant applications
Data Migration
Data Synchronization
Application Development
Internet/Intranet/Extranet Development
Enhanced Reporting
Reusable Metadata Management
Data Warehousing

Click here to see a diagram of CONNX Architecture

Above is the CONNX enterprise data model. CONNX has a distributed SQL engine, meaning that the work of processing queries is distributed between the client and the server. Most of the CPU intensive query processing, such as data conversion and sorting, is performed on the PC. All of the data retrieval is performed on the server. In the case of desktop databases such as DataFlex or Access, all processing is done on the PC because there is no server component. The following table shows the distribution of labor in the CONNX architecture:

This distributed architecture has several advantages:

  1. When performing joins, significantly less data is sent across the network because no duplicates are transmitted.
  2. The workload on the data server is minimal, because CPU-bound tasks are moved to the client, resulting in a reduction of load on the data server and better performance across the enterprise.
  3. When several users are issuing queries simultaneously, the CPU power of each client computer is utilized in addition to that of the server, resulting in true parallel processing. This makes CONNX highly scalable to a large enterprise.
Client Server
Meta Data Retrieval (CONNX CDD)
First Pass SQL Optimization
Partial Joins
Extended SQL Functions
CONNX Security
Indexed Retrieval
Non-Index Retrieval
Partial Joins
Data Compression (If Requested)
RPCs (Remote Procedure Calls)
Database Security (Client)

The CONNX approach to data access is to treat all of the different data sources as a single database, providing access to all data in the enterprise through a single open standards based driver. CONNX provides secure read/write access to the data in these systems using five main components:

CONNX Data Server
CONNX Data Dictionary
CONNX Client
CONNX JDBC Thin Client

CONNX supports databases on the following host database platforms:

Operating System Database
Itanium/Alpha/OpenVMS RMS, Rdb, DBMS
Windows 200x/XP SQL Server
IBM Mainframe VSAM, IMS
Windows 200x/XP DB2 Universal Database 5.0 through 6.1
Linux DB2 Universal Database 6.1
IBM OS/2 Warp Server DB2 Universal Database 5.0 through 6.1
IBM OS/400 V3R1 Through V4R4 DB2/400
IBM OS/390 DB2 5.1 and DB2 6.1
IBM MVS/ESA DB2 2.3 through DB 4.1
AIX, HP-UX, SCO Solaris, SunOS, OSF1 Sybase
AIX, OSF1, HP-UX SCO, Solaris, Win NT, Unisys, Unix Informix
AIX, HP-UX, SCO Solaris, SunOS, Linux, OSF1 CISAM, D-ISAM, Micro Focus
Windows DataFlex
ANY Oracle

CONNX Data Server
The CONNX servers for RMS, Oracle Rdb, Oracle DBMS, VSAM, IMS, C-ISAM, D-ISAM, Micro Focus, DB2, SQL Server, DataFlex and PowerFlex are full-featured data servers that translate SQL requests into the native database requests. The CONNX ODBC Driver makes the server transparent to the end user. The CONNX Data Server features include:

Complete user-level and group level security in addition to respecting existing security.
Low memory and disk resource utilization.
Complete file and/or table security.
RPC Support (for VMS only).

The CONNX Data Dictionary
The CONNX Data Dictionary (CDD) is a repository of information about the database tables and fields. It contains the meta data about the source information and provides a GUI screen for easy and intuitive querying of the database. The CONNX Data Dictionary features include:

Contains information about the databases accessed through CONNX.
Can reside on a shared server disk, or on the client computer.
Describes the structures of the tables or files being accessed.
Defines additional security for tables, views, and columns.
Multiple views of the same data are allowed, thus enhancing security and ease-of-use.
Import of existing data definition information.
Wizard assistance for common tasks.

CONNX Client
The CONNX Client is based on an ODBC driver, which is a dynamic link library that applications call to access data located in remote systems. The CONNX ODBC driver processes the ODBC function calls, submits requests to the appropriate data source, and then returns the results. The CONNX Client features include:

Tightly coupled with the CONNX Data Dictionary.
Uses Structured Query Language (SQL) as the standard for accessing information.
Provides the ability to use off-the-shelf ODBC, OLE DB, .NET and JDBC compliant applications without the need to program.

The CONNX JDBC Thin Client allows read/write access to a CONNX data source from any client machine possessing a JDK (1.02+).JDKs exist for most platforms. The CONNX JDBC Thin Client is a type 3 driver which processes the JDBC function calls and submits requests to the CONNX JDBC Server, then returns the results.

The CONNX JDBC Server handles requests from the CONNXJDBC Thin Client and accesses the target data sources. The CONNX JDBC Server component is a server component that enables access to multiple heterogeneous data sources.

The CONNX JDBC Router component is only necessary if Web applets are served by a non-Windows Web server. The router is a Java application placed on the non-Windows Web server, and routes JDBC requests to the CONNX JDBC Server.

Please click the CD to request an evaluation and realise how your organisation can benefit from using CONNX
case studies
info request
Desktop Adapter
OLEDB Adapter