Data Verification and Enrichment Tools for SQL Server Integration Services (SSIS)
This premier collection of Melissa Data’s contact verification and enrichment tools provide a wide range of data transformation,
cleansing and matching functionality within SQL Server Integration Services (SSIS) – facilitating the success of data integration,
ETL, BI, MDM and data governance initiatives.
Available components include:
- Easy to use. No programming or development time needed.
- Optimized for contact data quality. Industry leading verification, updating and enrichment tools.
- Easy to configure. Drag & drop configuration with visual elements to design & deploy complex data quality regimens.
- Very flexible. Works in both "on premise" & "cloud" mode.
* Additional subscription required
Contact Verification Component
- Standardize, verify, and correct U.S. and Canadian addresses
- Verify and normalize U.S. and Canadian phone on a 7-10 digit level
- Parse names, genderize, and detect suspicious words or companies in name field
- Validate, correct and standardize email addresses
- Geocode addresses by assigning rooftop lat/long coordinates
Global Verify Component*
- Standardize, correct, verify, and format addresses for 240 countries and territories
- U.S./Canadian change of address processing to update addresses of people or businesses that have moved
- Identify duplicate records with domain specific knowledge of contact information
||Fuzzy Match Component*
- Link related records with a toolbox of fuzzy algorithms and match thresholds