Ask the Expert

Transparent Gateways between Oracle database and DB2

I am searching for an easy way to fetch and insert data into/from DB2. I saw a response regarding Transparent Gateways. Can you kindly give some more information regarding the tool and its abilities? Where can I read more information? Does it require special licensing? How, technically, is the connection created and used?

    Requires Free Membership to View

Transparent Gateways (formerly Heterogeneous Services -- HS) lets you interact with non-Oracle databases as through a database link. Oracle does not even know that the remote DB is not Oracle.

Transparent Gateways do require a special license. You will have to work with your Oracle salesman to obtain pricing.

For more information on Transparent Gateways, please read the Oracle docs for DB2.

This was first published in August 2007

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: