2022 SAP Customer Data Cloud Integration with SAP Marketing Cloud

[FLODI]

Hi All,

Actual Context:

- SAP Marketing Cloud deprecated version 2 of the ODATA Contacts API.

- SAP CDC DataFolw only supports version 2 in integration with Marketing.

FYI, the biggest problem is that version 0002 of API_MKT_CONTACT had only one entity MarketingPermission for both Permissions and Subscriptions, whereas in version 0003 and 0004 there are separate entities for Permissions and Subscriptions.

Furthermore, version 0004 manages the communication data in the AdditionalIDs section (for example, the email disappears from the contactOrigin payload).

We ask you for a technical support to understand the fundamental points of the new integration flow between SAP CDC and SAP SMC via SAP CI in order to configure the flow in an aware way.

1) Our use case concerns a scenario with a dozen different data_controllers from CDC (Parent API Keys) and one single SMC. How should we configure the flow? We need to deploy five elements for each API KEY? We need to duplicate only the main flow? Or one flow is enought for all API KEYs?

2) What does it mean to set higher or lower limits on data fetch?

3) Why does the fetch loop stop at 10 attempts and the query of each loop at 100? What would happen if we left the number too low? Are there any lower or upper bounds?

4) Why is the "select" preset to 2000? What would happen if we left the number too low? Would contact updates be lost?

5) Why is a 5 minute timer recommended? Are there any lower or upper bounds?

6) If we wanted to use version 0003, more similar to the current version 0002 that is being deprecated, what should we do? Is the flow flexible in these activities? Or does it need to rebuild the mappings and schematics from scratch?

Our doubts are related to the number of contacts and the workload to which to submit the CPI, we imagine that the mappings and the various ODATA calls are already all correct as expected.

Thank you,

Francesco

[FLODI]

Update 2022/03/03

Returning to the list of questions:

1) We need to deploy five elements for each API KEY? Or We need to duplicate only the main flow? Or one flow is enought for all API KEYs?

I answer myself (but ask for confirmation): Yes, the 5 flows will be deployed for each CDC DataController / ApiKEY.

2) What does it mean to set higher or lower limits on data fetch?

Here I await an answer from those who have tried / tested it

3) Why does the fetch loop stop at 10 attempts and the query of each loop at 100?

Here I await an answer.

I actually can't understand the choice of looping through the whole process. Wasn't it enough to make a loop for data recovery and then process them all together? There are tons of splitters in each sub-process ...

I add a detail: in the Initial Load to Replicate Customer from SAP Customer Data Cloud to SAP Marketing Cloud flow there is a loop of 100 attempts with a query on emailAccounts limited to 100. So the limit is 10000 customers? And if we had, like, 2 million, how is it preferable to do?

4) Question 4: Solved.

I would have used a local integration variable to get the delta to the last working run of the flow, but the operation is about the same.

5) Why is a 5 minute timer recommended? Are there any lower or upper bounds?

Low importance, but it would be useful to know in advance.

6) Question 6: Solved.

The flow is not that flexible.

[FLODI]

Hi Jayce,

I can confirm that there is version 0004, in fact in point 6 of my doubts I asked what it meant from a technical point of view to change the pointing and use version 0003, more similar to the current 0002 except for the Permissions and Subscriptions entities.

I went into the flow detail.

I understand that, to change the version, the mappings and schemes for Profile, Consents and Subscription will have to be updated. In addition, the url must be changed both in Post to Marketing and in the "Fetch Metadata of Contact from SAP Marketing Cloud" (a flow exploited by the "Check_Marketing_Connection" to confirm the availability of the Marketing system and avoid losing updates).

The same changes will also be made on the Initial Load to Replicate Customer from SAP Customer Data Cloud to SAP Marketing Cloud flow.

I would say to draw the conclusion that for this flow it is better not to change version 0004.

Regards

Francesco

[jayce_wang]

Hi Francesco,

I could not answer every question, but I found it uses API_MKT_CONTACT_SRV V4 in the standard iflow.

Could you please double check it from your side?

https://api.sap.com/integrationflow/Replicate-Customer-from-SAP-Customer-Data-Cloud-to-SAP-Marketing...

https://help.sap.com/viewer/8b8d6fffe113457094a17701f63e3d6a/GIGYA/en-US/7ca726396fb942429795cc2e3cf...

Best regards,

Jayce