The Oracle Access Manager for AS/400 enables AS/400 applications to access data on both the AS/400 and remote Oracle servers. The Oracle Access Manager for AS/400 facilitates enterprise-wide information management by integrating your AS/400 applications and data with distributed data on desktop and UNIX systems.

Challenge: Integrating Distributed Data
Since the advent of client/server and open systems technology, diverse computing environments have increasingly become the norm. A typical computing environment today may be comprised of a variety of applications with data in different formats --- and a mix of platforms. In a single company, data is likely to be dispersed across several mainframes, multiple UNIX servers, and hundreds of desktop systems. Accessing and integrating these diverse environments has become the current challenge.  

Open Up Your AS/400 

The Oracle Access Manager for AS/400 helps you meet this challenge by providing your AS/400 applications access to Oracle data on any platform. Through this access, you can leverage your investment in existing AS/400 hardware and applications. The Oracle Access Manager for AS/400 complements the functions of the Oracle Transparent Gateway™ products, which allow Oracle tools and applications to access data on the AS/400. Together, these products help you fully integrate your AS/400 with all your other systems.

Transparent Access

With the Oracle Access Manager for AS/400, AS/400 applications written in RPG, COBOL, and C can access both DB2/400 and remote Oracle data. This access is completely transparent. AS/400 end users can read and write information without even realizing where the data resides. Ad hoc SQL statements can also be issued with the same level of transparency. 
  
Powerful SQL Access
With the Oracle Access Manager for AS/400, you don't need to code to a proprietary API. Instead, AS/400 applications can interface seamlessly to Oracle using ANSI standard SQL as well as Oracle extensions. PL/SQL™ is also supported, allowing you to call remote Oracle stored procedures from your AS/400 applications. 
   

KEY FEATURES
Configuration The Oracle Access Manager for AS/400 resides on the AS/400 machine Number of users limited only by underlying operating system and the DB2/400 database  Network Adapters Oracle Net provides network communications between AS/400 applications and remote Oracle servers Oracle Net is included with the Oracle Access Manager for AS/400 with the TCP/IP adapters  SQL Implementation Interface to Oracle servers using standard ANSI/ISO SQL Oracle extensions to ANSI/ISO SQL Powerful PL/SQL procedural extension to ANSI/ISO SQL Supports Oracle Data Manipulation Language (DML) and Data Definition Language (DDL)	Seamless Distributed Access Provides read/write SQL access from the AS/400 to Oracle  Leverages your investment in AS/400 applications by accessing both AS/400 data and open system data Allows access from the IBM DB2/400 Query Manager and SQL Development Kit  Allows access from RPG, COBOL, or C applications  Allows multisite Joins of data from multiple Oracle servers  Used in conjunction with other Oracle Integration products, the Oracle Access Manager for AS/400 allows your AS/400 applications to access non-Oracle data, such as Sybase, Informix and DB2 Supports extension of an Oracle stored procedure from DB2/400 Query Manager and SQL Development Kit