Q

Using Oracle Transparent Gateways to fetch data from DB2

I have a Web site using .nst and Oracle 8i. I want to fetch data from a DB2 database. Is Oracle Transparent Gateways a recommended tool for this task?

Hi Brian, I have a Web site using .nst and Oracle 8i. I want to fetch data from a DB2 (Mpaics) database and also write back to DB2 tables. Is Oracle Transparent Gateways a recommended tool? Is it available on 8i? Is there any other solution that would have quicker real-time connectivity between the two databases?
I would highly recommend upgrading to a newer version. Oracle 8i is no longer supported and it won't be long for Oracle 9i to join it. So I would upgrade to Oracle 10g as soon as I could. In Oracle 10g, the product to connect to another RDBMS platform through a database link is called Transparent Gateways. In Oracle 8i, this same product is called Heterogeneous Services. Different names for what is essentially the same thing. This is the correct tool to connect Oracle to a non-Oracle database.
This was first published in March 2007

Dig deeper on Oracle database design and architecture

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close