Customer experience | Sales, Customer Insights,...

Bulk delete records in entities

(0) Share

Report

Posted on by Tin

1,562

Hello All,

I want to clean up my CRM data by applying some of the filters in entities, records are enormous count (near to 20 million in per entity). I tried with console, CRM bulk delete OOB option, and XRM tool kit (CDS, Bulk Delete plugin ...etc.) but all the options are not working faster. Can anyone please suggest how we should proceed in case you have faced the same issue?

While using the console I can able to delete but it's not the fastest way since having huge records will take too many days/weeks to clean up entities, even getting timeout error and OOB bulk delete will take too much time since this will follow sequential series of jobs.

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Abdul Wahab 12,119 Moderator on at

Like (0)

Report

Hi Tin Latt,

Use the console application and delete records using ExecuteTransactionRequest. Run one application in ascending of created on and another application in descending order of created on.

Let me know if I can provide you with more details.

Thanks
Regards,

Abdul Wahab
Power Platform/Customer Engagement Developer/Lead/Solution Architecture/Project Manager
Direct/WhatsApp:+923323281237
E-mail: abdulwahabubit@outlook.com
Skype: abdul.wahabubit
Linkedin: www.linkedin.com/.../

Was this reply helpful? Yes No
Suggested answer

Bipin D365 28,983 Moderator on at

Like (0)

Report

Hi,

Try creating SSIS package using Kingswaysoft.

www.kingswaysoft.com/.../installation-and-setup

Was this reply helpful? Yes No
Tin 1,562 on at

Like (0)

Report

Thanks for the reply, I want to delete near to 20 million per entity and have 20+ entities. If will go with Console this might take more time to delete and we might get a timeout and other errors as well.

Was this reply helpful? Yes No
Tin 1,562 on at

Like (0)

Report

this will work on 20 million in per entity count?

Was this reply helpful? Yes No
Suggested answer

Abdul Wahab 12,119 Moderator on at

Like (0)

Report

Hello Tin,

So the case is, that you have multiple tables for which you need to delete records. Am I right?

Let me know if I can provide you with more details.

Thanks
Regards,

Abdul Wahab
Power Platform/Customer Engagement Developer/Lead/Solution Architecture/Project Manager
Direct/WhatsApp:+923323281237
E-mail: abdulwahabubit@outlook.com
Skype: abdul.wahabubit
Linkedin: www.linkedin.com/.../

Was this reply helpful? Yes No
ankit_singhal 560 on at

Like (0)

Report

You can use SSIS packages, this is fastest way to delete without any error. Second, you can choose scheduled Power automate. Create Power automate and run that after 1 hour and delete some particular count of records like 10,000 each hour.

Was this reply helpful? Yes No