Cleanse and Enrich Any Contact Database EasilyData Quality Components For Pentaho is a scalable customer integration platform with exceptional Extract, Transform, Load (ETL) capabilities that enables users to quickly get up and running, managing, cleansing, and enriching contact data from a wide range of sources.
- Validate & correct U.S. & Canadian addresses, phone numbers and emails.
- Update addresses of people or businesses that have moved.
- Assign lat/long coordinates to customers addresses with rooftop geocoding.
- USPS Postal Presort for First-Class & Standard Mail discounts.
- Identify the geographic location of an IP address with Latitude & Longitude.
- Works with data in text files, Oracle, MS SQL Server, dBase, Excel, Salesforce, SAP, Access, XML, DB2, Informix, MySQL & more.
- Operates in Cloud or on-premise mode.
- Includes transforms for string operations, sorting, sampling, lookup and flow control.
- The free version includes basic Address, Name, Phone, and Email validation for up to 5,000 records annually.