CONNX for Adabas
The CONNX for Adabas module provides secure, real-time, read/write access to Adabas data sources on OS/390, z/OS, VSE, Linux, Solaris, HP-UX, AIX and Windows via .NET, ODBC, OLE DB, and JDBC.
CONNX extends ANSI 92 SQL support to Adabas data, giving users the capability of writing powerful and complex SQL statements. The CONNX Data Dictionary offers simplified metadata management that automatically imports record definitions and index information. In conjunction with other CONNX modules, users can perform seamless, heterogeneous joins between Adabas and all other data sources supported by CONNX. Session management, caching capabilities, code page support for multiple languages, and conditional formats are just a few of the CONNX for Adabas features. Click here to find out more about the Adabas SQL Gateway and Event Replicator for Adabas solutions.
CONNX delivers a single metadata model that efficiently spans all enterprise data sources. The CONNX distributed SQL engine reduces the workload placed on the mainframe 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 the tasks for which it is best suited. The efficiency of this operation yields cost-effective increases in response times. The result is an enterprise-wide view of data that provides a reusable standards-based framework for information access and that drastically lowers the short and long-term costs usually associated with complex enterprise data solutions.
CONNX for Adabas imports Predict data dictionaries or Natural DDMs through a SYSTRANS extract into the CONNX Data Dictionary (CDD), providing access to Adabas long field names and enabling the creation of reports using any of a number of standard reporting tools. CONNX for Adabas also imports Adabas metadata directly from Dynamic DDL and FDT into a CONNX Data Dictionary file (CDD). CONNX creates virtual tables to represent MU (multi-value) and PEs (periodic groups), placing a relational model on the Adabas data. CONNX allows the use of special version create table SQL grammar to describe the table layout.