IMS DB Database Support
Direct SQL Access to Valuable Mainframe Data
Employing the Progress DataDirect industry-standard ODBC, JDBC, and ADO.NET database drivers, DataDirect Shadow provides developers with direct SQL access to valuable non-relational IMS DB data.
Shadow’s high-performance set of call-level interfaces extracts IMS data definitions and schema information from a variety of places to create standard relational metadata maps. With Shadow, organizations leave mainframe data in place and avoid the cost of data replication or migration, ultimately relying on the mainframe as a true enterprise data server.
- Makes underlying mapping transparent to the developer who simply codes standard SQL calls
- Supports ANSI SQL-92 when using DataDirect ODBC or JDBC client drivers
- At runtime, translates the standard SQL from client driver into the appropriate calls for the underlying database
- Provides robust support for multiple IMS DB interfaces including OTMA, CCTL/DBCTL, and ODBA
- Offers optional "RPC Access" which runs on mainframe and manipulates IMS DB using DLI but can be called using ODBC, JDBC, ADO.NET or Web Services
- Diverts up to 99% of processing-intensive IMS DB data mapping and transformation away from the mainframe’s General Purpose Processor to IBM’s zIIP specialty engine
- Lowers MIPS capacity usage and reducing Total Cost of Ownership (TCO)
