CONNX for C-ISAM
CONNX for C-ISAM provides secure, real-time, read/write SQL access to C-ISAM files on UNIX, Linux and Windows platforms using 64-bit and 32-bit ODBC OLE DB JDBC and .NET. In conjunction with other CONNX modules, you can perform seamless joins between C-ISAM and CONNX supported databases.
With CONNX for C-ISAM a single metadata model can be created that spans all enterprise data sources and applications requiring data access. The result is an enterprise-wide view of data that provides a reusable standards-based framework for information access.
CONNX performs joins between multiple C-ISAM files using a single SQL statement, otherwise impossible without custom development, and simplifies manipulation of large arrays through its unique Rotated Array Technology. The CONNX distributed SQL engine uses advanced index optimization to ensure maximum performance when retrieving data from C-ISAM files.
The CONNX for C-ISAM distributed SQL engine reduces the workload placed on the server by performing CPU-intensive operations on the client, while allowing the database engine to perform tasks for which it is best suited. This distributed SQL engine facilitates truly scaleable application development because of the additional processing power gained by the use of the client in addition to the database server.
CONNX for C-ISAM imports the metadata directly from C-ISAM COBOL copybook and Cognos PDL into a CONNX Data Dictionary file (CDD). Once, imported, the target C-ISAM file can be accessed as one or more logical tables or views.
All members of the CONNX family have the following features:
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 web/application development, data warehousing, business intelligence, data synchronization, enhanced reporting and data migration.