cancel
Showing results for 
Search instead for 
Did you mean: 

Native SQL to an external oracle database

Former Member
0 Kudos

Hello experts,

I like to read some data from an external oracle database with native sql statements.

Which prerequisites are neccessary to do so?

In detail: which customizing must be performed?

Wich authorizations are necessary on the local SAP-system and on the oracle-site?

Many thanks for your help!

Best regards

Elmar

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member204746
Active Contributor
0 Kudos

first, you need the SAP database library for Oracle. on Windows, filename is dboraslib.dll

then, you create a user ID on your external database

then ,you configure table DBCON

read:

https://forums.sdn.sap.com/click.jspa?searchID=9272762&messageID=1193314

https://forums.sdn.sap.com/click.jspa?searchID=9272762&messageID=2806510