Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Oracle to Teradata

Status
Not open for further replies.

lowman42

Programmer
Jul 27, 2001
4
US
New to Oracle... and need to connect an Oracle Database to a Teradata database? Have been reading about Hetro Services but not sure what all is required??
 
You may already know more about this topic than I do, but in general, if you want Oracle to connect to a non-Oracle database, you need to install and configure the appropriate Transparent Gateway to the other DBMS. Then you can create a database link within your Oracle db that will allow you to make calls to the other db, as if it were really an Oracle db.

My install pack comes with a few Transparent Gateways, including SQL Server and Sybase, but not to Teradata. I suppose you are in the same situation, so the first thing you should do is contact Oracle to order the Transparent Gateway that you need.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top