CONNX for RMS - ODBC RMS OLE DB RMS .NET RMS JDBC RMS simplified data access to RMS files on OpenVMS

CONNX for RMS

CONNX for RMS provides secure, real-time, read/write access to RMS files on all HP OpenVMS platforms using ODBC OLE DB JDBC and .NET. In conjunction with other CONNX modules, you can perform seamless joins between RMS and CONNX supported databases.

With CONNX for RMS 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 RMS 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 RMS files.

The CONNX for RMS distributed SQL engine reduces the workload placed on the server by performing CPU intensive operations where the CONNX client resides, 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 CONNX client in addition to the database server.

CONNX for RMS imports the metadata directly from RMS COBOL copybook, Cognos PDL, Basic, Dibol, CDD and DDL into a CONNX Data Dictionary file (CDD). Once, imported, the target RMS files can be accessed as one or more logical tables or views.

CONNX for RMS also supports OpenVMS Remote Procedure Calls, enabling the reuse of existing business logic, remote execution of batch jobs and procedures.

All members of the CONNX family have the following features:

Metadata information	Compatible with ANY ODBC, OLE DB, .NET and JDBC compliant applications
Heterogeneous Joins	Wizard Assistance & CONNX InfoNaut Query Tool
Intensive Security	Extensive Data Type Conversions
Views	Mass Record Definition Imports
Full SQL Support	Multithreaded Asynchronous Execution

CONNX SUPPORTS
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.

Click the CD to request an evaluation and realise how your organisation can benefit from using CONNX