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...

[Martin_Kuma]

Hi Joe, as far as I know, filtering is not supported for SDA at all. Filters can be added to ABAP connection remote tables however. You can create a CDS as part of the VDM. Cheers. Martin 

[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...

[josephreddy2021]

Thanks for reply. For now i want to solve this for only HANA Views. ABAP Connection wont work for this, and the blog shows handling delta using SQL,Good one, but my requirement is to get the meta data of Variables and input parameters into Datasphere.