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.