The Oracle Transparent Gateway for EDA/SQL dramatically broadens the number of mainframe data sources that you can reach, integrating your legacy data into an open systems environment. The Gateway is part of the family of Oracle's Integration products, a comprehensive suite of solutions designed to integrate heterogeneous applications and data stores.

Enterprise-wide Data Access

Access to up-to-date, complete information is critical to making informed business decisions. But accessing that information can be difficult --- particularly if your data scattered among different systems, stored in different file formats, and seemingly impossible to merge.

Oracle Transparent Gateways give you complete access to your information --- enabling data distributed across a variety of storage systems to appear as if within a single, local database.

Seamless Integration of Legacy Systems

The Oracle Transparent Gateway for Enterprise Data/Structured Query Language (EDA/SQL) provides seamless, transparent access to data residing in 15 legacy OS/390 data stores. You can streamline operations, analyze data in real-time, and minimize data redundancy and inconsistency.

Turnkey Solution

The Oracle Transparent Gateway for EDA/SQL is a complete, ready-to-use solution that combines proven technologies from Oracle and Information Builders --- with no special programming. It provides a sophisticated set of transparent access services, including SQL statement parsing for distribution, database link processing, and datatype conversions. The Oracle Transparent Gateway for EDA/SQL also provides distributed capabilities, including multisite queries, joins, and views. For instance, you can join your VSAM and CA-IDMS data with local Oracle data using a single statement.

Transparent Access to Data

With the Oracle Transparent Gateway for EDA/SQL, Oracle users on any platform can access mainframe data without concern for the physical location of the data, the network protocol, or the operating system. In fact, users may not be aware that the data resides outside Oracle.

An employee running a graphical client/server sales projection application, for example, can base business decisions on real-time sales data --- without even realizing that the data is stored in an IMS database.

Extended Data Access

This transparency also dramatically expands your ability to access and analyze mainframe data using hundreds of graphical front-end tools. For example, using Oracle's Development or Business Intelligence tools, you can easily develop a decision-support application on a desktop system which integrates your legacy data. You can also use popular non-Oracle tools, such as Lotus or Microsoft Excel, to access mainframe data.

Hardware and Software Requirements

The Oracle Transparent Gateway for EDA/SQL runs on OS/390 or z/OS, along with Information Builders' EDA/SQL Server. An Oracle Database instance is also required, running on any Oracle-supported operating system.
 
   

KEY FEATURES

Data Store Support Provides access to multiple foreign data stores including: VSAM  IMS CA-IDMS/DB  ADABAS CA-Datacom/DB Model 204 Teradata System 2000 SUPRA TOTAL ISAM QSAM FOCUS Infoman  Ease of Implementation Provides an integrated solution consisting of the Oracle Transparent Gateway for EDA/SQL, Oracle9i Database, Oracle Net Services, and Information Builders EDA/SQL Server Simplifies ordering and implementation: complete package available from either Oracle or Information Builders Datatypes Performs mapping between Oracle and foreign data stores Supports Oracle datatypes, including CHAR, NUMBER, and RAW for use by Oracle applications Oracle Net Services  Provides network communications between client and gateway using industry-standard TCP/IP.

Access Capabilities Provides SQL access to z/OS and OS/390 data  Enables distributed access to foreign data, including multisite queries, joins, and views, each performed in a single SQL statement  Easy Data Migration Allows migration of data between non-Oracle data stores and Oracle databases with a single SQL statement Provides easy data movement from non-Oracle data stores to workstations or PCs for data manipulation and analysis Security Integrates with SAF-compliant security managers (including RACF) Enforces non-Oracle data access authorization for remote logon SQL Language Uses ANSI/ISO standard SQL Provides Oracle data dictionary views of foreign data Supports most Oracle Data Manipulation Language (DML) SQL extensions Tools Supports a wide range of Oracle tools, including: Oracle9i Application Server Oracle Precompilers Oracle Call Interface SQL*Plus Supports most third-party tools available for Oracle