DDevelopment & Design

Accessing Microsoft SQL Server from Oracle

Once we had a need of accessing a table on an Microsoft SQL Server database from an Oracle database. Thus we had to install Oracle Transparent Server on the computer hosting SQL Server. Oracle Transparent Services is a kind of adapter for non-Oracle servers and allows access to it through database link. During the instalation of Oracle Transparent Server you have to choose modules dedicated to particular databases. The modules can translate calls to some functions and allows to call a T-SQL stored procedure from Oracle.

Oracle Transparent Server can be downloaded from 

http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/10201winsoft.html  Description of its solution can be found here: http://oracle-apps-dba.blogspot.com/2008/04/oracle-transparent-gateways-general.html Instalation instructions are here… : http://oracle-apps-dba.blogspot.com/2008/04/oracle-transparent-gateway-for-ms-sql_16.html and here: http://forums.oracle.com/forums/thread.jspa?messageID=2720049&#2720049 However, most of the configurations files were located in the directory network\admin and not in tg4msql\admin as described I found that access to the data is slow – the simplest queries last for 4 seconds. However, increasing the efficiency is another topic.

— Previous article

<!--:en-->Solving package dependency problem using synonyms<!--:-->

Next article —

<!--:en-->Subtle feature of CONNECT BY<!--:-->

You May Also Like
DDevelopment & Design

Complex flows with Apache Camel

At work, we're mainly integrating services and systems, and since we're on a constant lookout for new, better technologies, ways to do things easier, make them more sustainable, we're trying to Usually we use Apache Camel for this task, which is a Swis...At work, we're mainly integrating services and systems, and since we're on a constant lookout for new, better technologies, ways to do things easier, make them more sustainable, we're trying to Usually we use Apache Camel for this task, which is a Swis...