3 Replies Latest reply: Dec 5, 2012 8:45 AM by Mkirtley-Oracle RSS

    Interlink with Sql server and Oracle

    upen
      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
          Better Ask this question in apex forum

          {forum:id=137}
          • 2. Re: Interlink with Sql server and Oracle
            Kgronau-Oracle
            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
              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