cancel
Showing results for 
Search instead for 
Did you mean: 

Delete duplicate customers in SAP CDC

carlos_riva
Explorer
773

Hi good morning, I am having the following case

context:
I have SAP CDC as a system to receive information from multiple sources of information from where I get customer data, but one of these sources allows customers to be repeated due to business rules.

So I'm looking for a way from CDC, to remove customers that are duplicated within CDC and leave a single record of that customer that was repeated, I was looking at the option of using Dataflow but it is quite complicated, thank you very much for your help.

#SAP Customer Data Cloud

Accepted Solutions (0)

Answers (3)

Answers (3)

KunalBansal
Active Contributor

Hello @carlos_riva,

In this case of duplicate data, only one user will have the email address as a login identifier, while for the remaining duplicate email users, it'll be listed under email addresses since the CDC System Design does not permit duplicates.

To clean up all those contacts without loginIDs, you can use a Dataflow with the following steps:

  1. Identify users with blank login identifiers.
  2.  For the list obtained in step-1, check if any users have the email address as their login identifier.

CDC loginIDs.png

I hope this answers your query to close the thread.

Thanks and Regards,
Kunal Bansal
SAP CX Solution Architect

samuelyang
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi @Ameen_Shariff 

You may find the recordings of the past live sessions on the learning site, eg. the CDC Essential one: 

https://learning.sap.com/live-sessions/sap-customer-data-cloud-essentials-1

Not all the live sessions are recorded though. 

We regularly publish/update quick learning videos on the Microlearning site,  some of them are being migrated to the learning site. 

https://microlearning.opensap.com/category/SAP+Customer+Data+Cloud/173267231

BTW while learning CDC, you can try out the ILT training hands-on exercises in our LSA systems: 

https://learning.sap.com/practice-systems/sap-customer-data-cloud-implementation-training

Good luck with your certification exam 🙂

Ameen_Shariff
Associate
Associate
0 Kudos
@samuelyang, Thanks for these resources.
samuelyang
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi @carlos_riva ,

Depending on how you integrated CDC in your solution, you can remove the duplicate profiles using the CDC API, SDK, Dataflow or Extension, etc. And how you define "duplicate" is also important, are these profiles having the same email id or user name or custom id? You can manually remove the dups or setup a dataflow to regularly and automatically remove the dups or even prevent the dups to be created in CDC in the first place. 

And if you're just starting to use CDC, you may register our live session or watch the recording at https://learning.sap.com/live-sessions/sap-customer-data-cloud-essentials-1

Ameen_Shariff
Associate
Associate
0 Kudos

Hi @samuelyang, I am preparing for CDC Certification and would need more of these recorded sessions, Could you please share if you have them

 

Thanks,

Ameen