on 03-12-2013 10:20 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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
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
Hi Ganesh,
Could you provide background on why such connection is required MSSQL -> Oracle
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.