Data Quality Components for Pentaho

Bring Consistent, Accurate and Trustworthy Data to Business Applications

Data Quality Components For Pentaho is the perfect tool for companies to gain a competitive advantage by leveraging CDI or Customer Data Integration. Pentaho connects to virtually any database, including Microsoft Access, Excel, SQL Server, Oracle Database, IBM DB2, Salesforce, SAP, XML and many others, operating as the central hub for all your data cleansing, verification and consolidation needs. Data Quality Components For Pentaho standardizes, cleans, and matches information across disparate sources to resolve and unify customer/contact data and synchronize it across the enterprise.

Benefits:

  • Easy-to-use, drag-and-drop interface
  • Up-and-running within minutes
  • No programming required
  • Designed for both enterprise & small businesses
  • Suitable for non-technical and/or marketing personnel

Features:

  • Parse, validate & standardize international addresses, phone numbers, email addresses and full names
  • Update the addresses of customers (U.S. and Canada) who have moved
  • Eliminate duplicate records and/or match records for a single, accurate view of contacts
  • Add latitude-longitude coordinates to international postal addresses
  • Presort for First-Class® and Standard Mail™ for maximum postage discounts
  • Free unlimited technical support. Learn more.

Easy to Use ETL Interface

Data Quality Components For Pentaho intuitive and rich graphical designer allows you to do exactly what the most skilled code developers can accomplish, in a fraction of the time, and without any manual coding.

Data Profiling and Data Quality

  • Identify data that fails to comply with business rules and standards
  • De-duplicate and cleanse inconsistent and redundant data
  • Validate, standardize and correct name, address, email and telephone data

Open-Based Architecture

  • 100% Java APIs, ideal for integrating into existing applications
  • Extensible architecture for building custom data transformation and connectors

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
  • Contact Verify Component Icon

Personator*

  • Verifies name corresponds to address, email, and phone data
  • Appends missing name and company name, phone number, and/or email address
  • Provide current addresses for people and companies that have moved with 20+ years of history

Contact Verify

  • Standardizes, verifies, and corrects U.S. and Canadian addresses
  • Verifies and normalizes U.S. and Canadian phones on a 7-10 digit level
  • Parses names, genderizes, and detects suspicious words or companies in name field
  • Geocodes addresses by assigning rooftop lat/long coordinates*

SmartMover®*

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

MatchUp®*

  • Identifies duplicate records with domain specific knowledge of contact information

Postal Presort*

  • Presorts for First-Class and Standard Mail discounts
  • Generates Qualification Reports and Postage Statement Reports in PDF

IP Locator*

  • Identifies Web visitor's geographic location
  • Reduces fraud and geo targets

* Additional subscription required

Pentaho Data Quality Plug-in Free Trial Upload a sample of your data for a free analysis