D&B Company & Match for SQL Server Integration Services (SSIS)
D&B Cleanse/Match for SSIS is a data flow component that is dragged and dropped into SSIS workflows to allow instant validation and correction of data against D&B’s 225+ million record Global Database using D&B’s patented D&B Entity Match system. Matching result details such as the D-U-N-S Number, Confidence Code, Match Grade and additional data elements are included in the response.
At present, this service supports only Western European Languages (English, French, German, Irish, Italian, Portuguese, and Spanish). Asian Languages (Chinese, Japanese, South East Asian Languages etc.) may be supported in the future.
The following software is required for implementing the D&B Company Cleanse & Match for SQL Server Integration Services (SSIS) connector.
- Windows XP (32-bit)/Windows 7 (32/64-bit)/Windows 8 (32/64-bit)
- SQL Server 2008 R2 / SQL Server 2012 Integration Services
- Visual Studio 2010/2012
- .NET Framework 3.5/4
- Internet access, port 80
The D&B Cleanse/Match for SSIS connector leverages functionality from D&B Direct, a cloud-based API solution.
Visit the D&B Company Cleanse & Match for SSIS Trial Signup page and follow the instructions for obtaining credentials required for using this connector.