Oracle Data Access

Ivory^® Data Access greatly simplifies exchanging data in heterogeneous processing environments by providing alternative methods to exchange mainframe data directly with an Oracle database:

• Direct access to Oracle databases using SQL-commands from mainframe applications (i.e. CICS, IMS/DC etc.) applications, as well as from batch programs (Open System Transparency). The Open System Transparency component can be used to join mainframe and ORACLE data.
• SQL access to all supported mainframe data sources, with direct insert of the result set into the Oracle database.

Example: Use Ivory Data Access to enable mainframe programs to process data from a SQL server or Oracle database, or even process a view that uses standard SQL commands (JOINS) to combine mainframe data from multiple sources (i.e. DB2, VSAM, IMS/DB, Adabas, etc.).

Features:

• Direct access to Oracle databases from mainframe batch or online applications
• SQL access via SELECT, INSERT, UPDATE and DELETE commands
• Easy implementation via simple API
• Bi-directional and transactional processing
• Supports synchronous and asynchronous processing
• Mainframe application sent a return code or message
• Scalable to efficiently process large data volumes

Click here to request additional product information