Showing results for 
Search instead for 
Did you mean: 

How to connect SAP with external Oracle database on Win2000

Former Member
0 Kudos


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.


Bertil Rebergen

Accepted Solutions (0)

Answers (2)

Answers (2)

0 Kudos

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.

Former Member
0 Kudos

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.

Former Member
0 Kudos


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 on native SQL.

Best regards,