Connecting to External DB from SAP BW
Dear All,
We have installed SAP BW 3.1C on SQL Server Database.
We need to connect to an external Oracle Database. Has
anyone tried this scenario ? We are trying this thru DB Connect. We are able to connect to external DB. But after
selecting the tables we got stuck. It is saying "selection of tables ABC not allowed because of
lower case letters"
We have installed the dboraslib.dll which was there in
LIB_DBSL_1266-10001667.SAR.
How to proceed from here ?
regards
Software/Hardware used:
Software/Hardware used:
ASKED:
June 5, 2004 4:31 AM
UPDATED:
December 14, 2011 10:05 AM
RELATED QUESTIONS
- SQL 2005 Security to access 2 databases on same server via Stored Procedure
- Error in SAP after migration of OS & Filesystem data from one hardware to other hardware
- impact of SAP BO on SAP BI AND SAP BW
- how to extract data from APO to BW (Not APO's)
- trying to use MAC address authentication for AP from NPS RADIUS Windows Server 2008.
Answer Wiki:
Hi mpm966,
Unfortunately you cannot retrieve lowercase data to BW. You have to create DB views on source DB to convert the data to uppercase. Check SAP note #512739
Hope this helps
Thule
To see all answers submitted to the Answer Wiki: View Answer History.
Hi All,
i have to copy data form oracle to sap bi, can any one share the steps.
regds