Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2021 Release Wave 2Discover the latest updates and new features releasing from October 2021 through March 2022.
2021 release wave 2 plan
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
I have about a million Account records, most of which have white space at the end of beginning that need to be removed as duplicate records are being created as a result of the white space.
I want the corrections to happen in a reasonable time.
Exporting then Importing the records in CRM takes a ridiculously long time (a handful of records a second).
Scribe does too.
I've been told that Import Manager (Dynamics professional solutions) can do this quickly (i.e. 1000s of records a second). However, on installing the trial, I find it even slower than Scribe or the out of the box solution.
Is there any tool that can correct data quickly?
Have you tried the Kingswaysoft SSIS connector?
As I doubt you'll need to schedule a recurring task you should be able to get away with the free version.
As Luke mentioned, try Kingswaysoft. Here is Jason's article with more details on the steps required.
I've used various tools (e.g., Scribe, KingswaySoft) to do this. However, for simple updates like the one you need to do, and for very large sets of records, I typically use the approach described below.
Once you have these pieces, it makes bulk updates in CRM fairly quick and easy.
Thanks Luke - much appreciated. This is the solution I went!
Business Applications communities