MS Windows Applications and ODBC

CICS web services integration: Drive new development in the right direction

Get the details

Ivory Resource Center. Easily integrate mainframe applications & data

See for yourself

On-demand webcast. Warning: Free tools aren't really free

View recorded webcast

ODBC (Open Database Connectivity) is an industry standard protocol that greatly simplifies system-wide utilization of data. Ivory® Data Access provides an ODBC  driver that can be used to access Mainframe data sources (i.e. VSAM, DL/1, IMS/DB, ADABAS, CA-Datacom, etc.) using standard SQL commands with no programming. Access can be performed by any client/server or Web application and data can be retrieved or updated as required.

Ivory Data Access simplifies the development of client/server or Web applications with direct access to mainframe data sources, because no mainframe knowledge is required. Company specific security policies remain in effect and they are carried forward to the new platforms; Ivory Data Access uses the SAF interface and can be fully integrated into standard security packages like RACF, ACF/2 or TOP/SECRET.

ODBC Support for Target Data

One of the benefits of Ivory Data Access is that the source and target data can be any format that uses ODBC. An example would be to upload data from an MS ACCESS database directly into a VSAM Cluster. Record and field selection for the transfer can be interactively defined.

ODBC Support for Source Data

Most applications running under Microsoft Windows support ODBC (i.e. MS Office, Lotus, Crystal Reports etc.). Accessing mainframe data sources from these applications is easy and straightforward, and does not require any programming. Ivory Data Access provides the required ODBC Server or local ODBC driver to perform the direct access to mainframe data sources.

Features:

  • Direct access to mainframe data from ODBC-eligible applications
  • Integration of mainframe programs into MS Windows applications via ODBC
  • ODBC access through the local ODBC driver as well as the ODBC server
  • Bi-directional data-transfer between mainframe files and ODBC sources, with no intermediate steps or files
  • Support of all common ODBC standards
  • Direct SQL access to mainframe data using the Ivory Data Access API for applications that do NOT support ODBC

Click here to request additional product information