Problem solve Get help with specific problems with your technologies, process and projects.

Using Transparent Gateway to connect Oracle and DB2

I have one DB2 database and I am using an Oracle databse for my application. Now I want to call a DB2 stored procedure from my Oracle stored procedure. Could you please help me solve the problem. Or can you guide me on how to connect to DB2 database from Oracle environment either by creating a DBlink or by Transparent Oracle gateways? But I need to install the gateway for DB2 on my Oracle databse server. Where can I get the download of Oracle Transparent Gateway for DB2?
The Transparent Gateway software is on your Oracle installation media. If you don't have that, then you can download a copy of Oracle from Technet. In Oracle9i, Transparent Gateways was renamed as Heterogenous Services. You can find detailed information on how to set up a gateway to your DB2 database in the Oracle9i Heterogeneous Connectivity Administrator's Guide.
This was last published in November 2003

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.