Q

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 first published in January 2008

Dig deeper on Oracle database administration

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