This discussion is archived
3 Replies Latest reply: Dec 5, 2012 6:45 AM by mkirtley-Oracle RSS

Interlink with Sql server and Oracle

upen Newbie
Currently Being Moderated
Hi,

We are having some data's in SQL Server.
We need to Link SQL Server and Oracle Database. For Making reports in Oracle Apex.

Please any one guide me to interlink with Oracle Database

Regards,
Upendran
  • 1. Re: Interlink with Sql server and Oracle
    Sunny kichloo Expert
    Currently Being Moderated
    Better Ask this question in apex forum

    {forum:id=137}
  • 2. Re: Interlink with Sql server and Oracle
    kgronau Guru
    Currently Being Moderated
    There are 2 products you can use to link SQl Server databases into Oracle.
    The first product is for free and it is called Database Gateway for ODBC which uses a 3rd party ODBC driver which is able to connect to a MS SQl Server database - the second one is a more powerful gateway which is designed for SQl Server connections and it is called Database Gateway for MS SQL Server.
    DG4ODBC is based on a 3rd party ODBC driver and it allows you to connect with a suitable ODBC driver to any foreign database. So its capability is very limited. As mentioned, the second product is DG4MSQl and it is designed for MS SQl Server connections. It allows you also to call remote SQL Server stored procedures and also to participate in distributed transactions.
    Bot gateways allow you to define in your Oracle database a database link which you can then use to collect the SQL Server data.
  • 3. Re: Interlink with Sql server and Oracle
    mkirtley-Oracle Expert
    Currently Being Moderated
    Upendran,
    You can find more information on the gateways in this note available in My Oracle Support -

    Master Note for Oracle Gateway Products (Doc ID 1083703.1)

    Regards,
    Mike

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points