Oracle tables not available in BW/4HANA(under HANA_SDA option) post connection.

[neerajnaik]

Hi Experts, we have connected Oracle system to BW/4HANA system via SDA. However, the table under the desired schema isn't visible. In RSA1, all the system connection looks fine. What could be the possible reason? Your help is greatly appreciated.

Thank You.

#SDA #BW/4HANA #Oracledatabase

[mamartins]

Check if the user created on ORACLE have the right permissions to access the table.

[neerajnaik]

Hi mamartins, Thank You for your response and apologies for my late reply. I was awaiting to get some updates from the team on the same but the issue still persists. The team have checked and the user on the Oracle database seems to have all the required permission. They are still checking n this further, Till now no resolution.

[mamartins]

Please look into this blog: https://community.sap.com/t5/technology-blogs-by-sap/using-sap-hana-smart-data-access-to-get-hana-an...