Hi, how can I make an Oracle synonym to an external MS SQL Server table? Via create synonym, create database link, ODBC, through the firewall and connect with Username and Password to an external SQL Server Table anywhere in the world? What have I to do with the File TNSNAMES.ORA and what are the statements???
In order to access non-Oracle tables, you'll need to do a few things. First, you'll need to get ahold of a product called Heterogenous Services (HS). Once upon a time, this product was an extra cost. But I believe that it is now a free product. You'll have to verify this with your Oracle representative.
After you install then you just need to configure an ODBC connection to your non-Oracle database. From there, you just create a database link as normal and you can access non-Oracle datasources directly through SQL queries. The HS documentation gives you step by step instructions.
For More Information
- Dozens more answers to tough Oracle questions from Brian Peasland are available here.
- The Best Oracle Web Links: tips, tutorials, scripts, and more.
- Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical Oracle and SQL questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.