CONNX for IMS™
Meet all of your data access, integration and management requirements whether you want to plug into mainframe, mid-tier, desktop or cloud systems. Using the industry’s widest range of database drivers, you can create a single view of multiple databases and allow real-time access to consume the data as it is being updated in real time.
CONNX for IMS provides secure, real-time, read/write SQL access to IMS™ data sources on z/OS®. In conjunction with other CONNX modules, you can perform seamless joins between IMS and most other databases.
Join IMS with multiple data sources
SQL & CONNX for IMS
Key Features
Views
CONNX supports the creation of views, which facilitate hiding table relationships from the end user. CONNX Views facilitate the creation of heterogeneous joins between multiple disparate databases.
Data conversions
CONNX supports more than 600 data types and performs bi-directional data conversions for data updates and retrieves.
Security preserved and extended
The CONNX Data Dictionary (CDD) is encrypted to secure sensitive information. It provides additional field and table-level security by group or user. CONNX also supports row level security with CONNX Views.
Table redefinition
The CDD supports multiple record layouts of the same IMS file, based on a “record type” field.
Record definition import
CONNX imports table definitions directly from IMS databases.