We are trying to set up a connection between a Hana Cloud Platform (SCP) and a BW on Hana (on-premise) system. To do that, we have are already configured the SAP Data Provisioning Agent tool and registered both an ABAP Adapter and HANA adapter into the SCP Hana instance.
We would like to integrate some views and queries from the BW system into the SCP Hana instance with the Smart Data Integrator (SDI) as we have to perform some transformations.
When creating the remote source, we are wondering which adapter we need to use, the ABAP Adapter or the Hana Adapter? We have tried with the ABAP Adapter but we cannot see the any view or query...
Also, is there some configuration to do in the BW side to make visible those views and queries?
Many thanks in advance.