What’s new in Data Quality Components for SSIS 4.4

What’s new:

New and Improved Global Verify Component

The updated version of the Global Verify Component introduces the following brand new features:

1) Global Name Parsing

Global Name provides individual and company name standardization, parsing, and genderizing. It is able to take in dual names like “John Doe and Jane Smith”, parse them separately, and append gender codes for each. Global Name can also standardize casing and abbreviations (such as ‘corporation’ to ‘Corp.’) for company names.

2) Global Phone Verification

Global Phone Verification allows for verifying phone numbers for over 230 countries as well as append geographical information such as latitude, longitude, administrative area, and predominant language spoken in that region. In addition, Global Phone has the ability to return digits you need to dial out of your country and into the country of the inputted phone number.

3) Realtime Email Mailbox Validation

This new version of Global Email Validation offers a powerful service for real-time mailbox validation, parsing and domain verification. Unlike previous technologies, Realtime Mailbox validation can accurately validate the entire email address, down to the mailbox name. The following are the features included with Global Email:

• Perform Real time Mailbox Validation
• Verify and optionally correct syntax errors in an address, checking for illegal characters and extra “@” characters.
• Check for, and optionally correct, misspelled domain names.
• Check for, and optionally correct, domains that have changed.
• Standardize casing in email addresses.
• Detect Unicode emails
• Disposable domains/Spam trap domain, Email address is disposable and the Inbox will self-destruct.
• Ensure that the email address format is correct

All New Property Component

The Data Quality Components for SSIS 4.4 Release features the brand new Property Component. The Property Component provides valuable access to comprehensive property and mortgage data for over 140 million records. With 12 main categories and 165 information fields available, it’s easy to customize your property lists by owner information, property values, current sale information, and much more.

Change History: