Ask the Expert

Using transparent gateways to access data in SQL Server

We have source data in both Oracle and SQL Server. Our target is to create a staging database in Oracle and bring source data from both databases. Right now we have not planned for using any ETL tools for this extraction but Oracle PL/SQL. Is it possible to extract from the SQL Server also?

    Requires Free Membership to View

From within Oracle, you can use Transparent Gateways to access data in SQL Server through a database link. Oracle will think it is querying another Oracle database, but the data is coming from SQL Server. Please see the following for more information.

Oracle Transparent Gateway for Microsoft SQL Server Administrator's Guide

Another alternative is to use SQL Server's Data Transformation Services (DTS) to push data from SQL Server into an Oracle db via ODBC.

This was first published in January 2008

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: