Skip to Content
avatar image
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?

Thanks

Suresh

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    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.

    Pavan

    Add comment
    10|10000 characters needed characters exceeded