The CONNX for VSAM module provides secure, real-time, read/write access to VSAM data sources on MVS, z/OS, and VSE. In conjunction with other modules, you can perform seamless joins between VSAM and most other databases.

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

The CONNX for VSAM 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). The database calls are low level and minimize impact on the database processor.

CONNX for VSAM imports VSAM metadata directly from COBOL copybooks and a CONNX Text Specification file format into a CONNX Data Dictionary file (CDD). Once, imported, the target VSAM file can be treated as one or more logical tables or views.

CONNX supports Barnard TCP/IP stack on VSAM/VSE.

Sales Info

To receive further product information or to order CONNX software please contact a CONNX Solutions sales representative 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 VSAM Features:

Metadata information Compatible with ANY .NET, ODBC, OLE DB, or JDBC compliant Applications
Metadata Import Import of the metadata directly from COBOL copybooks and a CONNX Text Specification file format into a CONNX Data Dictionary file (CDD).
Extensive Security Supports RACF/Top Secret Security
Heterogeneous Views Allows Heterogeneous Joins
Custom Data Type Conversion Supports over 400 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 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 VSAM data.

Learn More

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