Skip to Content

SAP HANA XSA data replication from classic SAP CRM

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Feb 12 at 03:15 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 12 at 06:01 PM

    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:

    I also have an example of the access from an HDI container here:

    Add comment
    10|10000 characters needed characters exceeded

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