Mainframe Access to Open Systems Databases

Running IMS?

Read about GT Software in the "I am IMS" feature in the IMS Newsletter.
 

Are you IMS?

Schedule A Free On-Site Workshop

Discover why Ivory is so...
RAPID. EASY. PROVEN.


Go here for proof

Enter Promo Code Web.

 

Take the survey

Open Systems Transparency - Access to open systems resources from mainframe applications

Ivory® Data Access provides for direct access to any ODBC data source, DB2, or Oracle database residing on a Windows or UNIX/Linux platform, allowing the open systems data to be processed by online (CICS, IMS/DC, etc.) and batch programs on the mainframe. The resulting real-time integration of mainframe applications greatly simplifies bi-directional data exchange and transactional processing in a heterogeneous environment, and may eliminate the need for synchronization of mainframe and open systems data sources.

For example, Ivory Data Access enables a mainframe application to process SQL-Server data or data from an Oracle database. Using simple SQL statements, this data can even be joined with mainframe data (i.e. DB2, VSAM, IMS/DB, ADABAS, etc.). The mainframe program simply calls the API for the Ivory Data Access SQL engine, passes the SQL statement (which can be a pre-defined join between mainframe and open systems data), and specifies connection parameters for the ODBC driver.

The Ivory Data Access API passes the application request to the Ivory Data Access Listener that is running on the MS Windows or UNIX/Linux workstation. The Listener extracts the data using the corresponding ODBC driver and returns the data to the Ivory Data Access SQL engine on the mainframe. If required, the SQL engine will then join the data with any other mainframe file, as specified in the SQL statement.

Ivory Data Access Open Systems Transparency for the mainframe is easy to implement and provides excellent performance when accessing open systems data, with no special network topology requirements.

Features:

  • Direct access to ODBC resources, DB2, or Oracle databases from mainframe batch or online applications
  • Resource access using simple SQL commands
  • Easy implementation via simple API
  • Bi-directional and transaction processing supported
  • Support for synchronous and asynchronous processing
  • Mainframe application will always be informed about result (Return code or message)
  • Scalable to efficiently process large data volumes

Click here to request additional product information