{"id":150,"date":"2017-11-07T02:51:52","date_gmt":"2017-11-07T10:51:52","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/dnb-cds-announcement\/"},"modified":"2024-09-24T14:48:42","modified_gmt":"2024-09-24T21:48:42","slug":"dnb-cds-announcement","status":"publish","type":"power-apps","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/dnb-cds-announcement\/","title":{"rendered":"Enrich your data with Dun & Bradstreet and the Common Data Service (Previous version)"},"content":{"rendered":"

Note : This blog post relates to an earlier version of the Common Data Service and these templates are no longer available in the current release.<\/strong><\/p>\n

We are excited to announce the US release of D&B Optimizer from Dun & Bradstreet today. D&B Optimizer will take Account (Customer) data stored within the Common Data Service and using Flow, match each account against the Dun & Bradstreet database of over 280 Million global businesses to retrieve their Business Profile. Once the Business Profile is returned and stored within the Common Data Service it can be used for data quality and analytics.<\/p>\n

\u00a0<\/p>\n

<\/p>\n

\u00a0<\/p>\n

D&B Optimizer leverages the simplicity of the Microsoft platform by enabling customer data to be sourced from multiple data sources and apps and integrated into the Common Data Service in a standardized format. Once in the Common Data Service a Flow Template<\/a> is available to match your data immediately against the connector for Dun & Bradstreet. The Common Data Service will allow customers to avoid bespoke integrations to Dun & Bradstreet from different systems, users will be able to bring in their data using one of the existing data integration projects, Power Query (Preview) or simply import the data.<\/p>\n

Let\u2019s look at an example, basic information about an Account has been entered into the Account entity in the Common Data Service:<\/p>\n\n\n\n\n\n
Organization Name<\/strong><\/td>\nGorman Manuafacturing<\/td>\n<\/tr>\n
City<\/strong><\/td>\nSan Francisco<\/td>\n<\/tr>\n
State<\/strong><\/td>\nCA<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

After matching through Flow and the Dun & Bradstreet connector, the following Business Profile is created in the Common Data Service.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Field<\/strong><\/td>\nBusiness Profile<\/strong><\/td>\n<\/tr>\n
Organization Name<\/strong><\/td>\nGorman Manufacturing Company, Inc.<\/td>\n<\/tr>\n
Address Line 1<\/strong><\/td>\n492 KOLLER ST<\/td>\n<\/tr>\n
City<\/strong><\/td>\nSAN FRANCISCO<\/td>\n<\/tr>\n
State<\/strong><\/td>\nCA<\/td>\n<\/tr>\n
Postal Code<\/strong><\/td>\n94110<\/td>\n<\/tr>\n
DUNS Number<\/strong><\/td>\n804735132<\/td>\n<\/tr>\n
Phone Number<\/strong><\/td>\n+1 (650) 555 0000<\/td>\n<\/tr>\n
SIC Industry Code<\/strong><\/td>\n2752<\/td>\n<\/tr>\n
SIC Industry Description<\/strong><\/td>\nLithographic commercial printing<\/td>\n<\/tr>\n
Global Ultimate DUNS Number<\/strong><\/td>\n804735132<\/td>\n<\/tr>\n
Global Ultimate Organization Name<\/strong><\/td>\nGorman Manufacturing Company, Inc.<\/td>\n<\/tr>\n
Domestic Ultimate DUNS Number<\/strong><\/td>\n804735132<\/td>\n<\/tr>\n
Domestic Ultimate Organization Name<\/strong><\/td>\nGorman Manufacturing Company, Inc.<\/td>\n<\/tr>\n
Location Type<\/strong><\/td>\nGlobal Ultimate;Domestic Ultimate;Parent\/Headquarters<\/td>\n<\/tr>\n
Financial Year Revenue (Last Reported)<\/strong><\/td>\n$24,662,580<\/td>\n<\/tr>\n
Financial Year Revenue Currency<\/strong><\/td>\nUSD<\/td>\n<\/tr>\n
Financial Year To Date<\/strong><\/td>\n31\/12\/2016<\/td>\n<\/tr>\n
Number of Employees (Local)<\/strong><\/td>\n120<\/td>\n<\/tr>\n
Number of Employees (Total)<\/strong><\/td>\n153<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

To ensure this integration is as smooth as possible, Microsoft has collaborated with Dun & Bradstreet to introduce the new Business Profile entity to be part of the Common Data Service to reduce the need for custom objects, and to allow customers and ISVs to build solutions leveraging this data as well.<\/p>\n

<\/p>\n

The enriched Business Profile not only includes the business and contact information for an organization, but also the information to support data cleansing and improvement, territory management and organizational structure. With access to this business intelligence, organizations will gain a single source of data truth to increase alignment across your organization and improve productivity with a more complete view of your customers and prospects. The D&B Optimizer solution also includes PowerBI reports to segment your customer data, and quickly identify data quality issues.<\/p>\n

<\/p>\n

Customers who are using Dynamics 365 will benefit from a D&B Optimizer solution available for Dynamics 365 for Sales which brings the Business Profile information directly back into the Account form.<\/p>\n

<\/p>\n

We are extremely excited to announce the release of the D&B Optimizer solution, not only for the immediate benefit we can see this bring users but also as a great example of one of our strategic ISVs leveraging\u00a0the Common Data Service, Microsoft Flow and PowerBI to develop an awesome solution for our joint customers.<\/p>\n

D&B Optimizer requires users to have access to a Common Data Service environment and an active subscription for Dun & Bradstreet services. Find more information here<\/a>, and how to get started here<\/a>.<\/p>\n

You can read the announcement of the strategic partnership announced in July, 2017 here.<\/a><\/p>\n

Thanks,<\/p>\n

Clay.<\/p>\n

\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"

We are excited to announce the US release of D&B Optimizer from Dun & Bradstreet today. D&B Optimizer will take Account (Customer) data stored within the Common Data Service and using Flow, match each account against the Dun & Bradstreet database of over 280 Million global businesses to retrieve their Business Profile. Once the Business Profile is returned and stored within the Common Data Service it can be used for data quality and analytics.<\/p>\n","protected":false},"author":114,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","power-apps-category":[1591,1599],"power-apps-tag":[],"coauthors":[2326],"class_list":["post-150","power-apps","type-power-apps","status-publish","hentry","power-apps-category-dataverse","power-apps-category-dynamics-365"],"yoast_head":"\nEnrich your data with Dun & Bradstreet and the Common Data Service (Previous version) - Microsoft Power Platform Blog<\/title>\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.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/dnb-cds-announcement\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Enrich your data with Dun & Bradstreet and the Common Data Service (Previous version) - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"We are excited to announce the US release of D&B Optimizer from Dun & Bradstreet today. D&B Optimizer will take Account (Customer) data stored within the Common Data Service and using Flow, match each account against the Dun & Bradstreet database of over 280 Million global businesses to retrieve their Business Profile. Once the Business Profile is returned and stored within the Common Data Service it can be used for data quality and analytics.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/dnb-cds-announcement\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"article:modified_time\" content=\"2024-09-24T21:48:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2017\/11\/D_B_Optimizer_logo.jpg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 min read\" \/>\n\t<meta name=\"twitter:label2\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data2\" content=\"Clay Wesener\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/dnb-cds-announcement\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/dnb-cds-announcement\/\",\"name\":\"Enrich your data with Dun & Bradstreet and the Common Data Service (Previous version) - Microsoft Power Platform Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/dnb-cds-announcement\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/dnb-cds-announcement\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2017\/11\/D_B_Optimizer_logo.jpg\",\"datePublished\":\"2017-11-07T10:51:52+00:00\",\"dateModified\":\"2024-09-24T21:48:42+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/dnb-cds-announcement\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/dnb-cds-announcement\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/dnb-cds-announcement\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2017\/11\/D_B_Optimizer_logo.jpg\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2017\/11\/D_B_Optimizer_logo.jpg\",\"width\":383,\"height\":94,\"caption\":\"logo\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/dnb-cds-announcement\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power Apps\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Enrich your data with Dun & Bradstreet and the Common Data Service (Previous version)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\",\"name\":\"Microsoft Power Platform Blog\",\"description\":\"Innovate with Business Apps\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\",\"name\":\"Microsoft Power Platform Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"width\":194,\"height\":145,\"caption\":\"Microsoft Power Platform Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Enrich your data with Dun & Bradstreet and the Common Data Service (Previous version) - Microsoft Power Platform Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/dnb-cds-announcement\/","og_locale":"en_US","og_type":"article","og_title":"Enrich your data with Dun & Bradstreet and the Common Data Service (Previous version) - Microsoft Power Platform Blog","og_description":"We are excited to announce the US release of D&B Optimizer from Dun & Bradstreet today. D&B Optimizer will take Account (Customer) data stored within the Common Data Service and using Flow, match each account against the Dun & Bradstreet database of over 280 Million global businesses to retrieve their Business Profile. Once the Business Profile is returned and stored within the Common Data Service it can be used for data quality and analytics.","og_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/dnb-cds-announcement\/","og_site_name":"Microsoft Power Platform Blog","article_modified_time":"2024-09-24T21:48:42+00:00","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2017\/11\/D_B_Optimizer_logo.jpg","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 min read","Written by":"Clay Wesener"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/dnb-cds-announcement\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/dnb-cds-announcement\/","name":"Enrich your data with Dun & Bradstreet and the Common Data Service (Previous version) - Microsoft Power Platform Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/dnb-cds-announcement\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/dnb-cds-announcement\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2017\/11\/D_B_Optimizer_logo.jpg","datePublished":"2017-11-07T10:51:52+00:00","dateModified":"2024-09-24T21:48:42+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/dnb-cds-announcement\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/dnb-cds-announcement\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/dnb-cds-announcement\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2017\/11\/D_B_Optimizer_logo.jpg","contentUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2017\/11\/D_B_Optimizer_logo.jpg","width":383,"height":94,"caption":"logo"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/dnb-cds-announcement\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/"},{"@type":"ListItem","position":2,"name":"Power Apps","item":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/"},{"@type":"ListItem","position":3,"name":"Enrich your data with Dun & Bradstreet and the Common Data Service (Previous version)"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/","name":"Microsoft Power Platform Blog","description":"Innovate with Business Apps","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization","name":"Microsoft Power Platform Blog","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","width":194,"height":145,"caption":"Microsoft Power Platform Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/"}}]}},"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft Power Platform Blog","distributor_original_site_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-apps\/150"}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-apps"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/types\/power-apps"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/users\/114"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/comments?post=150"}],"version-history":[{"count":5,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-apps\/150\/revisions"}],"predecessor-version":[{"id":124823,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-apps\/150\/revisions\/124823"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=150"}],"wp:term":[{"taxonomy":"power-apps-category","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-apps-category?post=150"},{"taxonomy":"power-apps-tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-apps-tag?post=150"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=150"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}