Data Quality Components for SQL Server Integration Services (SSIS) enable you to clean, complete, and consolidate your People Data, so you know it’s trustworthy and actionable.
Our data quality components offer a full spectrum of solutions to profile, cleanse, verify, match, merge, purge, parse, standardize, and enrich with geographic, demographic, and firmographic insights.
Poor data quality equals poor business. The first step in improving data quality is to profile your data to gain valuable insight into the accessiblilty and usability of your data. The Data Profiling component does just that – it generates simple to advanced profiling information – including basic data statistics (mean, median, frequency, variation, etc.) and details (structure, content, classifications, etc.). Armed with this information you can identify weak points in your data collection processes and work to optimize data quality over time with the Profiling Component's monitoring capabilities.
The Generalized Cleansing Component empowers you to build data cleansing scripts for data suffering from a wide range of errors and inconsistencies. The component combines six operations that allow you to cleanse data and save operations (simple or complex) for future projects. The component is highly customizable so you can use programmatic expressions and regular expressions to trigger operations – giving you the ability to self-validate non-contact data to your own specifications.
Cleansing Operations Available:
Use the Global Contact Verify Component to clean, verify, standardize and format all your global people data – name, address, email and phone. The component utilizes a USPS® CASS-Certified™ engine to return a complete and standardized U.S. address and even adds missing ZIP+4® data, missing suite and apartment numbers, and corrects spelling and formatting errors. Additionally, the component will verify addresses from 240+ countries, standardize addresses to local country format, and add missing postal codes, regions, etc. The component supports many different language sets and can transform non-Latin writing systems into Latin characters so addresses in foreign languages like Russian, Greek, Chinese, Japanese, and others can easily be validated.
The component will geocode international addresses for 40+ countries, providing a precise (rooftop) latitude/longitude coordinate for an address to power market segmentation, sales clustering, logistics, risk exposure, and more.
The component also does verification on your phone, email, and name data. Phone verification includes real-time lookup technology to distinguish between global landlines and mobile numbers, and validates the number is accurate, live, and callable. Caller ID will return the name and address associated with the billing contact.
Email verification capabilities include: real-time email mailbox verification to ensure an inbox is live; email syntax and domain correction; and FCC Mobile Domain Detection to ensure CAN-SPAM compliance.
The Contact Verify Component utilizes Melissa's Persontor dataset containing billions of records to validate for each provided element of a U.S. or Canadian contact record: name; address; phone; and/or email; and will match name-to-address for a simple and quick identity verification.
The Personator Component also offers a wealth of append functionality to enrich your contact records including:
On average, a database contains 8-10% duplicate records. These duplicates result in waste and inefficiencies, and cloud your ability to get a single, accurate view of the customer. The MatchUp Component uses advanced fuzzy matching algorithms and deep domain knowledge of contact data to find even the hardest-to-detect U.S. and international (Canada, Europe, South America, Australasia, and more) duplicate records.
MatchUp employs over 16 different fuzzy matching algorithms to identify “non-exact matching” duplicate records that are difficult to uncover, including:
Within SSIS, MatchUp has the unique capability to create a Golden Record using proprietary survivorship rules. Most traditional rules-based approaches to survivorship use techniques involving either (1) the most recent, (2) the most frequent, or (3) the most complete. MatchUp can utilize these techniques, but it also provides the option of determining and consolidating the best possible record based on data quality rules. MatchUp will determine the validity of the data in each field so you can easily rank and select the surviving record based on the actual quality of the data. This technique for golden record selection offers the most effective and logical approach when it comes to survivorship
The SmartMover Component provides change-of-address processing for U.S. and Canadian addresses. This helps you stay in touch with consumers and businesses that have moved, eliminate the costs associated with undeliverable-as-addressed mail, and qualify for applicable postal discounts.
For U.S. addresses, the SmartMover component matches your customer records against the USPS® full NCOALink® data file of 160 million moves going back 48-months. Processing your records utilizing the SmartMover component will satisfy the USPS Move Update requirement for a period of 95 days from the date of processing to qualify for First-Class™ and Standard Mail® discounts. Melissa is a NCOALink® Full Service Provider licensee of the USPS. NCOALink® processing requires a Processing Acknowledgement Form (PAF). Download a copy of our NCOALink PAF
For Canadian addresses, the SmartMover component will match your address file against the Canada Post NCOA® database containing over 11 million records over the last 72 months. Melissa is one of only a handful of Canada Post licensees. Canada NCOA processing requires a signed copy of the Canadian NCOA Acknowledgement Form. Download a copy of our Canadian NCOA form.
The Demographic Component provides detailed consumer demographics from over 2 billion records containing 250 million individuals and 170 million households in the U.S. This valuable information offers you deeper insight into your customers, their behavior, and trends.
The Following variables can be added:
The Property Component provides valuable property and mortgage data from over 140 million records for the U.S. Access variables from over 165 fields in categories such as: parcel; property address; owner; owner mail address; property values; current sale; current trust deed; prior sale; lot/land; square footage; building. For a complete list of data available click here.
The IP Location Component provides the geographic location of an Internet Protocol (IP) address, including latitude, longitude, city, state, ZIP Code™/Postal Code, region, hosting Internet Service Provider (ISP), connection speed and type, and domain name. This information helps you identify where your web visitors are coming from. This is useful for ecommerce sites where you might want to prepopulate country code on forms, display a different language, filter access from countries you don’t do business with, and/or reduce credit card fraud based on geographic location. IP Location can also help fight illegal spamming and hacking by identifying the location of the problem.
"Melissa's technology works seamlessly with SQL Server Integration Services, and provides another way for my clients to achieve highest data quality information. Customer service was excellent, and their technical team provides top support for people wanting to use the technology."
"Melissa easily integrates into both our system and our vendor's systems. They offer a variety of cleansing solutions. Setting up our contract has been easy. We are cleansing our data so that we do not mail invalid records. We've saved hundreds of thousands of dollars a year and decreased cost per acquisition."
"The advanced features of the Address Object API allows us to greatly reduce our "undeliverable" loses and improve our next-day delivery customer experience. In my experience Melissa has done a fantastic job in advancing their products and services. We have been move then pleased by their performance and pricing for their products."
"The API was easy for my developers to integrate into the applications we use. The documentation was excellent and the customer support equivalent. Data integrity is also another key component and makes verifying addresses simple and accurate."
Request a free trial by filling out the form.