Replication of HANA Views from on prem HANA to datasphere

[josephreddy2021]

Hi All,

We have on prem HANA with HANA Views (Graphical, table function based SQL based with variables and input parameters ), we don't want to develop all HANA views again in datasphere. we thought of levergaing remote tables option. So we created SDI(DPagent), SDA cloud connector based on premise HANA Connections. When i am importing HANA Views as remote tables from  _SYS_BIC. i am able to see structure. But  Input parameters and variables are not getting passed to datasphere?  wherever we have mandatory Input parameters and variables we see errors and no data. did any one faced same issue? any issue with my connectors? any other alternative solution?.

Thanks for reading this and i appreciate and welcome your inputs.

Regards,

Joe

[josephreddy2021]

Thank you . Is there any way using SQL View input parameters mapping to HANA View?

[Martin_Kuma]

yes, there is indeed. But only for ABAP connection, not SDA. Nice Blog exists as well: https://community.sap.com/t5/technology-blogs-by-sap/sap-datasphere-remote-table-dynamic-filter-push...

[Savio_Dmello]

unfortunately, when importing HANA views as remote tables, SAP Datasphere does not automatically support passing input parameters directly. You can submit this as a new idea on customer influence page

[josephreddy2021]

Thank you. I submitted. Whoever see this link, Please vote this https://influence.sap.com/sap/ino/#/idea/331473

[Savio_Dmello]

This is a crucial must have feature for organizations adopting a hybrid SAP data platform. It is also essential for organizations transitioning to SAP Datasphere, where on-premises SAP native HANA and SAP Datasphere coexist during the interim phase. Hope SAP product engineering team add this feature.