Data replication from ABAP Program running on premise to HCP

[arijit_das]

Hi,

We have purchased "SAP HANA Cloud Platform, single application edition" from SAP Store. We have an ABAP program running on premise ECC box. We want to replicate the data returned by the ABAP program in the HANA XS Database table in HCP. After that we want to create calculation views including data from other tables too.

I do not think the HCI service is available for us in the license we purchased (not sure though). Any idea how can we replicate the data from ECC / BW into HANA tables in HCP ?

Thanks

[Ulrich_Schmidt · Accepted solution]

Hi Arijit,

it probably depends on the amount of data and the way it is generated. One possible way could be to create a remote-enabled function module that executes the ABAP report and returns the data in a table parameter. This RFM could then be called from the cloud side via JCo/RFC as described here:

https://help.hana.ondemand.com/help/frameset.htm?628bae0298e6451b998127830975a7f3.html

This requires basically two steps:

• Set up a Cloud Connector to open an RFC channel to your ECC box
• Develop a Java app on the Cloud, which uses the JCo API to retrieve the data from ECC and insert it into the HANA XS Database. (I think it is also possible to do this in an XS application -- instead of Java -- but I'm not sure about the necessary details here.)

The "opposite direction" might also be possible: e.g. extend the ABAP report to make an HTTP call to the cloud app and send the data e.g. in a zipped XML or flatfile format.

If the data size is really huge though, you will need a database replication mechanism. SAP has a few offerings for this, depending on database type and use case. (One of them is described here: https://help.hana.ondemand.com/help/frameset.htm?cdc9600ec42a47ea90f8997906e959a0.html
The standard ones may even already be included in your license?!)

Best Regards, Ulrich

[arijit_das · Accepted solution]

Hi Ulrich,

Thanks for your reply. We too initially thought about having a java application as you said. But as you correctly pointed out, we have a good volume of data to be replicated, so we are looking for some dta replication tool included in our license. Do you think SDA can fit here ?

Thanks,

Arijit

[Ulrich_Schmidt · Accepted solution]

Hi Arijit,

unfortunately I'm not familiar with licensing & stuff like that. So best is probably, if you ask your SAP account manager/contact person directly and let him find out for you?!

Best Regards, Ulrich