Here’s the deck for my talk at SQLSaturday and also at SQLPASS BA conference.
I’ve been doing work with Dun & Bradstreet (and am also a D&B MVP), to that end, I wrote a code sample for working with their Business Verification service API in C# and published it to GitHub.
D&B’s Business Verification service is useful for many of my clients as it provides the ability to take partial (and potentially duplicate) customer information and returns back cleansed, completed, validated company information. Also their unique identifier, the DUNS number, helps to identify duplicates.
My code sample is in C# and access their endpoint which is hosted in the Windows Azure Marketplace. D&B has a number of other data services, in addition to this one. In addition to the Azure Marketplace, D&B has data services available at endpoints via their own D&B Direct site.
If you don’t need to code a custom solution the D&B Business Verification service is also available via the Windows Office store (as an Excel 2013 add-in) or via Excel Power Query.
Enjoy my code sample and screencast (below) – happy programming!