CONNX for KSDS
The CONNX for KSDS module provides secure, real-time, read/write access to KSDS. In conjunction with other modules, you can perform seamless joins between KSDS and most other databases.
With CONNX for KSDS, 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 KSDS 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 KSDS files.
The CONNX for KSDS 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 KSDS imports KSDS metadata directly from COBOL copybooks and a CONNX Text Specification file format into a CONNX Data Dictionary file (CDD). Once, imported, the target KSDS file can be treated as one or more logical tables or views.