How to connect to external DB from SAP ?

Former Member · ‎2012 Jul 26

Dear Experts ,

i want to connect to integrate between SAP and other system , so we made an external db in which one system insert data into it and the other retrieve from it ,

that DB will be Sql Server or Oracle according to what is easier to connect to from sap ?

when i searched for how to connect to external DBs , i found a lot of articles with different opinions and nothing works well with me , so if it is available i want

an accurate way to connect to external DB from SAP

can you help me in this issue ?

ThomasZloch · ‎2012 Jul 26

Which are the options that you looked at? This is so that both sides save time by not suggesting what you already dismissed.

Thomas

Former Member · ‎2012 Jul 26

if the both options are available and easy to connect , i want to connect to oracle DB

ThomasZloch · ‎2012 Jul 26

You said that you looked at a lot of articles with different opinions, these were probably suggesting techniques to connect to exernal DBs from SAP. Which are the techniques that did not work well for you?

Thomas

Former Member · ‎2012 Jul 26

i tried to use the tcode dbco to declare connection and use it , but it didn't work , also i tried to use connection string directly but also it didn't work

do you have tried any method to connect to external db and worked well with you and you are sure of that , if yes just tell me about it , and i'll use it .

i just want to know a trusted and tested way , because i don't have great experience in sap

ThomasZloch · ‎2012 Jul 26

I would use DBCO, and this usually works fine when setup correctly. Check with your system administrator.

I recently tried the ADBC classes for accessing the data, alternatively you can use native SQL.

Thomas

http://help.sap.com/abapdocu_702/en/abenadbc.htm

Former Member · ‎2012 Jul 27

Dear Thomas Zloch

thanks a lot for your effort and your help , but may i ask u

what are the prerequisites if i want to connect to SQL Server DB ? in another way , what is should be installed on my server , i heard about DBSL but i don't know whether that important or not ,

i think the problem is in something missing and must be installed ,

also

i want to know how to connect to oracle DB

according to the below link

http://help.sap.com/saphelp_nw04/helpdata/en/50/63d6b37bda7f4a92e2dec21b14ceee/frameset.htm

i knew how to connect to Sql Server through DBcon and what is the format

of Conn. Info. Field

can you help me in these issues ?

and many thanks again