We created several views in HANA Sidecar and want to use those to load data into BW system, we have the system connected using odp - sap hana information views, when i try to create Datasource, i am not able to retrieve the listed HANA views, it just spins trying to get the relevant views and hangs later. We gave the database ID the right security roles but still no use. No information in SM21 or St22 or database logs. anyone faced the similar issue and found a solution, let me know.
fyi...we opened a OSS note, waiting for SAP to respond.