SQL Server Data Quality

The Contact Verify transform verifies, corrects, and standardizes U.S and Canada postal addresses, email addresses, and phone numbers and coverts US addresses to roof-top latitude/longitude coordinates.

The Global Verify transform verifies, corrects and standardizes postal addresses, email addresses, and phone numbers for 240+ countries, plus converts street addresses to precise latitude/longitude coordinates.

The Personator transform verifies identity, validates postal address, email address, and phone number, plus updates the current address for a contact and enriches records with missing email, phone, address data and demographic info.

The Personator World transform verifies an individual’s national ID, provides age verification, and performs watchlist/sanctions screening for fraud prevention and KYC/AML compliance.

The Property transform provides information about a given property parcel, including: assessed value; last sale price; current mortgage; physical dimensions of the land and buildings; and square footage.

The MatchUp transform provides advanced deduping/matching capabilities and survivorship rules to eliminate duplicates and create a single customer view.

The Fuzzy Matching transform compares and matches single and multiple columns using a toolbox of algorithms to identify hard-to-spot similar and duplicate records.

The IP Locator transform geolocates a given IP address and returns latitude/longitude, city, state, postal code, county and ISP information.

The Business Coder transform provides detailed firmographic data on over 25 million U.S. businesses – ideal for standardizing business entities, consolidating records and lead scoring.

The SmartMover transform matches your address records against the USPS NCOA^Link database or Canada Post NCOA database and returns the current address of customers that have moved.