External database connection

[Former Member]

We are running SAP on Oracle Database. Now we have to connect to another external database through ABAP program, which is also Oracle. We have to connect to this external databse to get some files. We tried with some entries in DBCON table. But it is not working?

Has anybody done this? Any ideas?

Thanks

Suresh

[Former Member]

Hi Suresh,

I am not aware of which version of SAP you are working with.

But there are 2 ways of doing it to my knowledge.

1. Make entries in DBCON table, then subsequently when firing the OPEN SQL statement specify the name in CONNECTION parameter for the OPEN SQL statement. But a prerequisite for this is that a table with similar name and structure needs to be created in SAP as exists in external database.

In effect what we are providing here is that instead of using the DEFAULT database which is the one with SAP make use of this new connection, rest of the processing would happen automatically. You might get more detailed information by doing an F1 on CONNECTION

2. Use of Native SQL to connect to an external database. In Oracle I think you can make use of CONNECT command, so you would fire NATIVE SQL queries from ABAP.

Hope this helps, I believe there is already a discussion on External Database connections, you follow that.

Pavan