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 a Generalized Cleansing component 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.
The Generalized Cleansing component 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. Our component has six main cleansing operations:
"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.