How to connect SAP with external Oracle database on Win2000

[Former Member]

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

[b1jdm]

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]

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]

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