Skip to Content
author's profile photo Former Member
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 a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • Posted on 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 a 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.

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.