Skip to Content
avatar image
Former Member

How to connect SAP with external Oracle database on Win2000

Hi,

From an ABAP program i want to get data from an external Oracle database running on Win2000.

Can anybody tell me what is the smartest way to do this.

regards

Bertil Rebergen

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Apr 23, 2004 at 09:50 AM

    Bertil,

    Best approach is to use native SQL from SAP. E.g. use natibe SQL to call a stored procedure in the Oracle database. There might be some customizing involved.

    Consult http://help.sap.com on native SQL.

    Best regards,

    Harald

    Add comment
    10|10000 characters needed characters exceeded

  • May 20, 2004 at 07:18 PM

    First, define the table in SAP in the customer name space (Z). Next, use oracle tools to delete the table, now connect the table from the external database using the same name (alias) as was used when you created the table in R/3. Now when you do a select on the table in R/3, it transparently pulls the data from the external database.

    Use this at your own risk.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      You might also try using OPEN SQL for the same.

      Create a connection in DBCON table.

      Now when you first an open SQL statement.

      Use the CONNECTION ... <connectionName>.

      For example SELECT * FROM <TABLE>

      CONNECTION <connection name>.

      You might do an F1 on CONNECT to get further information.

      Another prerequisite is you create a table with the same name in the Datadictionary.

      Hope this helps.