CONNX Solutions . . . Simplified Data Access EXCEL LINK ENTERPRISE ADAPTER DESKTOP ADAPTER INFONAUT DATASYNC EII JDBC J2EE ODBC OLEDB .NET D-ISAM POWERFLEX DATAFLEX RDB POSTGRESQL SYBASE SQL SERVER INFORMIX ORACLE DB2 ADABAS C-ISAM IMS VSAM DBMS RMS
CONNX Features and Benefits Information Request CONNX for Linux/Unix CONNX for Mainframe CONNX for OpenVMS ExcelLink InfoNaut Professional (Desktop Query/Ad Hoc Reporting Tool) CONNXSOA DataSync (Change Data Capture) CONNX (Data Access & Integration) Contact Us News & Events Partners Resources Services & Support Products & Solutions About CONNX Solutions Request Evaluation Home Live chat by Boldchat
   

        HOME PRODUCTS CONNX PRODUCT ARCHITECTURE CONNX MAIN COMPONENTS

 
   

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 through the use of five main components:

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

CONNX Data Server
The CONNX servers for Oracle RDBMS, DB2, Sybase, Informix, Ingres, CISAM, VSAM, SQL Server, Oracle DBMS, PostgreSQL, Oracle Rdb, Digital RMS Files, DataFlex, and Adabas 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 & UNIX 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 compliant applications without the need to program.

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.3). 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 enables access to multiple heterogeneous data sources on both Windows and Linux/UNIX platforms.

CONNX JDBC Router
The CONNX 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.