Solution : https://service.sap.com/sap/support/notes/518241 (SAP Service marketplace login required)
Summary :
This SAP Note guides importing data from an external Oracle database to a BW system (version 3.X or higher) using Database Connect. Key prerequisites include proper installation of Oracle client software on the BW server, especially for non-Oracle BW systems, which also involves adding the 'dbsoraslib' library for kernel compatibility. Efficient connection setup between BW and the Oracle system involves tnsnames.ora or sqlnet.ora configuration. Creation of dedicated database users and source views within Oracle aids in managing secure and effective data access for BW usage. Updated solutions and troubleshooting tips are periodically added to the note to handle emerging issues.
Key words :
- tools - sql syntax - db-specific functionscorresponding knowledge, 'yy-mm-dd hh24-mi-ss', 'dd-mon-yyyy hh24, sap-compatible column formatsexample, sap compatible format hhmmss, semantically relevant data arrives, sap compatible format yyyymmdd, bw including data sources, - oracle client software versionif, customer-specific solution
Related Notes :
| 606359 | FAQ: Oracle National Language Support (NLS) |
| 521230 | FAQ: Client software 9i or lower on UNIX |
| 339092 | DB MultiConnect with Oracle as secondary database |
| 323151 | Several DB connections with Native SQL |