Using Paribus 365™ Data Cleansing with Microsoft Dynamics 365 CRM Online – Data Extraction Utility

Using Paribus 365™ Data Cleansing with Microsoft Dynamics 365 CRM Online – Data Extraction Utility

Background

Historically, Paribus 365™ Data Cleansing made use of on-premise SQL Databases to obtain your CRM data and run the Paribus 365™ matching algorithm on it.  However, with the advent of CRM Online, both Microsoft Dynamics 365 and Microsoft Dynamics CRM, Paribus 365™ Data Cleansing can no longer access the SQL Databases directly.

Solution

Running Paribus 365™ Data Cleansing requires access to a SQL database containing the data to be de-deduplicated. Therefore a Data Extraction Utility has been made to achieve this.  The Data Extraction Utility is the first step to using Paribus 365™ Data Cleansing with Microsoft Dynamics 365 CRM online, with its purpose to download all of your CRM data and sort it into a local database for Paribus 365™ Data Cleansing to use.

However, we decided to take this a step further -rather than just storing all of CRM data in the same format it was Microsoft Dynamics 365 CRM, we refine the data into information specific tables.  Consequently, this is a much better data set for Paribus 365™ Data Cleansing to match on, improving its matching efficiency.

Every time the Utility is run, you will be able to chose which CRM Entities you want to download. We then clean the database of any records relating to that entity. Thus ensuring that the new data downloaded is the most accurate representation of your CRM instance.