1 Reply Latest reply: Mar 8, 2011 3:13 AM by wkobargs-Oracle RSS

    Data loading from Oracle to SQL Server

    845568
      Hi,

      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.

      Regards,
      Sajal
        • 1. Re: Data loading from Oracle to SQL Server
          wkobargs-Oracle
          Hello,

          please start reading here about the Oracle Database Gateways products:

          http://www.oracle.com/technetwork/database/gateways/index-100140.html

          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

          Regards
          Wolfgang