ERP-yMarketing data replication when built in same HANA

[Former Member]

Hello yMkt experts,

I have a question about ERP-yMarketing integration. Currently our project has SAP ERP and yMkt built in same HANA. As table structures for contact information from ERP and yMkt are different, we need to replicate contact related data from ERP to yMkt(real time is not necessary).

So what should be the best integration solution in this senario and is there any document I can refer to?

Thanks in advanced,

Marshall

[former_member183196 · Accepted solution]

Marshall,

Integration with SAP ERP has two main areas: 

1. master data

2. transactional data such as sales orders

Sounds like you have co-deployment scenario where SAP ERP and yMKT are running on the same HANA system. In that case, you could do scema mapping to point yMKT's ERP schema and run extract reports CUAN_IC_MASTERDATA_EXTR_FULL/DELTA.  This will get the contact master data loaded into interaction contacts.

Then if you use "Customer" based segmentation profile, you can even segment sales data automatically as HANA views point to ERP schema.  if you need to use "contact" segmentation profile, then you have develop custom HANA views on top of ERP sales data tables to bring it into segmentation.

Hope this helps

Thanks

-Bharath

[Former Member · Accepted solution]

Dear Bharath,

Thanks for your answer!

Our integration involves both the two parts:

1. master data

2. transactional data such as sales orders

        For example: in ERP table, there are some custom fields for customer which are needed to be replicated into yMKT contacts tables (then we can check the information from yMKT contact profile).

        I found the following steps from PPT 1602_RKT_hybris_Marketing_SCI_Inbound.pptx page24.

1. With the replication of source data to the SAP HANA system, the database trigger in the SAP HANA system fills the trigger log table.
2. The extraction program evaluates whether the interaction contact has to be inserted, updated, or deleted with the help of the trigger log table and a SAP HANA view,.
3. Save the interaction contacts with the help of the SAP function module.
4. Reset the trigger log table entries for the edited interaction contacts.

But we do not have any experience for the extraction program creation/modification and has no thoughts even referring the PPT slides…

Could you please provide some sample code/more details about how to create the custom extraction program?

Thanks and looking forward to hearing from you!

Jasmine