SAP HANA XSA data replication from classic SAP CRM

[former_member603479]

Hi everyone,

we started internal project based on SAP HANA Express Edition. The whole project has mainly educational purpose. We want to learn how to untilize new programming model introduced in SAP HANA XSA Development Platform. We decided to rewrite existing CRM application we've made few years ago for our client. It's based on classic SAP CRM (NetWeaver) with ABAP back-end impementations and Fiori front-end. So we wanted to replicate some of the data (few standard CRM tables filled with mock data) we used during previous development to our HANA Express. We managed to do it with SLT server but all of it was replicated to SYSTEMDB. New HANA XSA programming model are based on HDI containers and we have no idea how we can access replicated schema stored in SYSTEMDB from our hdi containers during development.

Any suggentions and links would be helpful.

[lsubatin]

Adding to Florian's response, for HXE, if you switch to replicating into the tenant DB, make sure you have mapped the space you are using first: https://developers.sap.com/canada/tutorials/xsa-tenant-db-space.html

I also have an example of the access from an HDI container here: https://developers.sap.com/tutorials/xsa-create-user-provided-anonymous-service.html

[former_member603479]

Hi again,

lsubatin, your solution doesn't work as expected. We encountered an error while granting selection on replicated schema table (please refer to log-cf.txt). We followed every step described in your tutorial (https://developers.sap.com/tutorials/xsa-create-user-provided-anonymous-service.html). We have also mapped the spaces (please refer to screenshot-2.png). Is there anything we missed?

Kind regards,

Maciej

[lsubatin]

Hi, Maciej,

The error message is saying not authorized. That means the user in the user provided service (SYSTEM in your case) does not have permissions to grant SELECT and SELECT METADATA on the schema you created (CR1_XSA).

Regards,

Lucia.

[pfefferf]

Pre-condition is that your HDI container exists in the same tenant DB respectively in the System DB in your case. If that is fulfilled you can check the documention Enable Access to Objects in a Remote Classic Schema. The newer Web IDE for SAP HANA versions have an integrated wizard for that.