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

Using transparent gateways to access data in SQL Server

Oracle expert Brian Peasland explains how to use 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?
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 last published in January 2008

Dig Deeper on Oracle database administration

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.