cancel
Showing results for 
Search instead for 
Did you mean: 

Connenct Oracle 11g with SQL Server 2008

Former Member
0 Kudos

Hi Friends,

We are running ECC 6.0 on Oracle 11g and HP-UX 11i v3 OS.

We have SQL Server 2008 now we have to connect the SAP ECC 6.0 Oracle database on HP-UX with SQL Server.

Kindly suggest us how can be do teh same ?

Regards

Ganesh Datt Tiwari

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

From 1601608 - How to access an external Microsoft SQL Server database:

If your system comprises solely of ABAP stack-based servers running on Unix platforms you can neither use UDConnect nor DBCON. Why? Because UDConnect requires at least one Java-stack based SAP Application Server (regardless of the operating system) and DBCON requires at least one Windows- or Linux x86_64-based SAP Application Server.

Regards,

Roman

former_member188883
Active Contributor
0 Kudos

Hi Ganesh,

As you might have understood the solution, request you to close this thread.

Regards,

Deepak Kori

Former Member
0 Kudos

Hi Deepak,

Thanks for your kind support.

Now we have to conenct Oracle database runnig on Windows system to Oracle running on HP-UX with SAP ECC 6.0. What will be the procedure ?

Regards

Ganesh Datt Tiwari

former_member188883
Active Contributor
0 Kudos

Hi Ganesh,

For oracle database you may use Create Database Link mechanism. For details refer oracle docs.

http://docs.oracle.com/cd/B12037_01/server.101/b10759/statements_5005.htm

Hope this helps.

Regards,

Deepak Kori

Former Member
0 Kudos

What do you want to do with secondary database? What access you need to perform. If you want simply fetch data from secondary database with SQL commands you need to use DBCON (AS ABAP) or UDConnect (AS Java) mechanism (see above note). You don't have to worry about dbsl library as this is the same DBMS as your primary DB. If you need more sopfisticated access then describe your requirements.

Regards,

Roman

Former Member
0 Kudos

Hi Roman,

Thanks for your reply.

We have primary site with Oracle 11g ECC6 ehp5 on HP-UX m/c. At secondry site we have Oracel 9i installed on Windows m/c with OS Windows XP Professional.

Now we have to pull data from secondry site to our primary site.

Kindly suggest how can be do that ?

Regards

Ganesh Datt Tiwari

former_member188883
Active Contributor
0 Kudos

Hi Ganesh,

Use the link I had shared. It is easy and handy. Additionally you may use ABAP program along with DB link and generate required data into abap.

Regards,

Deepak Kori

former_member188883
Active Contributor
0 Kudos

Hi Ganesh,

Refer this thread on how to use ABAP program to connect to remote database

http://scn.sap.com/message/5179376

It will be handly in pulling data from remote oracle database.

Regards,

Deepak Kori

Former Member
0 Kudos

Hi Ganesh,

Along with ABAP program you have to create External DB Connection using DBCO t-code.

Also maintain the tnsnames.ora file under /sapmnt/SID/profile/oracle & $ORACLE_HOME/network/admin path.

After maintaining this file will be like below.

################

# Filename......: tnsnames.ora

# Created.......: created by SAP AG, R/3 Rel. >= 6.10

# Name..........:

# Date..........:

# @(#) $Id: //bc/701-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/TNSNAMES.ORA#1 $

################

SID.WORLD=

  (DESCRIPTION =

    (ADDRESS_LIST =

        (ADDRESS =

          (COMMUNITY = SAP.WORLD)

          (PROTOCOL = TCP)

          (HOST = <YOUR SAP SERVER HOSTNAME>)

          (PORT = 1527)

        )

    )

    (CONNECT_DATA =

       (SID = <SID>)

       (GLOBAL_NAME = <SID>.WORLD)

    )

  )

<DBCO CONNECTION INFO PARA>.WORLD=

(DESCRIPTION =

   (ADDRESS_LIST =

     (ADDRESS = (PROTOCOL = TCP)(HOST = <EXTERNAL DB>)(PORT = <>External DB PORT>))

   )

   (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = <DBCO CONNECTION INFO PARA>)

      (GLOBAL_NAME = <DBCO CONNECTION INFO PARA>.WORLD)

   )

)

Hope this will help.

Thanks,
Sachin

Former Member
0 Kudos

Hi Sachin,

Thanks for your valuable reply.

Regards

Ganesh Datt Tiwari

former_member188883
Active Contributor
0 Kudos

Hi Ganesh,

Could you provide background on why such connection is required MSSQL -> Oracle

Regards,

Deepak Kori

former_member188883
Active Contributor
0 Kudos

Hi Ganesh,

Connection of Oracle database to MSSQL can be done using JDBC bridge. How to do it is mentioned in the SAP note 1601608 - How to access an external Microsoft SQL Server database.

In this Note refer section 2. How to setup a connection with UDConnect.

There is also a step by step document attached in this section.

Hope this helps.

Regards,

Deepak Kori