Unable to extract data from Non SAP DB in SAP BW
I have configured 2 Oracle 9i Non SAP DB systems with SAP BW system (SAP BW 7.0 Orace 10g system).
Up till now I have understood that in order to have to integrate Oracle 9i to BW system - TSNNames.ora has to be updated, then create new Logical system, then Create Source system in RSA1 with all the required information (Maintain DBCON table). Create user at Oracle 9i end which will be used for the connection.
When I run a report "RORAMDBC", it shows all the external Oracle DB (configured in DBCON) connection enabled.
When I try to extract/Execute Table/View data in RSA1 [Right Click Source System - Additional Functions - Select Database Tables (3X)]
I get message - There is no table in database system ESAORA
I am able to see the views only which are created in his own schema.
Can anyone tell me if we need to provide any more authorizations or configurations from DB or SAP point of view.
The Table/Views we want to extract belong to SYSADM & we have SELECT Access over these views, but we still not able to view them through SAP.
I can view them If I query at DB level. Does have any constraints to view tables/views of other's schema though we have required authorizations.
Thanks & Regards