Try the industry’s best mainframe integration solutions with
NO FINANCIAL RISK.
Discover why Ivory is so...
RAPID. EASY. PROVEN.
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.
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.
To avoid the manual definition of mainframe file structures like VSAM, Ivory Data Access can automatically import data structures defined in source programs or in copybooks. For DL/1 and IMS, segment definitions are imported from the PSB and DBD, and the columns are mapped from the COPYBOOKS. For Adabas and CA Datacom, the corresponding data dictionary system is used (i.e. PREDICT). For CA IDMS, SCHEMA data is evaluated, and information is automatically extracted to establish the proper relationships. Data selected from mainframe files can also be stored in XML format. Ivory Data Access' XML support enables e-business-applications to further process this mainframe data without mainframe know-how.
User-specific SQL queries can be defined with the Ivory Data Access administration application and stored as "Views". End users simply use the View as if it was a single table, and get exactly the data required. Ivory Data Access also supports "Joins", which can be stored centrally as Views for ease of use when needed. Joins allow multiple data sources, of same or unlike file formats, to be combined in a single query. Even mainframe and open-systems data can be combined using SQL.
Ivory Data Access also provides for direct access to any ODBC data source residing on a Windows, UNIX, or Linux platform, allowing open systems data to be read from or written to by online (CICS, IMS/DC, etc.) and batch programs on the mainframe. In addition to ODBC, Ivory Data Access can directly access an Oracle database using OCI as well as a DB2/LUW database.
The Ivory Data Access JDBC/J2EE component provides a platform-independent implementation for JAVA-based applications to access mainframe data sources via TCP/IP. In addition, the Ivory Data Access UNIX/Linux component enables open systems applications to upload and download data to and from the mainframe, without requiring a Java Virtual Machine. The Ivory Data Access JDBC/J2EE component also provides direct access to mainframe data sources from Web applications for companies that use WebSphere to gain mainframe data integration.
All Ivory Data Access components for Windows, UNIX/Linux and JAVA contain Listener functions that guarantee two-way communication between the mainframe and other systems, and facilitates secure process management.
The optional MS Windows Software Developer Kit (SDK) features the Ivory Data Access OCX programming interface, which can be used by all Windows-based OCX-capable programming languages, such as C, Visual Basic, Delphi, etc.
Using Ivory Data Access as a front end to the MQSeries API, makes the development process easier and shortens the development cycle for MQ-Series implementations.
A Windows application is provided to configure, control, monitor and analyze Ivory Data Access operations. All administrative information is stored by Ivory Data Access on a mainframe disk which is organized in such a way that it can be simultaneously accessed and maintained by authorized workstation users, via integration with Windows Explorer, as well as by host programs.
Ivory Data Access supports the SAF interface, providing simple integration into well-known mainframe security systems such as RACF, TOP SECRET and ACF2.
Click here to request an Ivory Data Access Demo
Click here to request additional product information
