Re: Oracle Transparent Gateway on AIX

We use the Oracle Transparent Gateway. It cannot comunicate with CICS. Oracle has the Procedural Gateway for CICS interfacing.

The Transparent Gateway gives an Oracle database access to a DB2 database via an Oracle database link. It does NOT give the DB2 database access to an Oracle database. Kind of a one-way street!

IBM sells DataJoiner to give DB2 access to Oracle, Sybase, etc. Again, this is database linking, not transactional.

The Transparent Gateway protects your DB2 security. We use a public database link that does not have a userid or password in its definition. This means that each user's connection to DB2 must send the userid and password that was used to connect to Oracle. Our DB2 uses the RACF exit to validate the userid and password. And, of course, DB2 also uses RACF GROUPS to determine object authorizations.

I'm not sure about your needs, but one of the three should work.

Jeroen Oosterveld wrote:

> Dear Oracle professionals,
>
> My company asked me to design a connection between an existing mainframe
> CICS-application and an Oracle 7.3 database on AIX.
>
> I got some hints, telling me to use Oracle Transparent Gateway and
> SNA-server on AIX, which could communicate with the CICS-applications on the
> mainframe-side or directly to the databases.
>
> On the mainframe side, nothing may be changed in a short period of time, so
> my idea is to simulate a 3270-emulation on the AIX side, just like a
> terminal is logging into the mainframe, and then screen-scrape my
> information from the running CICS-screen. (Of course it's a better design to
> get my information directly from the DB2- of VSAM-database, but that is very
> big problem in our company: security, security, security...)
>
> I quess, the only thing I've got to do is to build a stored-procedure in the
> database which can be called by a client running on Oracle*Forms and which
> is calling the Oracle Transparent Gateway, by using it's API (...or is it
> calling the CICS-application by just using the OTG-API's?)
>
> My questions are:
> - How do the commands in the stored-procedure look like, which are calling
> the Oracle transparent gateway?
> - How do I scrape the information from the CICS screen and give it back to
> my stored procedure?
> - Which products should I install on my RS/6000, besides of Oracle 7.3 and
> SQL*Net 2.x?
>
> If you've built a connection like this, please can you tell me your
> experience and give me a detailed description, about how I should design it
> and make it work? Actually I'm only interested in proven solutions.
>
> Thanks a lot!!!!
>
> Jeroen Oosterveld
> Postbank NV
> The Netherlands
Received on Sat May 30 1998 - 15:26:23 CDT