1 Reply Latest reply on Oct 18, 2016 12:32 PM by Shaik

    Oracle DB connection with SQL DB


      Hi Experts,


      need you help on below scenario.


      I have EBS machine with following specs.

      We have following Oracle ERP Machine.


      Machine Information :


      Operating System

      Oracle Linux

      Operating System Release no

      Oracle Linux Server release 6.5


      1. 3.8.13-16.2.1.el6uek.x86_64

      Database Version

      Oracle Database 11 g Enterprise Edition Release 64 Bit

      Application Version

      EBS R12 12.1.3

      Enterprise Business Suit

      EBS R12

      Above machine is Virtual Machine on Hyper-V 2012.

      All Virtual Disks are on RAID 1+0


      now i had an HRMS based application i want to connect it's database with oracle database (Having Parent Schema)


      The Other DB information are as following


      Windows Server 2012 R2

      DB : Microsoft SQL Server 2014 Express Edition


      I tried ODBC connection but its not successful.


      How can i achieve this task ?


      Message was edited by: 3124127

        • 1. Re: Oracle DB connection with SQL DB




          1. Oracle Database Gateways 11g Release 2 [dg4odbc] on windows or Linuxmachine

          2. create the DSN in Windows machine for sql server

          Go to Control Panel àAdministrative Tools àData sources (ODBC)àSystem DSN



          Edit the initdg4odbc.ora file


          Go to initdg4odbc.ora file location and edit the following parameters



          Location: E:\product\11.2.0\tg_1\hs\admin




                        HS_FDS_CONNECT_INFO = mssql     // Give the DSN name which have already created

                        HS_FDS_TRACE_LEVEL = off




          Configure the tnsnames in oracle box(Linux OS)


          Location:   $ cd $ORACLE_HOME/network/admin





                 (CONNECT_DATA= (SID=dg4odbc))



          5. Create db link in Oracle

          Sql> create public database link mlink

                    Connect to “sa”

                    Identified by “apps”

                    Using ‘dg4odbc’;       // this is tnsname entry



          Then you can check the tables you can able to access from SQL server.