Pentaho:Basics

← Data Quality Components for Pentaho

A basic Pentaho Data Transform consists of an Input, a Data Transform (the MD Components), and an Output.

Use the table of contents above to view more information on these topics.

Contact Verify Component

Address Verification

• Validate and Correct US and Canadian addresses
• Append missing suites with SuiteLink® and exclusive AddressPlus technology
• Determine delivery type (business vs. residential)
• Validate and Correct non-USPS addresses

Geocoding (Spatial Processing)

• Assign Latitude and Longitude to the Rooftop
• Census Tract and Block
• CBSA Information
• County Names and FIPS
• Place Names and Place Code

Name Processing

• Parse and genderize names and multiple names
• Detect vulgarities and suspicious words in name fields
• Detect and standardize companies in the name field

Phone Processing

• Verify telephone numbers to 7 - 10 digit level
• Determine Telco Switch location
• Detect landlines vs. cellular or VOIP
• Detect Residential, business, small office/home office phones

Email Processing

• Validate and correct email domains
• Detect mobile domains (restricted from email by FCC)
• Detect bad mailbox names (spam, noreply…)
• Correct common misspellings and syntax errors

IP Locator Component

• Returns geographic data for a given IP address
• Latitude, Longitude, City, State, Zip Code, County, and ISP Information are all returned

Global Address Component

• Validate and Correct International Addresses
• Supports 240 countries in the world

MatchUp Component

• Find and eliminate duplicate records
• Enhance the efficiency and effectiveness of your database
• Create custom Matchcodes tailored for your data

SmartMover Component

• Replace old addresses with move addresses
• Identify undeliverable and incomplete addresses
• Cut your mailing costs with postal discounts
• Increase Postal processing and delivery

Personator Component

• Empower E-commerce
• Multi-sourced data sets
• Check contact records
• Advanced Address Correction
• Verify individual identity
• Flexible, Cloud-based Service