MS Windows Applications and ODBC

The Perfect Combination for Mainframe SOA. When it comes to integrating IMS assets into today's SOA applications, some companies are settling for mediocrity. Learn how Ivory raises expectations.

New report examines GT Software's mainframe SOA solution suite. How GT Software solves the problem of SOA participation and addresses the needs of mainframe transactions.

Download Now! A roundtable discussion on success strategies and best practices for Mainframe SOA featuring: Glenn Schneck, SunTrust & Steve Craggs, IC European Chairman

ODBC (Open Database Connectivity) is an industry standard protocol that greatly simplifies system-wide utilization of data. Ivory® Data Access contains an ODBC Server component and an ODBC driver. They 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. As an alternative to SQL commands, access can also be performed using individual user logic.

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 effective and they are even carried forward to the new platforms; Ivory Data Access uses the SAF interface and can be fully integrated into standard ecurity packages like RACF, ACF/2 or TOP/SECRET.

ODBC Support for Source 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 Target Data

Most applications running under MS Windows support ODBC (i.e. MS Office, LOTUS, Seagate Info 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 media
  • Support of all common ODBC standards
  • Direct SQL access to mainframe data using the Ivory Data Access API for application that do NOT support ODBC

Click here to request additional product information