Data Quality Tools, Mailing Software, Lists, NCOA, Data Enhancements
Call 1-800-MELISSA  
Cart Shopping Cart|Contact Us||

Data Quality Direct Mail Popular Services Downloads Support Resources Lookups Company

Data Quality Components for SQL Server Integration Services (SSIS)

Easily Cleanse, Update and Consolidate Contact Data Within SSIS

Up to 20 percent of the data in a company’s database is incorrect or outdated according to industry experts, resulting in duplicate records, returned mail, address correction fees, and lost opportunities.

Data Quality Components for SSIS is a suite of custom data cleansing transformation components for Microsoft SQL Server Integration Services (SSIS) to standardize, verify, correct, consolidate and update all your contact data for effective communications.

Benefits:

  • Improve data quality
  • Enhance customer service
  • Streamline operational processes
  • Increase ROI & profit margins
  • Reduce Undeliverable-as-Addressed mail & shipments
  • Deliver data quality routines without writing any code or programming hassles

Features:

  • Verify U.S. and international addresses for over 240 countries & territories
  • Add rooftop lat/long coordinates to addresses
  • Easy to use and intuitive interface with drag/drop capabilities
  • Broad connectivity to any type of data
  • De-duplicate and cleanse inconsistent and redundant data
  • Validate, standardize and correct name, address, e-mail and telephone data

Personator Contact Data Management for SSIS Video

In three simple steps, product specialist Matthew Bayne demonstrates how Personator for SSIS can cleanse, standardize and append missing information such as email addresses and phone numbers to complete your contact information for better data warehousing, analytics and bottom-line results.




“Melissa Data has leveraged the extensibility of the SSIS platform to create components that support Data Quality and master data management (MDM) including the address verification that Melissa Data is known for.”

- Denise Draper, Microsoft unit manager for SSIS



Contact Verify

  • Standardize, verify, and correct U.S. and Canadian addresses
  • Verify and normalize U.S. and Canadian phones on a 7-10 digit level
  • Parse names, genderize, and detect suspicious words or companies in name field
  • Geocode addresses by assigning rooftop lat/long coordinates*

Personator*

  • Verifies name corresponds to address, email, and phone data
  • Appends missing name and company name, phone number, and/or email address

Global Verify*

  • Verifies international addresses for over 240 countries. List of supported countries
  • Transliterates many major character sets and displays output in either native or Roman characters
  • Geocodes international postal addresses by adding a latitude-longitude coordinate. List of supported countries
  • Parses and genderizes full names and standardizes company names
  • Verifies international phone numbers and appends geographic info
  • Parses, validates, and standardizes international email addresses (includes Real-time Email Mailbox Verification)

SmartMover®*

  • U.S./Canadian change of address processing to update addresses of people or businesses that have moved

MatchUp®*

  • Identify duplicate records with domain specific knowledge of contact information
  • Perform Fuzzy Matching using over 16 different Matching Algorithms
  • Automated and Intelligent Golden Record Selection through the Data Quality Score and other Algorithms
  • List Suppression and Intersection

Fuzzy Match*

  • Link related records with a toolbox of fuzzy algorithms and match thresholds
  • Outputs Matches, Possible Matches and Non-Matches based on desired threshold
  • Perform Fuzzy Matching using over 16 different Matching Algorithms
  • Regex Builder can be used to mask or clean data on the fly
  • Maintains full metadata for lineage tracking

IP Locator

  • Profile Web traffic by geographical location
  • Redirect users to specific language/country pages
  • Return Lat/Long data, Zip Code, region, and more
  • Prevent password sharing and abuse of service
  • Filter access from countries you do not do business with

Property

  • Comprehensive U.S. property and mortgage data (over 140 million records)
  • 12 main categories and 165 information fields available
  • Weekly updates
  • Options include Basic or Detailed output

* Additional subscription required

Download Free Trial of Data Quality Components for SQL Server Integration (SSIS) Upload a sample of your data for a free analysis
____________________________________________________________________________________________________________________________________


Melissa Data Google+ Melissa Data Facebook Melissa Data is on Twitter  The Data Quality Authority Blog  Melissa Data LinkedIn  Melissa Data - YouTube


Data Tools
Products
Plugins
Reference Data
Solutions
Technologies

Email/Direct Mail Tools
Data Enhancement Services
Data Hygiene Services
Email Marketing
Mailing Lists
Mailing Software

Communities
Data Quality Authority
Direct Marketing Authority
MVPs


Customer and Events
Read Customer Stories
Webinars
Press Releases
 
Services
Support
Training & Certification
Become a Partner
Find a Partner Solution
 


Contact Us |  Partners |  Site Map |  Privacy |  Trademarks |  Terms of use

© Copyright 2014 by Melissa DATA Corp. All trademarks are used as property of their owners.

Melissa Data
The leading international provider of data quality and address verification software. Melissa Data's affordable, easy-to-use solutions for data cleaning and deduplication can be used separately or together to provide full global data quality. Melissa Data specializes in Microsoft .NET and SQL Server Integration Services, IBM, Java and Oracle environments with APIs, Web services and enterprise plugins that empower batch and real-time applications. Melissa Data's flagship Contact Zone enables data stewards to quickly create complex data quality and data integration routines with visual programming. Melissa Data also provides a full line of direct marketing solutions including mailing software, list hygiene and data append services, and a comprehensive line of mailing lists and sales leads.