|CONNX for RMS Features:|
|ODBC, OLE DB, JDBC or .NET Support||Popular applications have access to RMS data for real time queries.|
|Metadata Import||CONNX directly imports RMS metadata from COBOL copybooks, Digital's common Data Dictionaires, DIBOL, VAX Basic File Description, Powerhouse PDLs and a CONNX Text Specification file format into a CONNX Data Dictionary file (CDD).|
|Extensive Security||Protection to the field and record level. Encrypted metadata security.|
|Heterogeneous Views||Allows Heterogeneous Joins|
|Custom Data Type Conversion||Supports over 600 conversions|
|Full SQL Support||Multithreaded Asynchronous Execution|
|Full Transaction Support||Perform inserts, updates and deletes in a complete unit of work|
|Single sign-on reduces complexity||Provide transparent user access to multiple data sources|
|ANSI SQL Support||Compatible and consistent queries to all databases|
|Distributed SQL Processing||Reduces workload on the server.|
|Java™ and WebSphere® support is native||Web integration or enablement projects can quickly have direct access to RMS data.|
|VMS Remote Procedure Calls||Allows remote execution of batch jobs, procedures and applications|
|Data Sheet||CONNX for RMS|
|Data Sheet||Why You Need CONNX|
|CONNX Technology Paper||CONNX Scalability|
|Diagram||CONNX Product Architecture|
|Demonstration||Watch the CONNX Demo|
The CONNX for RMS module provides secure, real-time, read/write SQL access to RMS files on the VAX, Alpha and HP Integrity Servers running OpenVMS. In conjunction with other CONNX modules, you can perform seamless joins between RMS and most other 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 by performing CPU-intensive operations where the CONNX client resides (Unix, Linux or Windows. i.e., remote desktop, Web and/or application server), while allowing the database engine to perform tasks for which it is best suited. This distributed SQL engine facilitates truly scalable application development because of the additional processing power gained by the use of the client PC in addition to the database server.
CONNX for RMS directly imports RMS metadata from COBOL copybooks, Digital's common Data Dictionaires, DIBOL, VAX Basic File Description, Powerhouse PDLs and a CONNX Text Specification file format into a CONNX Data Dictionary file (CDD). Once, imported, the target RMS file can be treated as one or more logical tables or views.