Can we migrate specific data for an application to HANA?

[Former Member]

We are planning to develop an application in SAP HANA but can we migrate only specific data that is used by the application to SAP HANA? How to go about it? How can we migrate ERP based data (databased tables etc.) to SAP HANA?

[Former Member · Accepted solution]

Hi Abdul,

You can get data using the following ways from ERP to HANA:

a. Use database trigger based replication (SLT) to replicate database tables into HANA real-time and then join them and build views on top of them within HANA. SLT also works with non-sap based databases. More details here: https://service.sap.com/~sapidb/011000358700000604912011

b. You can use Direct extractors to load data application wise from BI content & custom extractors. More details: https://service.sap.com/~sapidb/011000358700000421852012E

c. You can also use Business Objects Data services ETL tool to load data from tables, views, extractors etc from ERP into HANA.

Hope that helps.

Thanks,

Anooj

[henrique_pinto]

Hi Yaseen,

let me know if I understood your question.

You want to migrate data from ERP to HANA, but you want to apply some filter to it (i.e. just move data from 2012+) or you want to ignore some columsn you'll not use, is that so?

If yes, you can achieve that, with both SLT or Data Services.