MS Windows Applications and ODBC

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

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