Software AG's Adabas SQL Gateway for OS/390, z/OS, VSE, Linux, Solaris, HP-UX, AIX and Windows Operating Systems

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.

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, 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.

Sales Info

To receive further product information or to order CONNX software please contact Shirley McKinney by phone, fax, or electronically at:

888-88-CONNX (U.S.A. only)
425-519-6600
425-519-6601 fax
Request more information or a free software evaluation

CONNX for Adabas Features:

Metadata information Compatible with ANY .NET, ODBC, OLE DB, or JDBC compliant Applications
Multiple Record Definition Imports Import of Predict data dictionaries or Natural DDMs through a SYSTRANS extract into the CONNX Data Dictionary.
Extensive Security Protection to the field and record level. Encrypted metadata security.
Heterogeneous Views Allows Heterogeneous Joins
Custom Data Type Conversion Supports over 400 conversions, including Natural dates and packed fields
Session Management Features Ability to view all CONNX for Adabas users at a glance.
Code Page Support CONNX works with Adabas data stored in different language code pages.
Support of Conditional formats CONNX offers the ability to process different layouts within one Adabas file, managed by an "indicator field"
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 Low impact host mainframe resources without sacrificing security.
Java™ and WebSphereŽ support is native Web integration or enablement projects can quickly have direct access to C-ISAM data.

Learn More

Data Sheet CONNX for Adabas
Data Sheet Why You Need CONNX
CONNX Technology Paper CONNX Scalability
Diagram CONNX Product Architecture
Demonstration Watch the CONNX Demo