Summary: | Using the Data Extraction Utility to ensure CRM Online is compatible with Paribus 365™ Data Cleansing |
Article Type: | How-To Guide |
Related Product(s): | This article relates to the following products:
|
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.
Related Resources: |
|
Further Information: |