Melissa Data has announced availability of its MatchUp Component for SQL Server Integration Services (SSIS). This powerful tool finds and eliminates duplicate database records, specifically in the contact record domain. MatchUp dramatically enhances database efficiency and effectiveness by enabling a single, accurate view of each customer – eliminating duplicate customer and prospect records through user specified, customizable criteria.
MatchUp can identify matches in any combination using more than 35 different components – ranging from conventional attributes such as address, city, state, ZIP, name or phone, to uncommon search elements such as email address, company, gender or Social Security number. MatchUp offers significant added value, allowing users to specify their own proprietary data component, such as an account number, using the user-interface-driven MatchCode editor. Further, no programming or development time is needed to utilize Melissa Data's data quality components for SQL Server. Data stewards can be up and running in minutes – cleansing, updating and de-duping existing contact data for better marketing and better decision making.
"As many as 10 percent of the contact records in the average database are duplicates – wasting corporate resources and impeding ideal customer relationships," said Bud Walker, Director of Data Quality Tools at Melissa Data. "Eliminating duplicate records and linking customer data enables a better understanding of each individual and their relationship with your business – improving customer service, reducing costs, managing risk and increasing profitability."
MatchUp joins an already strong line of contact data cleansing tools from Melissa Data for SSIS, including the Contact Verify and SmartMover components.
- Contact Verify parses, standardizes and verifies street address, telephone number, email address and name, and also geocodes addresses with their corresponding latitude/longitude coordinates.
- SmartMover provides the current address for customers that have moved within the last 48 months.