Skip to Content
author's profile photo Former Member
Former Member

External database connection

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?



Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jun 18, 2004 at 03:48 AM

    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.


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.