CONNX is a simplified data access 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:
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:
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 supports databases on the following host database platforms:
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:
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:
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:
CONNX JDBC THIN CLIENT
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.
CONNX JDBC SERVER
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.
CONNX JDBC ROUTER
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.
RMS, Oracle Rdb, VSAM, IMS, C-ISAM, D-ISAM, Micro Focus, DB2, Oracle, Oracle DBMS, Dataflex, POWERflex, SQL server and any OLEDB or ODBC data source.
CONNX is used by more than 3000 organisations world-wide to enable enhanced reporting, business intelligence, web/application development, data warehousing, synchronization and migration.