Re: Oracle Gateway for SQL/400??

In article <3foq3d$dq5_at_dcsun4.us.oracle.com>, bmanry_at_ibmgate-aix.us.oracle.com (Bill Manry - MainframeBmanryIntegration) says:
>
>Anders Volle (volle_at_oslonett.no) wrote:
>>According to Ora. Corp there is a gateway product that enables an Oracle
>>database to communicate with the SQL/400 database on a AS/400.
>
>Hello Anders,
>
>Just to clarify: Oracle has two gateways that provide access to AS/400
>data. Both provide full read and write access to AS/400 tables, with
>write access integrity protected by Oracle's 2-phase commit mechanism.
>Which one you choose depends on your networking preferences, available
>machine resources, and other factors.
>
>The Transparent Gateway for AS/400 runs on the AS/400 along with either
>SQL*Net TCP/IP or SQL*Net APPC. Oracle (UNIX or other) instances use
>SQL*Net to talk to the gateway; the gateway uses the AS/400's local
>access mechanism (SQL/400) to read and write AS/400 tables.
>
>An alternative is the Transparent Gateway for DRDA, which runs on
>RS/6000 AIX, HP, and Sun Solaris. This product is based on IBM's DRDA
>protocol and uses SNA LU6.2 (native, not SQL*Net) communication
>between the UNIX box and the AS/400. Oracle instance(s) using the
>gateway typically are on the same system as the gateway but can also
>be remote, using any supported SQL*Net protocol for database-gateway
>communication. This gateway can also access other databases with
>"DRDA server" capability, including DB2/MVS and DB2/VM (aka SQL/DS).
>
>These products have been shipping for quite a while, so perhaps we'll
>see followups from a user or two.
>
>Hope this helps.
>
>/b
>----------
>Bill Manry - Mainframe and Integration Technologies - Oracle Corporation
>Standard disclaimer applies.

I've used the TGW4AS400 and it works just fine. I used an Oracle7 server on a Solaris box as an integrating server... Performance is a "challenge" but with proper user coaching it can be managed. Received on Sun Jan 22 1995 - 05:11:03 CET