If you work in an area of the business that touches customer, supplier and prospect data, you probably know something that many of your business counterparts don’t: Even if the business data in their systems is a mess, it can be cleansed, validated, enriched and updated.
In my experience, most business people are aware that the data in their CRM, ERP and other systems contain old and inaccurate records, but they don’t really know what to do about it. So they continue to use increasingly unusable data until someone comes along to help them out. If anything, they manually clean up the data each time they try to use it. They are frustrated with poor-quality data and the inefficient processes they must follow to interact with the information. Of course, you know there is a better way to work with key customer, supplier and prospect data.
New D&B Component for SSIS
Here at D&B, we have developed Microsoft-related solutions that can help you be a hero. We’ve just released D&B Company Cleanse & Match for SSIS, a solution for users of Microsoft SQL Server Integration Services (SSIS). D&B Company Cleanse & Match for SSIS is a simple data flow component that can be dragged and dropped into SSIS workflows to allow instant validation and correction of data against D&B’s 230-million-record Global Database.
Why use this component? Because the business folks who struggle with the quality of their business data need your help. They could see a big improvement in their business processes and overall productivity with cleaner, more accurate and up-to-date data. They need to report metrics to their execs that move up and to the right, not down and to the right.
You may be wondering how our SSIS component works. We use our patented Entity Matching algorithm that gives you a single complete and correct picture of a business by assigning a unique identifier, in this case a D-U-N-S Number. The D-U-N-S number eliminates record duplication and links related companies together, so potentially incomplete or inaccurate data entries can be merged into a single, validated customer record.
This helps the business people keep their records accurate and current, and saves them from having to wrangle the data themselves. You as a developer are in a great position to help them out.
We’re offering free trials with unlimited access to selected data in our D&B Sandbox. With trial access, you can download the D&B SSIS connector package, install it and experience the product functionality with sandbox data. Find out more about the component by visiting the web page, Use SSIS to Improve Data Quality. To sign up for the trial, just fill out the form on the page and we’ll send you the info you need.