Ivory Data Access is a rich set of components that enables any enterprise to find the right solution for every mainframe data integration and access scenario, from integration of mainframe data into office applications, to bi-directional synchronization of mainframe and non-mainframe data sources, with support for transaction processing.
- SELECT, INSERT, UPDATE and DELETE via standard SQL to all mainframe data sources (flat, hierarchical, relational)
- Standard ODBC/JDBC drivers for all platforms
- Bi-directional access to distributed data sources (Oracle, SQL Server, etc.) from the mainframe
- Fully transactional (two-phase commit)
- No coding (all configuration-based)
- Ability to pre-define "views" that are executed on the mainframe
- Easy to install and manage
- Seamlessly integrated with Ivory Service Architect for Web Service based access to mainframe data
Ivory Data Access contains a powerful SQL Processor, which allows users to address all major host-based data sources including non-relational sources from any workstation or any Web server application without coding via standard SQL. Using the listener and scheduling capabilities of Ivory Data Access the process of synchronizing the data between platforms can be automated. Two-phase commit processing is used to synchronize databases using one or more SQL statements within one transaction, and an automated data exchange feature allows users to initiate the exchange of data (either by the host or by a client) as needed.
Virtually all of today's programmers know SQL. SQL has become the industry-standard language for data manipulation. Using standard SQL commands (SELECT, INSERT, UPDATE and DELETE), Ivory Data Access allows access to non-relational as well as relational data sources. The Ivory Data Access SQL engine provides direct access to DB2 tables, IMS or DL/1 databases, Adabas databases, CA Datacom databases, CA IDMS databases, sequential files, 3270 screens, as well as various vendor-specific file systems, from a variety of open system environments or mainframe platforms.