Enterprise
Direct Marketing
Developer
Education
Lookups

My Account

Singapore

Our Solutions
Our Services
Our Data
Pricing
- Product & Service PricingMelissa credit based services & pricing.
- Purchase CreditsActivate or purchase Melissa credits.
Support
More

Request Demo

1-800-MELISSA

Our Solutions
Our Services
Our Data
- Our Data
Pricing
- Pricing
  - Product & Service Pricing
  - Purchase Credits
Support
More
- More
Explore Melissa
- Explore Melissa

Melissa Data Quality Platforms
Melissa Data Verification Tools
Melissa Identity Verification
Melissa E-Commerce / CRM
Melissa Enrich
Melissa Mailing
Melissa Industries

Melissa Data Quality Platforms

Melissa's Full Spectrum DQ Approach. Learn More

Unison

Validate, Cleanse & Maintain Data Quality Without Programming.

ETL/MDM PlatformsMelissa offers a host of solutions for full spectrum data quality to ensure the success of your data.

Melissa Data Verification Tools

Melissa’s Smart, Sharp Tool Approach. Learn More

Address Verification

Clean your addresses to improve mail & fulfillment.

Phone Verification

Ensure mobile & landlines are accurate & callable.

Email Verification

Validate emails before hitting send.

Name Verification

Parse & standardize first & last names for personalization.

Matching / Dedupe

Combine multiple records into one golden record.

Customer Data Management

Discover best-in-class data quality in one platform.

Profiling

Analyze your data to improve its quality over time.

Generalized Cleansing

Cleanse any type of data fast & easy.

Batch Address Cleansing

Clean addresses in batch to improve delivery & customer satisfaction.

Capabilities

Identity Verification

Age Verification
PEP, Watchlist & Sanctions Screening
Negative News Screening

Address Verification

Melissa E-Commerce / CRM

Improve customer onboarding, marketing & fulfillment.

Address Autocomplete

Capture verified addresses on forms quickly with autocomplete technology.

IP Location

Validate IP & append geolocation data.

Street Route

Find distance & travel time by lat/long pairs.

Shopware

Ensure accurate customer data at checkout.

Salesforce / Dynamics CRM

Verify & enrich data for better sales & marketing.

Data Cleansing

Clean, Standardize, and Reformat Any Data Type

In the era of big data, data stewards spend a large amount of time doing “data janitor” work – the time-consuming, mundane task of collecting, preparing, and cleaning disparate data. We offer the Melissa Cleanser transform for Pentaho® and Microsoft SQL Server® Integration Services (SSIS) to help automate and prepare data for the cleansing process. This empowers users to build custom data cleansing scripts for data suffering from a wide range of errors and inconsistencies. With the component, data stewards have the ability to standardize and validate inventory lists to better prep and cleanse data prior to analysis.

Cleanse any type of data and achieve a higher standard of data quality for integration, warehousing, and analytics
Gain greater control of your data when optimized, and save your business time and resources
Customize and create rules (triggering) to standardize data

How Cleanser Works

The Cleanser transform enables users to clean, standardize, and reformat any data type – from changing casing or capitalization, adding or removing punctuation, expanding or contracting abbreviations, and searching and replacing any parts of a string. The tool applies different cleansing operations to your data integration and warehousing efforts. The transform has five main cleansing operations:

Punctuation - Add or remove punctuation.
Abbreviation - Expand or contract abbreviations, for example: CA to California
Search & Replace - Replace portions of a string
Expressions - Create programmatic expressions to make sense of data values
Regex - Use regular expressions to extract, validate, etc.