{"id":21545,"date":"2020-04-21T14:38:18","date_gmt":"2020-04-21T14:38:18","guid":{"rendered":"http:\/\/www.paribuscloud.com\/help\/?p=21545"},"modified":"2025-06-04T10:12:06","modified_gmt":"2025-06-04T10:12:06","slug":"paribus-discovery-compatible-crm-online","status":"publish","type":"post","link":"https:\/\/www.paribuscloud.com\/help\/paribus-discovery-compatible-crm-online\/","title":{"rendered":"Using Paribus 365&#x2122; Data Cleansing with Microsoft Dynamics 365 CRM Online &#8211; Data Extraction Utility"},"content":{"rendered":"<p><!----------------------------- Article Header Start - DO NOT REMOVE ------------------------------><\/p>\n<table class=\"article-header-table\" summary=\"Article Summary\">\n<tbody>\n<tr class=\"qgkb-articleheader-table-header\">\n<td style=\"border-top: 5px solid currentColor;\" valign=\"top\" width=\"25%\"><b>Summary:<\/b><\/td>\n<td style=\"border-top: 1px solid currentColor;\" valign=\"top\">Using the Data Extraction Utility to ensure CRM Online is compatible with Paribus 365&#x2122; Data Cleansing<\/td>\n<\/tr>\n<tr class=\"qgkb-articleheader-table-summary\">\n<td valign=\"top\"><b>Article Type:<\/b><\/td>\n<td valign=\"top\">How-To Guide<\/td>\n<\/tr>\n<tr class=\"qgkb-articleheader-table-summary\">\n<td style=\"border-bottom-color: currentColor; border-bottom-width: 3px; border-bottom-style: solid;\" valign=\"top\"><strong>Related Product(s):<\/strong><\/td>\n<td style=\"border-bottom-color: currentColor; border-bottom-width: 1px; border-bottom-style: solid;\" valign=\"top\">This article relates to the following products:<\/p>\n<ul>\n<li>Paribus 365&#x2122;&nbsp;Data Cleansing<\/li>\n<li>Microsoft Dynamics 365 CRM Online<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><!-------------------------------------- Article Header End ---------------------------------------><\/p>\n<h2>Using Paribus 365&#x2122; Data Cleansing with Microsoft Dynamics 365 CRM Online &#8211; Data Extraction Utility<\/h2>\n<h3>Background<\/h3>\n<p>Historically, Paribus 365&#x2122; Data Cleansing made use of on-premise SQL Databases to obtain your CRM data and run the Paribus 365&#x2122; matching algorithm on it. &nbsp;However, with the advent of CRM Online, both Microsoft Dynamics 365 and Microsoft Dynamics CRM, Paribus 365&#x2122; Data Cleansing can no longer access the SQL Databases directly.<\/p>\n<h3>Solution<\/h3>\n<p>Running Paribus 365&#x2122; 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. &nbsp;The Data Extraction Utility is the first step to using Paribus 365&#x2122; 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&#x2122; Data Cleansing to use.<\/p>\n<p>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. &nbsp;Consequently, this is a much better data set for Paribus 365&#x2122; Data Cleansing to match on, improving its matching efficiency.<\/p>\n<p>Every time the Utility is run, you will be able to chose which CRM Entities you want&nbsp;to download. We then&nbsp;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.<\/p>\n<table style=\"border-bottom: none;\" summary=\"Article Summary\">\n<tbody>\n<tr class=\"qgkb-articleheader-table-summary\">\n<td style=\"width: 25%; border-top-color: currentColor; border-top-width: 3px; border-top-style: solid;\" valign=\"top\"><strong>&nbsp;Related Resources:<\/strong><\/td>\n<td style=\"width: 75%; border-top-color: currentColor; border-top-width: 1px; border-top-style: solid;\" valign=\"top\">\n<ul>\n<li>None<\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<tr class=\"qgkb-articleheader-table-summary\">\n<td style=\"vertical-align: top; border-top: 1px solid #e6e6e6;\"><strong><span style=\"color: #444444;\"><span style=\"line-height: 14px; font-size: 14px;\">Further Information:<\/span><\/span><\/strong><\/td>\n<td style=\"vertical-align: top; border-top: 1px solid #e6e6e6;\">\n<ul>\n<li><a href=\"\/help\/paribus-discovery\/\">Paribus 365 Data Cleansing Help Center<\/a><\/li>\n<li><a href=\"\/help\/paribus-discovery\/faqs\/\">Paribus 365 Data Cleansing FAQs<\/a><\/li>\n<li><a href=\"\/help\/paribus-discovery\/troubleshooting\/\">Paribus 365 Data Cleansing Troubleshooting<\/a><\/li>\n<li><a href=\"\/help\/paribus-discovery\/how-to-guides\/\">Paribus 365 Data Cleansing How-To Guides<\/a><\/li>\n<li><a href=\"\/help\/paribus-discovery\/technical-articles\/\">Paribus 365 Data Cleansing Technical Articles<\/a><\/li>\n<li><a href=\"\/help\/paribus-discovery\/documents\/\">Paribus 365 Data Cleansing Document Library<\/a><\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><!-------------------------------------- Article Footer End ---------------------------------------><\/p>\n<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Share this:<\/h3><div class=\"sd-content\"><ul><li class=\"share-twitter\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-twitter-21545\" class=\"share-twitter sd-button share-icon\" href=\"https:\/\/www.paribuscloud.com\/help\/paribus-discovery-compatible-crm-online\/?share=twitter\" target=\"_blank\" title=\"Click to share on Twitter\"><span>Twitter<\/span><\/a><\/li><li class=\"share-linkedin\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-linkedin-21545\" class=\"share-linkedin sd-button share-icon\" href=\"https:\/\/www.paribuscloud.com\/help\/paribus-discovery-compatible-crm-online\/?share=linkedin\" target=\"_blank\" title=\"Click to share on LinkedIn\"><span>LinkedIn<\/span><\/a><\/li><li class=\"share-print\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-print sd-button share-icon\" href=\"https:\/\/www.paribuscloud.com\/help\/paribus-discovery-compatible-crm-online\/\" target=\"_blank\" title=\"Click to print\"><span>Print<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Summary: Using the Data Extraction Utility to ensure CRM Online is compatible with Paribus 365&#x2122; Data Cleansing Article Type: How-To Guide Related Product(s): This article relates to the following products: Paribus 365&#x2122;&nbsp;Data Cleansing Microsoft Dynamics 365 CRM Online Using Paribus 365&#x2122; Data Cleansing with Microsoft Dynamics 365 CRM Online &#8211; Data Extraction Utility Background Historically, &hellip; <a href=\"https:\/\/www.paribuscloud.com\/help\/paribus-discovery-compatible-crm-online\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Using Paribus 365&#x2122; Data Cleansing with Microsoft Dynamics 365 CRM Online &#8211; Data Extraction Utility<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Share this:<\/h3><div class=\"sd-content\"><ul><li class=\"share-twitter\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-twitter-21545\" class=\"share-twitter sd-button share-icon\" href=\"https:\/\/www.paribuscloud.com\/help\/paribus-discovery-compatible-crm-online\/?share=twitter\" target=\"_blank\" title=\"Click to share on Twitter\"><span>Twitter<\/span><\/a><\/li><li class=\"share-linkedin\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-linkedin-21545\" class=\"share-linkedin sd-button share-icon\" href=\"https:\/\/www.paribuscloud.com\/help\/paribus-discovery-compatible-crm-online\/?share=linkedin\" target=\"_blank\" title=\"Click to share on LinkedIn\"><span>LinkedIn<\/span><\/a><\/li><li class=\"share-print\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-print sd-button share-icon\" href=\"https:\/\/www.paribuscloud.com\/help\/paribus-discovery-compatible-crm-online\/\" target=\"_blank\" title=\"Click to print\"><span>Print<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"author":17,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"spay_email":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false},"categories":[163,164,14,1956,13],"tags":[],"jetpack_featured_media_url":"","jetpack_publicize_connections":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v15.1.2 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<meta name=\"description\" content=\"Using the Paribus 365\u2122 Data Cleansing Data Extraction Utility to connect Paribus 365 with Microsoft Dynamics 365 CRM online.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.paribuscloud.com\/help\/paribus-discovery-compatible-crm-online\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using Paribus 365\u2122 Data Cleansing Data Extraction Utility\" \/>\n<meta property=\"og:description\" content=\"Using the Paribus 365\u2122 Data Cleansing Data Extraction Utility to connect Paribus 365 with Microsoft Dynamics 365 CRM online.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.paribuscloud.com\/help\/paribus-discovery-compatible-crm-online\/\" \/>\n<meta property=\"og:site_name\" content=\"The Paribus Help Center\" \/>\n<meta property=\"article:published_time\" content=\"2020-04-21T14:38:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-04T10:12:06+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary\" \/>\n<meta name=\"twitter:creator\" content=\"@ParibusDedupe\" \/>\n<meta name=\"twitter:site\" content=\"@ParibusDedupe\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.paribuscloud.com\/help\/#organization\",\"name\":\"QGate Software Ltd\",\"url\":\"https:\/\/www.paribuscloud.com\/help\/\",\"sameAs\":[\"https:\/\/www.linkedin.com\/company\/qgate\/\",\"https:\/\/www.youtube.com\/channel\/UCZBmNdUEnRL9RH0ah3US99g\",\"https:\/\/twitter.com\/ParibusDedupe\"],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.paribuscloud.com\/help\/#logo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/www.paribuscloud.com\/help\/wp-content\/uploads\/2018\/05\/QGate_logo_4c.png\",\"width\":1808,\"height\":700,\"caption\":\"QGate Software Ltd\"},\"image\":{\"@id\":\"https:\/\/www.paribuscloud.com\/help\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.paribuscloud.com\/help\/#website\",\"url\":\"https:\/\/www.paribuscloud.com\/help\/\",\"name\":\"The Paribus Help Center\",\"description\":\"Customer Self Help, Paribus events and product news\",\"publisher\":{\"@id\":\"https:\/\/www.paribuscloud.com\/help\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/www.paribuscloud.com\/help\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.paribuscloud.com\/help\/paribus-discovery-compatible-crm-online\/#webpage\",\"url\":\"https:\/\/www.paribuscloud.com\/help\/paribus-discovery-compatible-crm-online\/\",\"name\":\"Using Paribus 365\\u2122 Data Cleansing Data Extraction Utility\",\"isPartOf\":{\"@id\":\"https:\/\/www.paribuscloud.com\/help\/#website\"},\"datePublished\":\"2020-04-21T14:38:18+00:00\",\"dateModified\":\"2025-06-04T10:12:06+00:00\",\"description\":\"Using the Paribus 365\\u2122 Data Cleansing Data Extraction Utility to connect Paribus 365 with Microsoft Dynamics 365 CRM online.\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.paribuscloud.com\/help\/paribus-discovery-compatible-crm-online\/\"]}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/www.paribuscloud.com\/help\/paribus-discovery-compatible-crm-online\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.paribuscloud.com\/help\/paribus-discovery-compatible-crm-online\/#webpage\"},\"author\":{\"@id\":\"https:\/\/www.paribuscloud.com\/help\/#\/schema\/person\/27108c9cbbc1840b9f51b9119fdd7cee\"},\"headline\":\"Using Paribus 365&#x2122; Data Cleansing with Microsoft Dynamics 365 CRM Online &#8211; Data Extraction Utility\",\"datePublished\":\"2020-04-21T14:38:18+00:00\",\"dateModified\":\"2025-06-04T10:12:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.paribuscloud.com\/help\/paribus-discovery-compatible-crm-online\/#webpage\"},\"publisher\":{\"@id\":\"https:\/\/www.paribuscloud.com\/help\/#organization\"},\"articleSection\":\"How-To Guide,Microsoft Dynamics 365,Microsoft Dynamics CRM,Paribus 365,Paribus Discovery\",\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.paribuscloud.com\/help\/#\/schema\/person\/27108c9cbbc1840b9f51b9119fdd7cee\",\"name\":\"Paribus 365 Team\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.paribuscloud.com\/help\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/00c6cd7408c3531da38599fd6bccaa5c?s=96&d=mm&r=g\",\"caption\":\"Paribus 365 Team\"},\"sameAs\":[\"http:\/\/www.Paribus365.com\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8hT1P-5Bv","_links":{"self":[{"href":"https:\/\/www.paribuscloud.com\/help\/wp-json\/wp\/v2\/posts\/21545"}],"collection":[{"href":"https:\/\/www.paribuscloud.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.paribuscloud.com\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.paribuscloud.com\/help\/wp-json\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/www.paribuscloud.com\/help\/wp-json\/wp\/v2\/comments?post=21545"}],"version-history":[{"count":7,"href":"https:\/\/www.paribuscloud.com\/help\/wp-json\/wp\/v2\/posts\/21545\/revisions"}],"predecessor-version":[{"id":24162,"href":"https:\/\/www.paribuscloud.com\/help\/wp-json\/wp\/v2\/posts\/21545\/revisions\/24162"}],"wp:attachment":[{"href":"https:\/\/www.paribuscloud.com\/help\/wp-json\/wp\/v2\/media?parent=21545"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.paribuscloud.com\/help\/wp-json\/wp\/v2\/categories?post=21545"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.paribuscloud.com\/help\/wp-json\/wp\/v2\/tags?post=21545"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}