1 Reply Latest reply on Mar 8, 2011 9:13 AM by wkobargs-Oracle

    Data loading from Oracle to SQL Server


      I am trying to Push the data from Oracle which is running in HP-UNIX to SQL Server. But don’t know the efficient way to connect the SQL server from oracle which is running on HP-UNIX.
      I have heard about oracle Heterogeneous Connectivity but don’t know exactly how to implement it in Unix environment. If you have some guide of step by step process it will be really helpful.

      Thanks in advance.

        • 1. Re: Data loading from Oracle to SQL Server

          please start reading here about the Oracle Database Gateways products:


          HowTo articles are available on My Oracle Support:

          How to Setup DG4ODBC on 64bit Unix OS (Linux, Solaris, AIX, HP-UX) (Doc ID 561033.1)
          How to Setup DG4MSQL (Oracle Database Gateway for MS SQL Server) 64bit Unix OS (Linux, Solaris, AIX,HP-UX) (Doc ID 562509.1)

          Please read also this note:

          Functional Differences Between DG4ODBC and Specific Database Gateways (Doc ID 252364.1)

          The license for DG4ODBC is included in your RDBMS license, but you need to purchase a Third-Party ODBC driver for MS SQL Server.
          The license for DG4MSQL is not included in your RDBMS license.

          There is also a forum for the gateways:

          Heterogeneous Connectivity