topic Oracle Connection from ABAP Program in Application Development and Automation Discussions

Oracle Connection from ABAP Program

Former Member — Fri, 12 Dec 2008 02:35:18 GMT

Hello everybody,

I need to connect to an external database in another server from ABAP Program, now I've reading some Blogs and Thread about it but I'm really lost in wich are the actual steps to do this, I've read about a "tnsnames.ora" file, but I have the next doubts:

- This tns file exists in the sap server where is running the ABAP Program or in the Oracle database server or in both??

- Wich should be an example or what it needs to be written in the CON_ENV field of the DBCON table entrie.

- The CON_NAME can be any name or it should have relation to the database name or something like that?

I would really appreciate any kind of help cause I've never done this before with any external database so I don't know the steps to do this, I'm clear on the ABAP Code to connect but I'm lost in the DBCON entrie and any other steps necessary for this, I'm actually reading SAP Notes but they're very confuse about this, thanks in advance for your help.

Regards,

Paul

Re: Oracle Connection from ABAP Program

former_member222860 — Fri, 12 Dec 2008 05:39:09 GMT

Hey,

Here goes some answers:

1. TNS file can be found at Oracle database, here's is ex. path

C:\oracle\ora81\network\ADMIN

2. Regarding DBCON entry, look at this help link

http://help.sap.com/saphelp_nw70/helpdata/en/9c/d736b880c34f76b507bac7751a0474/content.htm

thanks\

Mahesh

Re: Oracle Connection from ABAP Program

Former Member — Tue, 16 Dec 2008 20:54:20 GMT

Thanks for your answer, I've read the help you gave me, now the system where is my ABAP Code is a IBM Database, and the DB I'm trying to connect to is a Oracle Database, now the TNS name should be in the TNS File in the Oracle System?, and how is that going to help me in the DBCON table???, maybe I'm approaching this incorrectly, do you think????

Regards,

Paul

Re: Oracle Connection from ABAP Program

Former Member — Tue, 16 Dec 2008 22:25:55 GMT

Did you gone through these below Web Blogs?

[Using ABAP to access non-SAP databases|https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/11543] [original link is broken] [original link is broken] [original link is broken];

[Suck that data out ! Connect from Oracle to MaxDB|https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/6225] [original link is broken] [original link is broken] [original link is broken];

[Configure DBCO (Database Multiconnect) on IBM i5/iSeries|https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/4198] [original link is broken] [original link is broken] [original link is broken];