Build History:SSIS:Data Quality Components: Difference between revisions

Revision as of 00:21, 3 May 2022

Build 12.2

Released April 2022

Compatibility Summary

2005 and 2008 SSIS Components are no longer being updated and supported. These components will now remain static. This release officially supports SQL Server 2019. The SSIS web service components are now compatible with TLS 1.2.

Contact Verification Component

Version: 1.0.1.5082

Address Object Build: 17426

Name Object Build: 17058

Phone Object Build: 17214

Email Object Build: 17152

Geocoder Object Build: 17303

MatchUp Object Build: 5118

Database Date: 04/15/2022

Changes

None

Personator Component

Version: 1.0.0.5103

Changes

None

SmartMover Component

Version: 1.2.0.5054

Changes

None

Fuzzy Matching Component

Version 2.0.0.5028

Changes

None

MatchUp Component

Version 2.2.0.5047

Changes

None

Global Verify Component

Version 2.1.0.5178

Global Address Object Build: 2997 (32bit), 2962 (64bit)

Database Date: 04/15/2022

Changes

Global Verify Name now offers a new input field for Country. The Country name, abbreviation or ISO code can be used. The Country name input will be used during processing as a reference point to use the selected Country's common language for more efficient Name parsing.
Global Verify Name also offers new output fields.

Nickname - This is a string value of an identified nickname from an inputted full name.

A nickname is defined as an internal string surrounded by one of the nickname identifying characters [double quote], [single quote] or [parenthesis]. The identified nickname will be returned unstandardized with the identifier intact.

Professional Title - This is a string value of the professional title from an inputted full name.

Many countries within the European Union identify professional titles as a datatype preceding the first name but separate from a name prefix.

Nickname 2 - This is a string value of an identified nickname from an inputted full name.

If the FullName input property contained multiple names, the nickname of the second name will be returned here.

Professional Title 2 - This is a string value of the professional title from an inputted full name.

If the FullName input property contained multiple names, the professional title of the second name will be returned here.

IPLocator Component

Version 1.0.0.5042

Changes

None

Property Component

Version 1.0.0.5069

Changes

None

Profiler Component

Version 1.0.0.5031

Changes

None

Businesscoder Component

Version 1.0.0.5065

Changes

None

Generalized Cleanser Component

Version 1.0.0.5033

Changes

None

Personator World Component

Version 1.0.0.5018

Changes

None

Build 12.1

Released January 2022

Compatibility Summary

2005 and 2008 SSIS Components are no longer being updated and supported. These components will now remain static. This release officially supports SQL Server 2019. The SSIS web service components are now compatible with TLS 1.2.

Contact Verification Component

Version: 1.0.1.5079

Address Object Build: 17383

Name Object Build: 17048

Phone Object Build: 17167

Email Object Build: 17142

Geocoder Object Build: 17260

MatchUp Object Build: 5118

Database Date: 01/15/2022

Changes

Fixed issue in Contact Verify On Premise GeoCoder. AS03 records are now receiving Latitude and Longitude values.

Personator Component

Version: 1.0.0.5094

Changes

None

SmartMover Component

Version: 1.2.0.5054

Changes

None

Fuzzy Matching Component

Version 2.0.0.5028

Changes

None

MatchUp Component

Version 2.2.0.5047

Changes

None

Global Verify Component

Version 2.1.0.5169

Global Address Object Build: 2997 (32bit), 2962 (64bit)

Database Date: 01/15/2022

Changes

None

IPLocator Component

Version 1.0.0.5038

Changes

None

Property Component

Version 1.0.0.5069

Changes

None

Profiler Component

Version 1.0.0.5031

Changes

None

Businesscoder Component

Version 1.0.0.5056

Changes

None

Generalized Cleanser Component

Version 1.0.0.5033

Changes

None

Personator World Component

Version 1.0.0.5018

Changes

None

Build 11.4

Released October 2021

Compatibility Summary

2005 and 2008 SSIS Components are no longer being updated and supported. These components will now remain static. This release officially supports SQL Server 2019. The SSIS web service components are now compatible with TLS 1.2.

Contact Verification Component

Version: 1.0.1.5075

Address Object Build: 17341

Name Object Build: 17048

Phone Object Build: 17167

Email Object Build: 17100

Geocoder Object Build: 17260

MatchUp Object Build: 5112

Database Date: 10/15/2021

Changes

Contact Verify On Premise GeoCoder data now features the 2020 Census data. GeoCoder Census output fields affected include: Census Block and Census Tract. The fields will now return the 2020 Census values.
Contact Verify Cloud Processing 2020 Census data will be updated on November 15th 2021.
Contact Verify's Token Server URL has been switched to use a POST endpoint.
Contact Verify Token Server POST URL:

https://creditservice.melissadata.net/v3/JSON/service.svc

Personator Component

Version: 1.0.0.5094

Changes

Starting the week of November 15, 2021, Personator’s Census Data will be updated from 2019 to 2020. All clients who are currently using Personator’s default Census outputs will be affected including: Census Block, Census Tract and Census Key.
Decennial CensusKey Option has been added to the SSIS Personator component.
When the option DecennialCensusKey is set to ON, Personator will replace the output of CensusKey using Decennial 2010 Census data.
The option is located in the SSIS Personator component GUI, in the Processing Options tab, under Geo Options.

SmartMover Component

Version: 1.2.0.5054

Changes

None

Fuzzy Matching Component

Version 2.0.0.5028

Changes

None

MatchUp Component

Version 2.2.0.5047

Changes

None

Global Verify Component

Version 2.1.0.5159

Global Address Object Build: 2997 (32bit), 2962 (64bit)

Database Date: 10/15/2021

Changes

Global Verify’s Global Name and Global Address URL’s have been switched to use POST endpoints.
Global Name POST URL:

https://globalname.melissadata.net/V3/WEB/GlobalName/doGlobalName

Global Address POST URL:

https://address.melissadata.net/v3/WEB/GlobalAddress/doGlobalAddress

IPLocator Component

Version 1.0.0.5038

Changes

None

Property Component

Version 1.0.0.5069

Changes

None

Profiler Component

Version 1.0.0.5031

Changes

None

Businesscoder Component

Version 1.0.0.5056

Changes

BusinessCoder's web service URL and token server URL have been switched to use POST endpoints.
BusinessCoder POST URL:

https://businesscoder.melissadata.net/WEB/BusinessCoder/doBusinessCoderUS

BusinessCoder Token Server POST URL:

https://creditservice.melissadata.net/v3/JSON/service.svc

Generalized Cleanser Component

Version 1.0.0.5033

Changes

None

Personator World Component

Version 1.0.0.5018

Changes

None

Build 11.3

Released August 2021

Compatibility Summary

2005 and 2008 SSIS Components are no longer being updated and supported. These components will now remain static. This release officially supports SQL Server 2019. The SSIS web service components are now compatible with TLS 1.2.

Contact Verification Component

Version: 1.0.1.5072

Address Object Build: 17296

Name Object Build: 17048

Phone Object Build: 17167

Email Object Build: 17100

Geocoder Object Build: 17260

MatchUp Object Build: 5109

Database Date: 6/15/2021

Changes

The Congress.dbf has been replaced with the Congress.csv file.

Personator Component

Version: 1.0.0.5081

Changes

The Estimated Home Value output field is now available. The estimated value of the home, given in U.S. Dollars. Will not return for credit licenses and will instead return a GE29 error code.

SmartMover Component

Version: 1.2.0.5054

Changes

None

Fuzzy Matching Component

Version 2.0.0.5028

Changes

None

MatchUp Component

Version 2.2.0.5047

Changes

Domestic and Global data files have been updated. A new MatchUp Global data file has been added, mdGlobalAddr.sac. The following data files have been removed: mdGlobalAddr.3db, icudt52l.dat.

Global Verify Component

Version 2.1.0.5156

Global Address Object Build: 2997 (32bit), 2962 (64bit)

Database Date: 6/15/2021

Changes

None

IPLocator Component

Version 1.0.0.5038

Changes

None

Property Component

Version 1.0.0.5069

Changes

None

Profiler Component

Version 1.0.0.5031

Changes

None

Businesscoder Component

Version 1.0.0.5052

Changes

None

Generalized Cleanser Component

Version 1.0.0.5033

Changes

None

Personator World Component

Version 1.0.0.5018

Changes

None

Build 11.2

Released May 2021

Compatibility Summary

2005 and 2008 SSIS Components are no longer being updated and supported. These components will now remain static. This release officially supports SQL Server 2019. The SSIS web service components are now compatible with TLS 1.2.

Contact Verification Component

Version: 1.0.1.5072

Address Object Build: 17236

Name Object Build: 17048

Phone Object Build: 17167

Email Object Build: 17095

Geocoder Object Build: 17260

MatchUp Object Build: 5083

Database Date: 4/15/2021

Changes

Fixed Dynamic Variable License

Personator Component

Version: 1.0.0.5079

Changes

Fixed Dynamic Variable License

SmartMover Component

Version: 1.2.0.5054

Changes

None

Fuzzy Matching Component

Version 2.0.0.5028

Changes

None

MatchUp Component

Version 2.2.0.5047

Changes

None

Global Verify Component

Version 2.1.0.5156

Global Address Object Build: 2997 (32bit), 2962 (64bit)

Database Date: 4/15/2021

Changes

Fixed Dynamic Variable License

IPLocator Component

Version 1.0.0.5038

Changes

None

Property Component

Version 1.0.0.5069

Changes

None

Profiler Component

Version 1.0.0.5031

Changes

None

Businesscoder Component

Version 1.0.0.5052

Changes

None

Generalized Cleanser Component

Version 1.0.0.5033

Changes

None

Personator World Component

Version 1.0.0.5018

Changes

None

Build 11.1

Released February 2021

Compatibility Summary

2005 and 2008 SSIS Components are no longer being updated and supported. These components will now remain static. This release officially supports SQL Server 2019. The SSIS web service components are now compatible with TLS 1.2. Melissa's web services will enforce TLS 1.2 the week of January 25th, 2021. Please make sure our SSIS web service components are updated with the 10.4 Q4 SSIS release before this date. The TLS 1.2 update will not affect our SSIS on premise components.

Contact Verification Component

Version: 1.0.1.5065

Address Object Build: 17207

Name Object Build: 17044

Phone Object Build: 17162

Email Object Build: 17048

Geocoder Object Build: 17254

MatchUp Object Build: 5083

Database Date: 1/15/2021

Changes

None

Personator Component

Version: 1.0.0.5076

Changes

The Melissa Address Key (MAK) is now available as input for processing.

SmartMover Component

Version: 1.2.0.5054

Changes

PAF ID For Brokers Only - The option allows for Brokers to add PAF ID/EU TOUID in the SmartMover component, available in the Processing Options tab.
Fixed COA report time out.

Fuzzy Matching Component

Version 2.0.0.5028

Changes

None

MatchUp Component

Version 2.2.0.5047

Changes

None

Global Verify Component

Version 2.1.0.5154

Global Address Object Build: 2997 (32bit), 2962 (64bit)

Database Date: 1/15/2021

Changes

None

IPLocator Component

Version 1.0.0.5038

Changes

The AbortOnFailure behavior has been fixed.

Property Component

Version 1.0.0.5069

Changes

None

Profiler Component

Version 1.0.0.5031

Changes

None

Businesscoder Component

Version 1.0.0.5052

Changes

None

Generalized Cleanser Component

Version 1.0.0.5033

Changes

None

Personator World Component

Version 1.0.0.5018

Changes

None

Build 10.4

Released November 2020

Compatibility Summary

2005 and 2008 SSIS Components are no longer being updated and supported. These components will now remain static. This release officially supports SQL Server 2019. The SSIS web service components are now compatible with TLS 1.2. Melissa's web services will enforce TLS 1.2 the week of January 25th, 2021. Please make sure our SSIS web service components are updated with the 10.4 Q4 SSIS release before this date. The TLS 1.2 update will not affect our SSIS on premise components.

Contact Verification Component

Version: 1.0.1.5065

Address Object Build: 17207

Name Object Build: 17044

Phone Object Build: 17162

Email Object Build: 17048

Geocoder Object Build: 17254

MatchUp Object Build: 5083

Database Date: 10/15/2020

Changes

None

Personator Component

Version: 1.0.0.5076

Changes

The Melissa Address Key (MAK) is now available as input for processing.
OwnRent field is available with Demographics subscription only. OwnRent returns the individual's status as owner or renter of the property.

Values Returned
Unknown
Definite Renter
Inferred Renter
Inferred Owner
Definite Owner

SmartMover Component

Version: 1.2.0.5051

Changes

PAF ID For Brokers Only - The option allows for Brokers to add PAF ID/EU TOUID in the SmartMover component. Available in the Processing Options tab.

Fuzzy Matching Component

Version 2.0.0.5028

Changes

None

MatchUp Component

Version 2.2.0.5047

Changes

None

Global Verify Component

Version 2.1.0.5154

Global Address Object Build: 2997 (32bit), 2962 (64bit)

Database Date: 12/15/2020

Changes

Global Verify now offers new options that allow the user additional control over the output of US or CA addresses.

USPreferredCityNames - If set to on, we will override and return only the USPS preferred city name. When set to off it will leave valid vanity city names as preferred by the USPS.
USStandardizationType - When set to Auto this uses the input as a guide for how to standardize. When set to Short (Default) will leave the US address in short abbreviated form as preferred by the USPS.

For example Short:

100 W Main St East

For example Long:

100 West Main Street East

DetailedResults - This is for users that have experience or code using Address Object and would like to have those codes alongside the Global Address result codes. When set to ON (For US and CA addresses only) this will return more detailed and different result codes that come from our Address Object product. When set to OFF (Default) No extra result codes will be returned.

New Input field

Last Name (US only) - This field has been added to allow the use of a Melissa proprietary database. For addresses missing a secondary like a suite or apartment, we can use the last name and append that information for residential addresses. This feature is only available for the US.

New Output Fields

MelissaAddressKey - This is a globally unique and persistent key for the location, even if parts of the address change. When an address is fully validated this field returns a 10-digit proprietary key for the address. With AddressKey (US and Canada only), if an address zip code Changes, the AddressKey would also change. Melissa Address Key (MAK) is independent and will not change. This makes MAK a good way to permanently identify and locate addresses. Once you have a MAK it can be used as an input in most Melissa services and thus is a good tool for deduping. Currently available for US, CA, GB, IT, SI, PT, FR, AU, SG, NL, VN, BM, and TR with many more countries planned for the future.
MelissaAddressKeyBase - Every full address has its own Melissa Address Key (MAK). If that address is a suites or apartment, we will also return a Melissa Address Key Base (BaseMAK) that corresponds to the overall building. This provides a link between all the individual MAK addresses that belong to the same building. This field also returns a 10-digit proprietary key. Note, if we can validate the address to the building but not the suite, we can return just the BaseMAK. Currently available for countries that have support for MelissaAddressKey.
DeliveryIndicator - This field returns a one character code that indicates if the address is a residence (R), business (B), or unknown (U). It is not available for all countries. Currently, it is available only for the US but more countries are planned for future inclusion.
DeliveryPointSuffix - This is a country dependent field. This field returns an identifier that represents asuffix code usually tied to a delivery point. For US This returns the 2 digit delivery point assigned by the USPS to an DPV validated address. For GB This is a 2 character (first is numerical, 2nd character is alphabetic) that is assigned by Royal Mail. When added to the postal code, this allows each live delivery point to be uniquely identified.
PostalCodeType - This is a country dependent field. This field returns an identifier that represents the type of postal code returned. Currently only the US uses this field.

Code	Short Description
P	PO Box Postal Code
U	Unique Postal Code usually assigned to a large organization or government institution.
M	Military Postal Code
[Empty]	Regular postal code

PostOfficeLocation - This field, if available for a country, returns the value that is associated to the location of the post office in relation to the address. This value may or may not be used in the official mailing address for the country in question. Currently, these are the countries we will return the data for: Serbia and Slovakia.

Code	Short Description
Serbia	The PostOfficeLocation contains the old 5 digit postal number and name. The postal code field will contain the new 6 digit PAK number.
Slovakia	The PostOfficeLocation retuns the name of the post office location if it is not the same as the delivery address locality.

SubPremiseLevel - This is a secondary piece of subpremise information used to describe a more generic division of the subpremise. For example, if you have an address like “1123 Market Way, Floor 12 Apt 25A” then the Subpremises will be “Apt 25A” and the SubPremiseLevel will be “Floor 12”. This value is not widely used in official address data.

SubPremiseLevelType and SubPremiseLevelNumber make up the SubPremiseLevel. In our example, the SubPremiseLevelType is “Floor” and the SubPremiseLevelNumber is “12”.

SubBuilding - This value describes a smaller division of the building. For example, if an address has a building name that is a part of a larger set of buildings, then the subbuilding may be populated.

SubBuildingType and SubBuildingNumber make up the parts of SubBuilding.

UTC - Returns the Coordinated Universal Time number in format of UTC+#. Note that there are timezones that are not whole hours only, like UTC+9:30.
DST - Returns a Y or a N based on if the country or area of the input observes daylight savings time. Note that the value returned by the UTC output does not change based on whether the country/area is currently in daylight savings time for not. We will only return the standard timezone and this flag to indicate is daylight savings is observed.
CensusKey - This is a country dependent field. It is designed to return a code that correspond to the census division information for a country. Currently, this field is only returned for the US.

Code	Short Description
US	The CensusKey for the US is a 15 or 16 digit code that is made up of the following components: FIPS Code, Census Tract, Census Block, and CensusBlockGroup if it exists

Extras option - This element is usually not populated but is reserved to be able to return less used fields if the user requests. Currently, we are using this to return some US only fields. If you specify “USExtras:ON” in the options, we can return additional outputs. A destination component will be needed for the Extra records.
CBSA Outputs

CBSACode
CBSADivisionCode
CBSADivisionLevel
CBSADivisionTitle
CBSALevel
CBSATitle

CarrierRoute - Carrier Route Code assigned by the USPS
CensusBlock - The Census block number from the most recent yearly census
CensusTract - The Census tract number from the most recent yearly census
CongressionalDistrict - The congressional district number for the address
CountyFIPS - The Census FIPS number from the most recent yearly census
CountyName - The county name that corresponds to the county FIPS code
CountySubdivisionCode - The county subdivision code value as defined by the US Census
CountySubdivisionName - The county subdivision name value as defined by the US Census
DeliveryPointCheckDigit - The single digit value that acts as a checksum to the delivery point code
DeliveryPointCode - The 2 digit delivery point code as assigned by the USPS
ElementarySchoolDistrictCode - Returns a 5 digit string representing the elementary school district code for the address
ElementarySchoolDistrictName - Returns a 5 digit string representing the elementary school district code for the address
PlaceCode - The FIPS Place code as defined by the Census
PlaceName - The FIPS Place name as defined by the Census
SecondarySchoolDistrictCode - The secondary school district code for the address
SecondarySchoolDistrictName - The secondary school district name for the address
StateDistrictLower - Returns a 3 digit string representing the Lower State District Code for the requested record
StateDistrictUpper - Returns a 3 digit string representing the Upper State District Code for the requested record
UnifiedSchoolDistrictCode - Returns a 5 digit string representing the Unified School District Code if the address is in a unified school district
UnifiedSchoolDistrictNameString - Returns a 5 digit string representing the Unified School District Name if the address is in a unified school district

Global Verify Email offers 2 new Result Codes when processing Domains only. For example: "@gmail.com" or "gmail.com"

Code	Short Description
DV01	Valid domain
DE03	Invalid domain

The following Global Verify Phone service Result Codes have been removed

Code	Short Description
PS09	VOIP Line
PS13	Toll Free Number
PS14	Special Number
PS15	Misc Type
PS16	Live Status Unknown
PS17	Live Number
PS21	Medium Confidence

With PS21 (medium confidence) no longer being returned, only PS20 (low confidence) and PS22 (high confidence) are going to be available for determining the verification confidence on a given phone number. The records that previously returned PS21 will now return as PS22. However, PS22 is still only returned through the Premium version of the service.

The following result codes will now ONLY be available for North America using the Premium version of the Phone service:

Code	Short Description
PS07	Cellphone
PS08	Landline Activity

IPLocator Component

Version 1.0.0.5035

Changes

None

Property Component

Version 1.0.0.5069

Changes

None

Profiler Component

Version 1.0.0.5031

Changes

None

Businesscoder Component

Version 1.0.0.5052

Changes

None

Generalized Cleanser Component

Version 1.0.0.5033

Changes

None

Personator World Component

Version 1.0.0.5018

Changes

Personator World Email TimeToWait option has been modified to 5-45s.

Build 10.3

Released August 2020

Compatibility Summary

2005 and 2008 SSIS Components are no longer being updated and supported. These components will now remain static. This release officially supports SQL Server 2016 and SQL Server 2017. This release also officially supports SQL Server 2019.

Contact Verification Component

Version: 1.0.1.5062

Address Object Build: 17166

Name Object Build: 17012

Phone Object Build: 17090

Email Object Build: 17048

Geocoder Object Build: 17222

MatchUp Object Build: 5083

Database Date: 6/15/2020

Changes

None

Personator Component

Version: 1.0.0.5067

Changes

None

SmartMover Component

Version: 1.2.0.5037

Changes

None

Fuzzy Matching Component

Version 2.0.0.5028

Changes

None

MatchUp Component

Version 2.2.0.5047

Changes

None

Global Verify Component

Version 2.1.0.5112

Global Address Object Build: 2997 (32bit), 2962 (64bit)

Database Date: 6/15/2020

Changes

Global Verify Email's TimeToWait option can now accept 5-45 seconds. Default is set to 25 seconds. TimeToWait allows you to select how long (in seconds) that you would like our web service to wait on a single email before it times out.

IPLocator Component

Version 1.0.0.5035

Changes

None

Property Component

Version 1.0.0.5069

Changes

None

Profiler Component

Version 1.0.0.5031

Changes

None

Businesscoder Component

Version 1.0.0.5049

Changes

None

Generalized Cleanser Component

Version 1.0.0.5033

Changes

None

Personator World Component

Version 1.0.0.5018

Changes

None

Build 10.2

Released June 2020

Compatibility Summary

2005 and 2008 SSIS Components are no longer being updated and supported. These components will now remain static. This release officially supports SQL Server 2016 and SQL Server 2017.

Contact Verification Component

Version: 1.0.1.5048

Address Object Build: 17058

Name Object Build: 17012

Phone Object Build: 17021

Email Object Build: 17048

Geocoder Object Build: 17187

MatchUp Object Build: 5083

Database Date: 4/15/2020

Changes

Contact Verify Email has been updated to use the mdEmail.db3 data file that includes on premise cache functionality. The mdEmail.db3 will replace the mdEmail.dat file.

Personator Component

Version: 1.0.0.5061

Changes

None

SmartMover Component

Version: 1.2.0.5031

Changes

None

Fuzzy Matching Component

Version 2.0.0.5025

Changes

None

MatchUp Component

Version 2.2.0.5043

Changes

None

Global Verify Component

Version 2.1.0.5102

Global Address Object Build: 2997 (32bit), 2962 (64bit)

Database Date: 4/15/2020

Changes

Global Verify has a new output field available; the MXServer field will return which MXServer was used to validate the email address. Only available in Premium Mode.

IPLocator Component

Version 1.0.0.5029

Changes

None

Property Component

Version 1.0.0.5061

Changes

None

Profiler Component

Version 1.0.0.5028

Changes

None

Businesscoder Component

Version 1.0.0.5043

Changes

None

Generalized Cleanser Component

Version 1.0.0.5030

Changes

None

Personator World Component

Version 1.0.0.5018

Changes

None

Build 10.1

Released March 2020

Compatibility Summary

2005 and 2008 SSIS Components are no longer being updated and supported. These components will now remain static. This release officially supports SQL Server 2016 and SQL Server 2017.

Contact Verification Component

Version: 1.0.1.5043

Address Object Build: 17058

Name Object Build: 17012

Phone Object Build: 17021

Email Object Build: 3361

Geocoder Object Build: 17053

MatchUp Object Build: 5070

Database Date: 1/15/2020

Changes

Fixed bug with result code GW05 returning when using Contact Verify Email
Contact Verify Email has been reverted to include the mdEmail.dat file instead of the mdEmail.db3 file.

Personator Component

Version: 1.0.0.5055

Changes

None

SmartMover Component

Version: 1.2.0.5027

Changes

None

Fuzzy Matching Component

Version 2.0.0.5017

Changes

None

MatchUp Component

Version 2.2.0.5040

Changes

None

Global Verify Component

Version 2.1.0.5063

Global Address Object Build: 2997 (32bit), 2962 (64bit)

Database Date: 1/15/2020

Changes

None

IPLocator Component

Version 1.0.0.5025

Changes

None

Property Component

Version 1.0.0.5057

Changes

None

Profiler Component

Version 1.0.0.5024

Changes

None

Businesscoder Component

Version 1.0.0.5032

Changes

None

Generalized Cleanser Component

Version 1.0.0.5022

Changes

None

Personator World Component

Version 1.0.0.5018

Changes

None

Build 9.4

Released November 2019

Compatibility Summary

2005 and 2008 SSIS Components are no longer being updated and supported. These components will now remain static.

This release officially supports SQL Server 2016 and SQL Server 2017.

Contact Verification Component

Version: 1.0.1.5030

Address Object Build: 3333

Name Object Build: 3333

Phone Object Build: 3333

Email Object Build: 17018

Geocoder Object Build: 17118

MatchUp Object Build: 5060

Database Date: 9/15/2019

Changes

Contact Verify Email is now using a new data file, mdEmail.db3 822 MB. It will replace the mdEmail.dat 680 MB file.

Personator Component

Version: 1.0.0.5055

Changes

None

SmartMover Component

Version: 1.2.0.5027

Changes

None

Fuzzy Matching Component

Version 2.0.0.5017

Changes

None

MatchUp Component

Version 2.2.0.5040

Changes

None

Global Verify Component

Version 2.1.0.5063

Global Address Object Build: 2997 (32bit), 2962 (64bit)

Database Date: 9/15/2019

Changes

New Result Code added to Global Verify Phone. The PS18 Result Code will indicate if the phone number is on Melissa's Do Not Call list.

Code	Short Description	Long Description
PS18	Do Not Call	The phone number was found in Melissa's proprietary Do Not Call list.

IPLocator Component

Version 1.0.0.5025

Changes

None

Property Component

Version 1.0.0.5057

Changes

None

Profiler Component

Version 1.0.0.5024

Changes

None

Businesscoder Component

Version 1.0.0.5032

Changes

None

Generalized Cleanser Component

Version 1.0.0.5022

Changes

None

Personator World Component

Version 1.0.0.5018

Changes

New Result Code added to Personator World Phone. The PS18 Result Code will inform if the phone number is on Melissa's Do Not Call list.

Code	Short Description	Long Description
PS18	Do Not Call	The phone number was found in Melissa's proprietary Do Not Call list.

Build 9.3

Released September 2019

Compatibility Summary

2005 SSIS Components are no longer being updated and supported. These components will now remain static. This release officially supports SQL Server 2016 and SQL Server 2017. Global Phone V3 was be depreciated in Q4. We have replaced it with a new Global Phone V4 WS which offers real-time phone check.

The Global Verify component has been updated with Global Email Web Service V4. The new Global Email Web Service V4 offers new response fields specifically for Email domain and server information. The update will also apply changes to Global Verify's Result Codes. Global Verify will no longer return the result code of ES02 – Invalid Email. If your logic is dependent on the Result Code ES02, please modify the logic in your code accordingly and follow proper update procedures to prevent sudden disruption of service. Errors will simply result in EEXX format, indicating Email Errors. You can continue to use our existing Global Email Web Service V3 by simply unchecking the Global Verify component in the SSIS installer. This will ensure that the Global Verify component will not be updated. The Global Email Web Service V3 service will remain active but will no longer receive feature updates.

Contact Verification Component

Version: 1.0.1.5030

Address Object Build: 3333

Name Object Build: 3361

Phone Object Build: 3361

Email Object Build: 3361

Geocoder Object Build: 17118

MatchUp Object Build: 5060

Database Date: 6/15/2019

Changes

None

Personator Component

Version: 1.0.0.5052

Changes

Added Demographics CreditCardUser to output

CreditCardUser: Returns whether the user has a credit card or not.

SmartMover Component

Version: 1.2.0.5027

Changes

None

Fuzzy Matching Component

Version 2.0.0.5016

Changes

None

MatchUp Component

Version 2.2.0.5040

Changes

None

Global Verify Component

Version 2.1.0.5049

Global Address Object Build: 2997 (32bit), 2962 (64bit)

Database Date: 6/15/2019

Changes

None

IPLocator Component

Version 1.0.0.5024

Changes

None

Property Component

Version 1.0.0.5057

Changes

New Output Field Available

Associated Parcels: Returns parcel information that matched the users input. Associated Parcels will provide a list of parcels by their APN, FIPs and MAK key, specifically for the YS05 (multiple matches) result code.

For example, if a record is sent using an addresskey and if Melissa's property data had multiple records for the same address key, Associated Parcels will provide the list of matching parcels.

Profiler Component

Version 1.0.0.5024

Changes

None

Businesscoder Component

Version 1.0.0.5032

Changes

None

Generalized Cleanser Component

Version 1.0.0.5022

Changes

None

Personator World Component

Version 1.0.0.5018

Changes

None

Build 9.2

Released June 2019

Compatibility Summary

2005 SSIS Components are no longer being updated and supported. These components will now remain static. This release officially supports SQL Server 2016 and SQL Server 2017. Global Phone V3 was be depreciated in Q4. We have replaced it with a new Global Phone V4 WS which offers real-time phone check.

The Global Verify component has been updated with Global Email Web Service V4. The new Global Email Web Service V4 offers new response fields specifically for Email domain and server information. The update will also apply changes to Global Verify's Result Codes. Global Verify will no longer return the result code of ES02 – Invalid Email. If your logic is dependent on the Result Code ES02, please modify the logic in your code accordingly and follow proper update procedures to prevent sudden disruption of service. Errors will simply result in EEXX format, indicating Email Errors. You can continue to use our existing Global Email Web Service V3 by simply unchecking the Global Verify component in the SSIS installer. This will ensure that the Global Verify component will not be updated. The Global Email Web Service V3 service will remain active but will no longer receive feature updates.

Contact Verification Component

Version: 1.0.1.5030

Address Object Build: 3283

Name Object Build: 3283

Phone Object Build: 3283

Email Object Build: 3283

Geocoder Object Build: 3283

MatchUp Object Build: 5058

Database Date: 4/15/2019

Changes

None

Personator Component

Version: 1.0.0.5050

Changes

The Output group Basic (Default) Fields can be selected.

SmartMover Component

Version: 1.2.0.5027

Changes

None

Fuzzy Matching Component

Version 2.0.0.5016

Changes

None

MatchUp Component

Version 2.2.0.5040

Changes

None

Global Verify Component

Version 2.1.0.5049

Global Address Object Build: 2997 (32bit), 2962 (64bit)

Database Date: 4/15/2019

Changes

The new Global Email Web Service V4 has been integrated into Global Verify. The update offers new response fields specifically for Email domain and server information. The update will also apply changes to Global Verify's Result Codes. Global Verify will no longer return the result code of ES02 – Invalid Email. If your logic is dependent on the Result Code ES02, please modify the logic in your code accordingly and follow proper update procedures to prevent sudden disruption of service. Errors will simply result in EEXX format, indicating Email Errors.

New Output Fields

Domain Age Estimated: The estimated age of the domain in days.
Domain Expiration Date: The date the domain expires/expired in the YYYY-MM-DDTHH:MM:SS format.
Domain Created Date: The date the domain was created in the YYYY-MM-DDTHH:MM:SS format.
Domain Updated Date: The date the domain was last updated in the YYYY-MM-DDTHH:MM:SS format.
Domain Email: The email associated with the domain.
Domain Organization: The organization associated with the domain.
Domain Address 1: The street address associated with the domain.
Domain Locality: The locality associated with the domain.
Domain Administrative Area: The administrative area associated with the domain.
Domain Postal Code: The postal code associated with the domain.
Domain Country: The country associated with the domain.
Domain Country Code: The country code associated with the domain.
Domain Availability: Check to see if domain is available for purchase.
Domain Private Proxy: Check if domain is behind a private proxy.
Deliverability Confidence Score: Returns the probability [0-100] % of an email sent to this mailbox will be successfully delivered.
Privacy Flag: The top level domains or countries that may be sensitive to privacy laws. Returns Y for yes and N for no.

IPLocator Component

Version 1.0.0.5024

Changes

None

Property Component

Version 1.0.0.5053

Changes

None

Profiler Component

Version 1.0.0.5024

Changes

None

Businesscoder Component

Version 1.0.0.5032

Changes

None

Generalized Cleanser Component

Version 1.0.0.5022

Changes

None

Personator World Component

Version 1.0.0.5018

Changes

None

Build 9.1

Released February 2019

Compatibility Summary

2005 SSIS Components are no longer being updated and supported. These components will now remain static. This release officially supports SQL Server 2016 and SQL Server 2017. Global Phone V3 was be depreciated in Q4. We have replaced it with a new Global Phone V4 WS which offers real-time phone check.

Contact Verification Component

Version: 1.0.1.5029

Address Object Build: 3283

Name Object Build: 3283

Phone Object Build: 3283

Email Object Build: 3283

Geocoder Object Build: 3283

MatchUp Object Build: 5054

Database Date: 1/15/2019

Changes

Custom Expression Filter and Pre-built filter is now accessible when switching processing modes.

Personator Component

Version: 1.0.0.5049

Changes

License string is now appended to Personator component when license is entered in the installer.
Address House Number output column length has been extended.

SmartMover Component

Version: 1.2.0.5027

Changes

None

Fuzzy Matching Component

Version 2.0.0.5016

Changes

None

MatchUp Component

Version 2.2.0.5040

Changes

Component is now appending environmental variable license string.

Global Verify Component

Version 2.1.0.5042

Global Address Object Build: 2997 (32bit), 2962 (64bit)

Database Date: 1/15/2019

Changes

None

IPLocator Component

Version 1.0.0.5024

Changes

None

Property Component

Version 1.0.0.5051

Changes

None

Profiler Component

Version 1.0.0.5024

Changes

None

Businesscoder Component

Version 1.0.0.5031

Changes

Record ID output column length has been extended.

Generalized Cleanser Component

Version 1.0.0.5022

Changes

None

Personator World Component

Version 1.0.0.5018

Changes

None

Build 8.4

Released December 2018

Compatibility Summary

2005 SSIS Components are no longer being updated and supported. These components will now remain static. This release officially supports SQL Server 2016 and SQL Server 2017. Global Phone V3 was be depreciated in Q4. We have replaced it with a new Global Phone V4 WS which offers real-time phone check.

Contact Verification Component

Version: 1.0.1.5023

Address Object Build: 3067

Name Object Build: 3067

Phone Object Build: 3067

Email Object Build: 3067

Geocoder Object Build: 3243

MatchUp Object Build: 5050

Database Date: 10/15/2018

Changes

The following effects On Premise data installs only: The mdGeoCode.db3 file will now replace the GeoCode and GeoPoints files.

Personator Component

Version: 1.0.0.5040

Changes

New Credit Subscription Available

Personator now accepts developer credit licenses.

New Input Fields are Available:

IPAddress - Retrieve IP Address information
BirthDay - Insert Birth Day DD
BirthMonth - Insert Birth Month MM
BirthYear - Insert Birth Year YY

New Column Group Output Field Available:

The GrpIPAddress column group contains the follwing output fields
DistanceAddressToIP - This is the distance in miles between the latitude and longitude of the physical location of the IP Address and the latitude and longitude of the input Address
IPAddress -The IP address being looked up
IPCity - The city where the IP address is located
IPConnectionSpeed - The connection speed associated with this IP address
IPConnectionType - The type of connection used by this IP address
IPContinent - The continent where the IP address is located
IPCountryAbbreviation - The ISO 3166-1 alpha-2 country code of the country where the IP address is located
IPCountryName - The full name of the country where the IP address is located
IPDomainName - The domain name associated with this IP address
IPISPName - The name of the Internet Service Provider associated with the IP Address
IPLatitude - The latitude for the IP address. This usually points to the IP Address's postal code
IPLongitude - The longitude for the IP address. This usually points to the IP Address's postal code
IPPostalCode - The postal code where the IP Address is located
IPProxyDescription - Additional Details for the Proxy Type returned
IPProxyType - The type of proxy for an IP Address
IPRegion - The region where the IP address is located, specific meaning varies from country to country. For IPs in the US this field returns the state that the IP is located within
IPUTC - The GMT offset for the area where the IP address is located

Smartmover Component

Version: 1.2.0.5023

Changes

None

Fuzzy Matching Component

Version 2.0.0.5014

Changes

None

Matchup Component

Version 2.2.0.5038

Changes

The Matchcode Editor has been updated to evaluate matchcodes.
The new editor will return 3 levels of Matchcode evaluation.

Optimized Matchcode - This Matchcode's properties satisfy the condition needed for efficient clustering. Benchmarking test should return high throughput.
Sub Optimal Matchcode - This Matchcode's first component does NOT satisfy the conditions needed for efficient clustering. We don't recommend using this Matchcode for batch processes with considerable record volume.
Warning Matchcode - At least one component in this Matchcode does NOT satisfy the conditions needed for efficient clustering. Benchmarking tests should be performed before usage in production as throughput may not be optimal.

Golden Record Survivorship now has the option to gather MS03 records
Matchup now has a output filter for the lookup stream in order to capture intersecting records only

Global Verify Component

Version 2.1.0.5038

Global Address Object Build: 2997 (32bit), 2962 (64bit)

Database Date: 10/15/2018

Changes

New Credit Subscription Available

Global Verify now accepts developer credit licenses.

Iplocator Component

Version 1.0.0.5020

Changes

New Credit Subscription Available

IPLocator now accepts developer credit licenses.

Property Component

Version 1.0.0.5047

Changes

New Credit Subscription Available

Property now accepts developer credit licenses.

Profiler Component

Version 1.0.0.5019

Changes

None

Businesscoder Component

Version 1.0.0.5027

Changes

New Credit Subscription Available

BusinessCoder now accepts developer credit licenses.

Generalized Cleanser Component

Version 1.0.0.5018

Changes

None

Personator World Component

Version 1.0.0.5018

Changes

None

Build 8.3

Released August 2018

Compatibility Summary

2005 SSIS Components are no longer being updated and supported. These components will now remain static. This release officially supports SQL Server 2016 and SQL Server 2017. Global Phone V3 was be depreciated in Q4. We have replaced it with a new Global Phone V4 WS which offers real-time phone check.

Contact Verification Component

Version: 1.0.1.5022

Address Object Build: 3067

Name Object Build: 3067

Phone Object Build: 3067

Email Object Build: 3067

Geocoder Object Build: 3108

MatchUp Object Build: 5028

Database Date: 07/15/2018

Changes

When Processing Mode is set to Melissa Data Cloud, Contact Verify excludes Melissa Address Key and Melissa Address Key Base output fields.

Personator Component

Version: 1.0.0.5026

Changes

New Centric Hint Option Available
Personator now includes Name input as a Centric Hint in the Verify and Append Options, in the Processing Options tab. When Name is chosen, it will use Name as the primary point of reference when verifying information.

SmartMover Compontent

Version: 1.2.0.5023

Changes

New Dynamic Variable Available

SmartMover has included JobID as a dynamic variable

Fuzzy Matching Component

Version 2.0.0.5014

Changes

None

MatchUp Component

Version 2.2.0.5029

Changes

None

Global Verify Component

Version 2.1.0.5028

Global Address Object Build: 2997 (32bit), 2962 (64bit)

Database Date: 07/15/2018

Changes

Fixed Sub Administrative Area data for Australia not being returned.

IPLocator Component

Version 1.0.0.5019

Changes

None

Property Component

Version 1.0.0.5038

Changes

None

Profiler Component

Version 1.0.0.5019

Changes

None

Businesscoder Component

Version 1.0.0.5023

Changes

None

Generalized Cleanser Component

Version 1.0.0.5018

Changes

None

Personator World Component

Version 1.0.0.5018

Changes

None

Build 8.2

Released May 2018

Compatibility Summary

2005 SSIS Components are no longer being updated and supported. These components will now remain static. This release officially supports SQL Server 2016 and SQL Server 2017. Global Phone V3 was be depreciated in Q4. We have replaced it with a new Global Phone V4 WS which offers real-time phone check.

Contact Verification Component

Version: 1.0.1.5018

Address Object Build: 3067

Name Object Build: 3067

Phone Object Build: 3067

Email Object Build: 3067

Geocoder Object Build: 3108

MatchUp Object Build: 5023

Database Date: 04/15/2018

Changes

None

Personator Component

Version: 1.0.0.5023

Changes

None

Smartmover Component

Version: 1.2.0.5019

Changes

The following output field has been added

Delivery Indication - Returns RBDI (Residential Business Delivery Indicator) information for addresses. Most shipping carriers charge a higher price for residential deliveries. RBDI helps ensure that you select the most cost-effective function for shipping parcels by identifying residential addresses. The field will output R for residential address, B for business address or U for unknown.

Fuzzy Matching Component

Version 2.0.0.5012

Changes

None

Matchup Component

Version 2.2.0.5024

Changes

None

Global Verify Component

Version 2.1.0.5023

Global Address Object Build: 2997 (32bit), 2962 (64bit)

Database Date: 04/15/2018

Changes

None

IP Locator Component

Version 1.0.0.5014

Changes

None

Property Component

Version 1.0.0.5036

Changes

Fixed Bugs:

Basic output fields selected by default
Account input field has been moved under FIPS field in interface
Basic output fields can now be selected individually

The following output fields have been added

Shape - Well Known Text - Returns parcel shape information

Profiler Component

Version 1.0.0.5017

Changes

None

Businesscoder Component

Version 1.0.0.5021

Changes

None

Generalized Cleanser Component

Version 1.0.0.5016

Changes

None

Personator World Component

Version 1.0.0.5021

Changes

None

Build 8.1

Released February 2018

Compatibility Summary: 2005 SSIS Components are no longer being updated and supported. These components will now remain static. This release officially supports SQL Server 2016. Global Phone V3 was be depreciated in Q4. We have replaced it with a new Global Phone V4 WS which offers real-time phone check.

Contact Verification Component: Version: 1.0.1.5011; Address Object Build: 3067; Name Object Build: 3067; Phone Object Build: 3067; Email Object Build: 3067; Geocoder Object Build: 3108; MatchUp Object Build: 5023; Database Date: 01/15/2018

Changes

New Feature:

Added Local Geologging - A log file containing the Customer ID, Date/Time, GS01-GS06 result code counts and a Checksum for unique records.

Personator Component: Version: 1.0.0.5014

Changes

New Feature:

Move Confidence Removal
Added Social Security Number (SSN) Input
Added Social Security Number (SSN) Result Codes

VR11 - Name and SSN Match - Matched the name field to the Social Security Number.

VS50 - Last4 Only Match - The name only matched to the last 4 digits of the Social Security Number.

SN01 - Invalid SSN Format - The format of your Social Security Number was invalid.

Added Social Security to Centric Hint in Processing Options
Added Social Security Number Cascade Option

When the option is turned on, this will allow SSN validation to cascade down the set of rules described below until a match is found

Full Name + Full SSN: VR11 if match, SP01 if no match

Last Name + Full SSN: VR11,VS12 if match, SP01 if no match

Full Name + Last 4 SSN: VR11,VS50 if match, SP01 if no match

Last Name + Last 4 SSN: VR11,VS12,VS50 if match, SP01 if no match

Added the following output fields to the Personator Demographics Output Group

ChildrenAgeRange - Returns the age range of children present in the household.

CreditCardUser - Returns whether the user has a credit card or not.

Education - Returns the highest level of education completed by an individual.

EthnicCode - Returns an individual’s specific ethnicity.

EthnicGroup - Returns the grouped category for a person’s ethnicity. This is a more generalized grouping compared to Ethnic Codes.

HouseholdSize - Returns the number of occupants in the household.

PoliticalParty - Returns an individual’s political affiliation.

PresenceOfSenior - Returns the presence of senior(s) in the household.

Added the following output fields to the Personator Output Columns

MelissaAddressKey - Returns a unique key associated with an address.

MelissaAddressKeyBase - Returns a unique key associated with a building containing multiple suites/apartments.

PhoneCountryName - Returns the full country name for the phone number entered in the Phone field.

PhoneCountryCode - Returns the 2 character country code for the phone number entered in the Phone field.

Smartmover Component: Version: 1.2.0.5010

Changes

Added MoveTypeCode to output column

MoveTypeCode - Type of move (individual or business)

Fuzzy Matching Component: Version 2.0.0.5008

Changes

None

Matchup Component: Version 2.2.0.5015

Changes

Fixed Bugs:

Mappings reset when global matchcode components changed

Global Verify Component: Version 2.1.0.5018; Global Address Object Build: 2921 (32bit), 2921 (64bit); Database Date: 10/15/2018

Changes

New Feature:

Added output field

Country Subdivision Code - This is the ISO3166-2 code for country subdivisions, usually tied to the administrative area for a country. The format is the 2 letter country code followed by a dash followed by 2 or 3 characters or two numbers.

IP Locator Component: Version 1.0.0.5009

Changes

None

Property Component: Version 1.0.0.5027

Changes

New Feature:

Added V4 LookupProperty Output Fields

GrpParcel: FIPSCode; County; UnformattedAPN; FormattedAPN; AlternateAPN; APNYearChange; PreviousAPN; AccountNumber; YearAdded; MapBook; MapPage; TaxJurisdiction; CBSAName; CBSACode; MSAName; MSACode; MetropolitanDivision; MinorCivilDivisionName; MinorCivilDivisionCode; NeighborhoodCode; CensusTract; CensusBlockGrp; CensusBlock

GrpLegal: LegalDescription; Range; Township; Section; Quarter; QuarterQuarter; Subdivision; Phase; TractNumber; Block1; Block2; LotNumber1; LotNumber2; LotNumber3; Unit

GrpPropertyAddress: Address; City; State; Zip; CarrierRoute; AddressKey; MAK; BaseMAK; Latitude; Longitude; PrivacyInfo

GrpParsedPropertyAddress: Range; PreDirectional; StreetName; Suffix; PostDirectional; SuiteName; SuiteRange

GrpPrimaryOwner: Name1Full; Name1First; Name1Middle; Name1Last; Name1Suffix; TrustFlag; CompanyFlag; Name2Full; Name2First; Name2Middle; Name2Last; Name2Suffix; Type; VestingType

GrpSecondaryOwner: Name3Full; Name3First; Name3Middle; Name3Last; Name3Suffix; Name4Full; Name4First; Name4Middle; Name4Last; Name4Suffix; Type

GrpOwnerAddress: Address; City; State; Zip; CarrierRoute; MAK; BaseMAK; FormatInfo; PrivacyInfo; OwnerOccupied

GrpLastDeedOwnerInfo: Name1Full; Name1First; Name1Middle; Name1Last; Name1Suffix; Name2Full; Name2First; Name2Middle; Name2Last; Name2Suffix; Name3Full; Name3First; Name3Middle; Name3Last; Name3Suffix; Name4Full; Name4First; Name4Middle; Name4Last; Name4Suffix

GrpCurrentDeed: MortgageAmount; MortgageDate; MortgageLoanTypeCode; MortgageTermCode; MortgageTerm; MortgageDueDate; LenderCode; LenderName; SecondMortgageAmount; SecondMortgageLoanTypeCode; GrantorName1Full; GrantorName2Full; GrantorName3Full; GrantorName4Full; GranteeName1Full; GranteeName2Full; GranteeName3Full; GranteeName4Full

GrpTax: YearAssessed; AssessedValueTotal; AssessedValueImprovements; AssessedValueLand; AssessedImprovementsPerc; PreviousAssessedValue; MarketValueYear; MarketValueTotal; MarketValueImprovements; MarketValueLand; MarketImprovementsPerc; TaxFiscalYear; TaxRateArea; TaxBilledAmount; TaxDelinquentYear; LastTaxRollUpdate; AssrLastUpdated; TaxExemptionHomeowner; TaxExemptionDisabled; TaxExemptionSenior; TaxExemptionVeteran; TaxExemptionWidow; TaxExemptionAdditional

GrpPropertyUseInfo: YearBuilt; YearBuiltEffective; ZonedCodeLocal; PropertyUseMuni; PropertyUseGroup; PropertyUseStandardized

GrpSaleInfo: AssessorLastSaleDate; AssessorLastSaleAmount; AssessorPriorSaleDate; AssessorPriorSaleAmount; LastOwnershipTransferDate; LastOwnershipTransferDocumentNumber; LastOwnershipTransferTxID; DeedLastSaleDocumentBook; DeedLastSaleDocumentPage; DeedLastDocumentNumber; DeedLastSaleDate; DeedLastSalePrice; DeedLastSaleTxID

GrpPropertySize: AreaBuilding; AreaBuildingDefinitionCode; AreaGross; Area1stFloor; Area2ndFloor; AreaUpperFloors; AreaLotAcres; AreaLotSF; LotDepth; LotWidth; AtticArea; AtticFlag; BasementArea; BasementAreaFinished; BasementAreaUnfinished; ParkingGarage; ParkingGarageArea; ParkingCarport; ParkingCarportArea

GrpPool: Pool; PoolArea; SaunaFlag

GrpIntStructInfo: Foundation; Construction; InteriorStructure; PlumbingFixturesCount; ConstructionFireResistanceClass; SafetyFireSprinklersFlag; FlooringMaterialPrimary

GrpIntRoomInfo: BathCount; BathPartialCount; BedroomsCount; RoomsCount; StoriesCount; UnitsCount; BonusRoomFlag; BreakfastNookFlag; CellarFlag; CellarWineFlag; ExcerciseFlag; FamilyCode; GameFlag; GreatFlag; HobbyFlag; LaundryFlag; MediaFlag; MudFlag; OfficeArea; OfficeFlag; SafeRoomFlag; SittingFlag; StormFlag; StudyFlag; SunroomFlag; UtilityArea; UtilityCode

GrpIntAmenities: Fireplace; FireplaceCount; AccessabilityElevatorFlag; AccessabilityHandicapFlag; EscalatorFlag; CentralVacuumFlag; IntercomFlag; SoundSystemFlag; WetBarFlag; SecurityAlarmFlag

GrpExtStructInfo: StructureStyle; Exterior1Code; RoofMaterial; RoofConstruction; StormShutterFlag; OverheadDoorFlag

GrpExtAmenities: ViewDescription; PorchCode; PorchArea; PatioArea; DeckFlag; DeckArea; FeatureBalconyFlag; BalconyArea; BreezewayFlag

GrpExtBuildings: BuildingsCount; BathHouseArea; BathHouseFlag; BoatAccessFlag; BoatHouseArea; BoatHouseFlag; CabinArea; CabinFlag; CanopyArea; CanopyFlag; GazeboArea; GazeboFlag; GranaryArea; GranaryFlag; GreenHouseArea; GreenHouseFlag; GuestHouseArea; GuestHouseFlag; KennelArea; KennelFlag; LeanToArea; LeanToFlag; LoadingPlatformArea; LoadingPlatformFlag; MilkHouseArea; MilkHouseFlag; OutdoorKitchenFireplaceFlag; PoolHouseArea; PoolHouseFlag; PoultryHouseArea; PoultryHouseFlag; QuonsetArea; QuonsetFlag; ShedArea; ShedCode; SiloArea; SiloFlag; StableArea; StableFlag; StorageBuildingArea; StorageBuildingFlag; UtilityBuildingArea; UtilityBuildingFlag; PoleStructureArea; PoleStructureFlag

GrpUtilities: HVACCoolingDetail; HVACHeatingDetail; HVACHeatingFuel; SewageUsage; WaterSource; MobileHomeHookupFlag

GrpParking: RVParkingFlag; ParkingSpaceCount; DrivewayArea; DrivewayMaterial

GrpYardGardenInfo: TopographyCode; FenceCode; FenceArea; CourtyardFlag; CourtyardArea; ArborPergolaFlag; SprinklersFlag; GolfCourseGreenFlag; TennisCourtFlag; SportsCourtFlag; ArenaFlag; WaterFeatureFlag; PondFlag; BoatLiftFlag

GrpEstimatedValue: EstimatedValue; EstimatedMinValue; EstimatedMaxValue; ConfidenceScore; ValuationDate

Profiler Component: Version 1.0.0.5009

Changes

None

Businesscoder Component: Version 1.0.0.5013

Changes

None

Generalized Cleanser Component: Version 1.0.0.5008

Changes

Fixed Bugs:

Invalid Expression error now fixed

Personator World Component: Version 1.0.0.5014

Changes

None

Build 7.4

Released November 2017

Compatibility Summary: 2005 SSIS Components are no longer being updated and supported. These components will now remain static. This release officially supports SQL Server 2016. Global Phone V3 was be depreciated in Q4. We have replaced it with a new Global Phone V4 WS which offers real-time phone check.

Contact Verification Component: Version: 1.0.1.5006; Address Object Build: 2961; Name Object Build: 2961; Phone Object Build: 2961; Email Object Build: 2961; Geocoder Object Build: 2961; MatchUp Object Build: 5015; Database Date: 10/15/2017

Changes

Fixed Bugs:

Name in CompanyName Field doesn't save output settings

Personator Component: Version: 1.0.0.5008

Changes

Fixed Bugs:

Move Confidence Removal

Smartmover Component: Version: 1.2.0.5005

Changes

None

Fuzzy Matching Component: Version 2.0.0.5004

Changes

None

Matchup Component: Version 2.2.0.5009

Changes

Fixed Bugs:

MatchCode Editor Label Character Limit
Mappings reset when global matchcode components changed

Global Verify Component: Version 2.1.0.5010; Global Address Object Build: 2921 (32bit), 2921 (64bit); Database Date: 10/15/2017

Changes

Fixed Bugs:

On Premise Unhandled Exception
Global Phone reporting incorrect statistics
Global Address ignoring configuration file for Batch Size and Thread Count

IP Locator Component: Version 1.0.0.5005

Changes

None

Property Component: Version 1.0.0.5005

Changes

None

Profiler Component: Version 1.0.0.5006

Changes

Fixed Bugs:

Word Value Frequencies output is not returned

Businesscoder Component: Version 1.0.0.5009

Changes

None

Generalized Cleanser Component: Version 1.0.0.5005

Changes

Fixed Bugs:

Configuration prevents changing of licenses

Personator World Component: Version 1.0.0.5008

Build 7.3

Released August 2017

Compatibility Summary: 2005 SSIS Components are no longer being updated and supported. These components will now remain static. This release officially supports SQL Server 2016. Global Phone V3 was be depreciated in Q4. We have replaced it with a new Global Phone V4 WS which offers real-time phone check.

Contact Verification Component: Version: 1.0.1.5003; Address Object Build: 2961; Name Object Build: 2961; Phone Object Build: 2961; Email Object Build: 2961; Geocoder Object Build: 2961; MatchUp Object Build: 3224; Database Date: 04/15/2017

Changes

None

Personator Component: Version: 1.0.0.5005

Changes

New Output Field:
MoveDate - Returns the date associated with move address

Smartmover Component: Version: 1.2.0.5003

Changes

New Output Fields:
BaseMelissaAddressKey - Returns a unique key associated with a building containing multiple suites/apartments
MelissaAddressKey - Returns a unique key associated with an address
StandardizedBaseMelissaAddressKey
StandardizedMelissaAddressKeyComponent

Fuzzy Matching Component: Version 2.0.0.5003

Changes

None

Matchup Component: Version 2.2.0.5003

Changes

None

Global Verify Component: Version 2.1.0.5004; Global Address Object Build: 2921 (32bit), 2921 (64bit); Database Date: 7/15/2017

Changes

Fixed Issue with On Premise license decryption

IP Locator Component: Version 1.0.0.5003

Changes

New response fields: ProxyType and ProxyDescription
New result code: IS03 – The IP address is a proxy

Property Component: Version 1.0.0.5003

Changes

None

Profiler Component: Version 1.0.0.6689

Changes

None

Businesscoder Component: Version 1.0.0.5007

Changes

New Output Filter

Contacts Output - Returns JSON Array: NameFirst, NameLast, Gender, Title, and Email of one or more contacts.
This will output to a separate filter with a primary key of your choosing. We recommend using a RecordID as the primary key, to link every contact returned to that unique ID.

New Output Fields

TotalContacts - Returns the number of employee contacts we have in our databases
EIN - The Employer Identification Number for the business

Generalized Cleanser Component: Version 1.0.0.5003

Changes

Regex builder crash

Build 7.2

Released May 2017

Compatibility Summary: 2005 SSIS Components are no longer being updated and supported. These components will now remain static. This release officially supports SQL Server 2016. Global Phone V3 was be depreciated in Q4. We have replaced it with a new Global Phone V4 WS which offers real-time phone check.

Contact Verification Component: Version: 1.0.1.2929; Address Object Build: 2961; Name Object Build: 2961; Phone Object Build: 2961; Email Object Build: 2961; Geocoder Object Build: 2961; MatchUp Object Build: 3224; Database Date: 04/15/2017

Changes

None

Personator Component: Version: 1.0.0.2929

Changes

None

Smartmover Component: Version: 1.2.0.2929

Changes

Fixed Bugs:

Component Crashes when you define Input Address for Country and try to click the box "Use Input Fields for Output" under Output columns

Fuzzy Matching Component: Version 2.0.0.2929

Changes

None

Matchup Component: Version 2.2.0.2929

Changes

Fixed Bugs:

Under Advanced Survivorship, all the expressions in Column and variables under Custom Expression can't be seen when opening the Advanced survivorship after the first time.
MatchUp editor closes after trying to create new matchcode
Create Matchcode dialog box broken
Misleading error message for license issue
Crash occurs when selecting a matchcode with no rules
Survivorship/Pass-Through does not save columns selected
Component closes out when double clicking on Options bar
Crashing if used in SQL Agent
Crash after selecting Match Code and filling in Field Mappings under Survivorship/Pass-Through Column when clicking the "Select All" box
Crash when create new match code with no data type

Global Verify Component: Version 2.1.0.2929; Global Address Object Build: 2921 (32bit), 2921 (64bit); Database Date: 4/15/2017

Changes

None

IP Locator Component: Version 1.0.0.2929

Changes

None

Property Component: Version 1.0.0.2929

Changes

None

Profiler Component: Version 1.0.0.2929

Changes

None

Businesscoder Component: Version 1.0.0.2929

Changes

None

Generalized Cleanser Component: Version 1.0.0.4474

Changes

Fixed Bugs:

Expression Syntax Error on Expression that Passes Check inside Expression Builder

Build 7.1

Released February 2017

Compatibility Summary: 2005 SSIS Components are no longer being updated and supported. These components will now remain static. This release officially supports SQL Server 2016. Global Phone V3 was be deprecated in Q4. We have replaced it with a new Global Phone V4 WS which offers real-time phone check.

Contact Verification Component: Version: 1.0.1.2928; Address Object Build: 2896; Name Object Build: 2896; Phone Object Build: 2896; Email Object Build: 2896; Geocoder Object Build: 2872; MatchUp Object Build: 2768; Database Date: 2/15/2017

Changes

Email - Time To Wait Option has been added
TimeToWait allows you to select how long (in seconds) that you would like our web service to wait on a single email before it times out. Select a smaller number if time is of essence, or longer if you would prefer more accurate results.
DaysSinceLastVerified -This option is deprecated.

Option Name	Parameter	Description
TimeToWait	`#[5-45]`	Default set to 25. Select how long the web service will wait before it times out on an email.

Personator Component: Version: 1.0.0.2928

Changes

Fixed mistype in window

SmartMover Component: Version: 1.2.0.2928

Changes

None

Fuzzy Matching Component: Version 2.0.0.2928

Changes

None

MatchUp Component: Version 2.2.0.2928

Changes

None

Global Verify Component: Version 2.1.0.2928; Global Address Object Build: 2771 (32bit), 2771 (64bit); Database Date: 2/15/2017

Changes

Gloabl Phone:

Global Phone now outputs Caller ID

Global Email:

Deprecated DaysSinceLastVerified option for Global Email

Email - TimeToWait Option has been added

TimeToWait allows you to select how long (in seconds) that you would like our web service to wait on a single email before it times out. Select a smaller number if time is of essence, or longer if you would prefer more accurate results.

Option Name	Parameter	Description
TimeToWait	`#[5-45]`	Default set to 25. Select how long the web service will wait before it times out on an email.

IP Locator Component: Version 1.0.0.2928

Changes

None

Property Component: Version 1.0.0.2928

Changes

None

Profiler Component: Version 1.0.0.2928

Changes

None

Business Coder Component: Version 1.0.0.2928

Changes

None

Generalized Cleanser Component: Version 1.0.0.2928

Changes

New Component

Build 6.4

Released November 2016

Compatibility Summary: 2005 SSIS Components are no longer being updated and supported. These components will now remain static. IPLocator Local will be deprecated in Q3. We will be replacing it with a new IPLocator WS.

Contact Verification Component: Version: 1.0.1.2880; Address Object Build: 2819; Name Object Build: 2819; Phone Object Build: 2819; Email Object Build: 2819; Geocoder Object Build: 2872; MatchUp Object Build: 2872; Database Date: 10/15/2016

Changes

None

Personator Component: Version: 1.0.0.2880

Changes

None

SmartMover Component: Version: 1.2.0.2880

Changes

None

Fuzzy Matching Component: Version 2.0.0.2880

Changes

None

MatchUp Component: Version 2.2.0.2880

Changes

None

Global Verify Component: Version 2.1.0.2880; Global Address Object Build: 2771 (32bit), 2771 (64bit); Database Date: 10/15/2016

Changes

Global Phone:

V4 is now released: https://globalphone.melissadata.net/v4/WEB/GlobalPhone

+ can now be inputted into DefaultCallingCode
PS20/PS21/PS22 result codes no longer show when there is a PE03 result code
Parentheses for + codes now parsed correctly, e.g (+1)4084161450
InternationalPhoneNumber is a combination of the country dialing code + phone number, added as a new field called InternationalPhoneNumber
Phone input range increased to 20 digits (meaning you can input up to 20 digits without returning a PE error; previously 16)
Latitude and Longitudes for numbers that are not geographically tied to an area (toll free numbers) are now empty strings instead of 0,0

Global Email:

Removed:

DaysSinceLastVerified (Deprecated)

New Advanced Logic deprecates this option.

Bug Fix:

Fixed a bug related to Domain Correction

General Improvements:

Improved Cache Queries
Improved Validation Speeds
Increased Thread Stability

IPLocator Component: Version 1.0.0.2880

Changes

IP Locator V2 Web Service and On Premise capabilities are now deprecated
IP Locator V4 is now released

More comprehensive set of global IP4 Addresses (covers 99.999 % of the internet)
Leverages a “living network” from mobile devices and billions of real-time data points
Additional appends such as ‘Connection Speed’ and ‘Connection Type’
Updated Weekly
In order to ensure no loss of data, all current data points in the legacy IP Locator V2 Web Service are also available in the IP Locator V4 Web Service

Property Component: Version 1.0.0.2880

Changes

None

Profiler Component: Version 1.0.0.2880

Changes

Bug Fixed - License Key is not updating when entered in advanced configuration

Business Coder Component: Version 1.0.0.2880

Changes

Bug Fixed - License Key is not updating when entered in advanced configuration

Build 6.3

Released August 2016

Compatibility Summary: 2005 SSIS Components are no longer being updated and supported. These components will now remain static. IPLocator Local will be deprecated in Q3. We will be replacing it with a new IPLocator WS.

Contact Verification Component: Version: 1.0.1.2826; Address Object Build: 2819; Name Object Build: 2819; Phone Object Build: 2819; Email Object Build: 2819; Geocoder Object Build: 2674; MatchUp Object Build: 2768; Database Date: 7/15/2016

Changes

None

Personator Component: Version: 1.0.0.2826

Changes

None

SmartMover Component: Version: 1.2.0.2826

Changes

None

Fuzzy Matching Component: Version: 2.0.0.2826

Changes

None

MatchUp Component: Version: 2.2.0.2826

Changes

None

Global Verify Component: Version: 2.1.0.2826; Global Address Object Build: 2771 (32bit), 2771 (64bit); Database Date: 07/15/2016

Changes

Global Email: Date Checked field has been added

IPLocator Component: Version: 1.0.0.2826

Changes

IP Locator V2 Web Service and On Premise capabilities are now deprecated
IP Locator V4 is now released

More comprehensive set of global IP4 Addresses (covers 99.999 % of the internet)
Leverages a “living network” from mobile devices and billions of real-time data points
Additional appends such as ‘Connection Speed’ and ‘Connection Type’
Updated Weekly
In order to ensure no loss of data, all current data points in the legacy IP Locator V2 Web Service are also available in the IP Locator V4 Web Service

Property Component: Version: 1.0.0.2826

Changes

None

Profiler Component: Version: 1.0.0.2826

Changes

None

Business Coder Component: Version: 1.0.0.2826

Changes

New Component

Build 6.2

Released May 2016

Contact Verification Component: Version: 1.0.1.2777; Address Object Build: 2777; Name Object Build: 2777; Phone Object Build: 2777; Email Object Build: 2777; Geocoder Object Build: 2674; MatchUp Object Build: 2768; IpLocator Object Build: 2615; Database Date: 4/15/2015

Changes

None
Various bug fixes.

Personator Component: Version: 1.0.0.2777

Changes

GrpCensus2 columns have been added

Column Name	Column Description
CensusKey	Contains the concatenated County FIPS, Census Tract and Census Block
CountySubDivisionCode	Contains the County Subdivision code
CountySubDivisionName	Contains the County Subdivision name
ElementarySchoolDistrictCode	Contains the Elementary School District Code
ElementarySchoolDistrictName	Contains the Elementary School District Name
SecondarySchoolDistrictCode	Contains the Secondary School District Code
SecondarySchoolDistrictName	Contains the Secondary School District Name
UnifiedSchoolDistrictCode	Contains the Unified School District Code
UnifiedSchoolDistrictName	Contains the Unified School District Name
StateDistrictUpper	Contains the Upper State District Code
StateDistrictLower	Contains the Lower State District Code

SmartMover Component: Version: 1.0.1.2777

Changes

None

Fuzzy Matching Component: Version 2.0.0.2777

Changes

None

MatchUp Component: Version 2.2.0.2777

Changes

Various bug fixes.

Global Verify Component: Version 2.0.0.2730; Global Address Object Build: 2620 (32bit), 2600 (64bit)

Changes

None

IP Locator Component: Version 1.0.0.2730

Changes

None

Property Component: Version 1.0.0.2730

Changes

None

Profiler Component: Version 1.0.0.2730

Changes

None

BusinessCoder Component: Version 1.0.0.2730

Changes

New Component

Build 6.1

Released February 2016

Contact Verification Component: Version: 1.0.1.2730; Address Object Build: 2710; Name Object Build: 2710; Phone Object Build: 2710; Email Object Build: 2710; Geocoder Object Build: 2674; MatchUp Object Build: 2721; IpLocator Object Build: 2615; Database Date: 1/15/2015

Changes

Email component now has a 'Perform WS Lookup' option for On-Premise processing. With this option enabled, the user can send their emails to the global email webservice for real time validation.
Express and Premium modes are now enabled for webservice processing or WS lookup.
Various bug fixes.

Personator Component: Version: 1.0.0.2730

Changes

Move Default Set to Strict

SmartMover Component: Version: 1.0.1.2730

Changes

None

Fuzzy Matching Component: Version 2.0.0.2730

Changes

None

MatchUp Component: Version 2.2.0.2730

Changes

Various bug fixes.

Global Verify Component

Version 2.0.0.2730

Global Address Object Build: 2620 (32bit), 2600 (64bit)

Changes

None

IP Locator Component: Version 1.0.0.2730

Changes

None

Property Component: Version 1.0.0.2730

Changes

None

Profiler Component: Version 1.0.0.2730

Changes

None

Build 5.4

Released November 2015: Patch Released January 2016 [Build 2683]

Contact Verification Component: Version: 1.0.1.2683; Address Object Build: 2575; Name Object Build: 2613; Phone Object Build: 2613; Email Object Build: 2554; Geocoder Object Build: 2670; MatchUp Object Build: 2628; IpLocator Object Build: 2615; Database Date: 10/15/2015

Changes

Community edition now requires a community edition License Key, rather than no License Key

Personator Component: Version: 1.0.0.2683

Changes

Fixed an issue with transaction size

SmartMover Component: Version: 1.0.1.2683

Changes

Transaction size setting locked to 100 records in accordance to USPS regulations

Fuzzy Matching Component: Version 2.0.0.2683

Changes

None

MatchUp Component: Version 2.2.0.2683

Changes

International Matchup capabilities now added to Matchup Component
Community edition now requires a community edition License Key, rather than no License Key
Fixed an issue where users would experience field mapping issues in a matchcode (address 4-8)
Fixed database expiration issue

Global Verify Component

Version 2.0.0.2683

Global Address Object Build: 2620 (32bit), 2600 (64bit)

Changes

Added new On-Premise component
New processing modes: Webservice, On-Premise, Hybrid. WS sends all records to webservice, on-premise sends all records to the local object, and hybrid sends specified records to webservice OR the local object.

IP Locator Component: Version 1.0.0.2683

Changes

None

Property Component: Version 1.0.0.2683

Changes

None

Profiler Component: Version 1.0.0.2683

Changes

Community edition now requires a community edition License Key, rather than no License Key

Build 5.3

Released August 2015

Contact Verification Component: Version: 1.0.1.2626; Address Object Build: 2613; Name Object Build: 2613; Phone Object Build: 2613; Email Object Build: 2554; Geocoder Object Build: 2615; MatchUp Object Build: 2564; IpLocator Object Build: 2554; Database Date: 7/15/2015

Changes

Added more result codes to the output result filter

Personator Component: Version: 1.0.0.2626

Changes

Fixed a problem where the "Verify" action was not being sent
Fixed a problem where the Personator window would crash under certain circumstances
Added more result codes to the output result filter

SmartMover Component: Version: 1.0.1.2626

Changes

Files with less than 100 records will not be processed as per USPS regulations

Fuzzy Matching Component: Version 2.0.0.2626

Changes

Fixed spelling error in output tab

MatchUp Component: Version 2.2.0.2626

Changes

Fixed an issue where matchcodes could not use (UK) data types
Fixed an issue where DT_Numeric data types could not have a precision value greater than scale value
Fixed an issue where the advanced survivorship would crash the component in certain circumstances
Fixed several spelling mistakes

Global Verify Component

Version 2.0.0.2626

Global Address Object Build: 2620 (32bit), 2600 (64bit)

Changes

Added new On-Premise component
With a proper License Key, users can now verify global data on their machine rather than web service
Fixed various issues with On-Premise mode

IP Locator Component: Version 1.0.0.2626

Changes

None

Property Component: Version 1.0.0.2626

Changes

None

Profiler Component: Version 1.0.0.2626

Changes

None

Build 5.2

Released May 2015

Contact Verification Component: Version: 1.0.1.2575; Address Object Build: 2554; Name Object Build: 2554; Phone Object Build: 2554; Email Object Build: 2554; Geocoder Object Build: 2554; MatchUp Object Build: 2554; IpLocator Object Build: 2554; Database Date: 4/15/2015

Changes

fixed "Decimal" option unselectable in "Default Lat/Long Column Type"

Personator Component: Version: 1.0.0.2575

Changes

Personator restriction fixes and GUI changes.
Move confidence option now has "Loose" and "Strict" options.

SmartMover Component: Version: 1.0.1.2575

Changes

None

Fuzzy Matching Component: Version 2.0.0.2575

Changes

None

MatchUp Component: Version 2.2.0.2575

Changes

fixed MatchCode Editor swap crash

Global Verify Component: Version 2.0.0.2575

Changes

Fixed a few German translations and spelling
German localization for GV.
Global Email interface changes.
Output filter ES23 description update

IP Locator Component: Version 1.0.0.2575

Changes

None

Property Component: Version 1.0.0.2575

Changes

None

Profiler Component: Version 1.0.0.2575

Changes

Added InferredColumnType column.
Fixed issue where users would get error if they didn’t specify any output fields on the passthrough/results pin.

Build 5.1

Released February 2015

Contact Verification Component: Version: 1.0.1.2503; Address Object Build: 2502; Name Object Build: 2502; Phone Object Build: 2502; Email Object Build: 2502; Geocoder Object Build: 2502; MatchUp Object Build: 2408; IpLocator Object Build: 2502; Database Date: 1/15/2015

Changes

Fixed behavior of ‘Output Filter’ tab’s Filter controls in some instances.

Personator Component: Version: 1.0.0.2499

Changes

Added Demographics fields.

SmartMover Component: Version: 1.0.1.2503

Changes

None

Fuzzy Matching Component: Version 2.0.0.2502

Changes

None

MatchUp Component: Version 2.2.0.2499

Changes

Fixed issue where slow machines would crash if user changed tabs quickly during GUI startup.

Global Verify Component: Version 2.0.0.2503

Changes

Dialog not saving changes in rare instances.
User is now allowed to pass Advanced Configuration test with only some activated web services.
‘Default Lat/Long Column Type’ would not display checkmark if the selection was ‘Decimal’

IP Locator Component: Version 1.0.0.2503

Changes

None

Property Component: Version 1.0.0.2499

Changes

None

Profiler Component: Version 1.0.0.2503

Changes

Fixed issue where users would get error if they didn’t specify any output fields on the passthrough/results pin.

Build 4.4

Released November 2014

Contact Verification Component: Version: 1.0.1.2449; Address Object Build: 2431; Name Object Build: 2431; Phone Object Build: 2431; Email Object Build: 2431; Geocoder Object Build: 2441; MatchUp Object Build: 2441; IpLocator Object Build: 2441; Database Date: 10/15/2014

Changes

None

Personator Component: Version: 1.0.0.2449

Changes

Fixed a problem where output filters were not being saved
Improved performance when saving the component

SmartMover Component: Version: 1.0.1.2449

Changes

Fixed a backwards compatibility issue
Fixed a problem where output filters were not being saved

Fuzzy Matching Component: Version 2.0.0.2449

Changes

None

MatchUp Component: Version 2.2.0.2449

Changes

None

Global Verify Component: Version 2.0.0.2449

Changes

Added new Name Tab and Functionalities
Added new Phone Tab and Functionalities
Added new Email Tab and Functionalities

IP Locator Component: Version 1.0.0.2449

Changes

None

Property Component: Version 1.0.0.2449

Changes

New Component

Build 4.3

Released August 2014

Contact Verification Component: Version: 1.0.1. 2419; Address Object Build: 2381; Name Object Build: 2381; Phone Object Build: 2381; Email Object Build: 2381; Geocoder Object Build: 2408; MatchUp Object Build: 2408; Database Date: 07/15/2014

Changes

Changed option "Peroform WS Lookup" for Email Check to default to false.
Fixed problem with Result Codes when switching from Community Edition to Full Version

Personator Component: Version: 1.0.0.2419

Changes

Fixed a problem where some options were disabled in certain conditions.
Pass-through data types now match exactly what is input.

SmartMover Component: Version: 1.0.1.2419

Changes

GUI modifications
Component now communicates with new v3 version of SmartMover web service.
Added Canadian Change of Address processing via Canadian SmartMover web service.

Fuzzy Matching Component: Version 2.0.0.2419

Changes

Added SSIS data type descriptions to ‘Options’ drop-down menu.

MatchUp Component: Version: 2.2.0.2419

Changes

Added SSIS data type descriptions to ‘Options’ drop-down menu.

IPLocator Component: Version: 2.2.0.2419

Changes

Initial Release

Build 4.2

Released May 2014

Compatibility Summary

The following DLLs are now being compiled in Visual Studio 2012:

Address Object
Name Object
Phone Object
Email Object
Geocoder Object
MatchUp Object

This requires the installation of the 2012 Visual C++ Redistributable which is included in the SSIS Installation.

Installer: The Setup will automatically install 2012 Visual C++ Redistributable (x86 and x64) for compatibility with VS 2012 Compiled DLLs.

Contact Verification Component: Version: 1.0.1. 2368; Address Object Build: 2362; Name Object Build: 2362; Phone Object Build: 2362; Email Object Build: 2362; Geocoder Object Build: 2362; MatchUp Object Build: 2362; Database Date: 04/15/2014

Changes

Added additional option in the configuration file for DisableAddressSwapping. This option can be set to true in order to permanently disable the swapping of AddressLine1 and AddressLine2.

Personator Component: Version: 1.0.0. 2368

Changes

Added ‘Freeform’ input address field option.
Set maximum output field size to 255 instead of 256 (particularly problematic for Excel).
Actions were sometimes unselected automatically.
Pass-through columns were not always passing through data.
Changed verification so that outputting just a result code is not an error.
Pass-through's ‘Select All’ button didn’t always work.
No default was selected for the Append options.

MatchUp Component: Version: 2.2.0. 2368

Changes

Fixed a problem with date-distance matchcodes; dates with trailing spaces weren’t properly parsed.
Fixed a problem with ‘Join with Spaces’ not properly working with an Intersection Lookup source.
Fixed a problem where editing survivorship output column size was not getting saved.
Survivorship mode ‘Average’ wasn’t working correctly for integers.

Global Verify Component: Version: 2.2.0. 2368

Changes

Added Delivery Lines Option in the GUI for outputting the complete Global Mailing address in AddressLines 1 - 8.

Build 4.1

Released February 2014

Contact Verification Component: Version: 1.0.1.2313; Address Object Build: 2288; Name Object Build: 2288; Phone Object Build: 2288; Email Object Build: 2288; Geocoder Object Build: 2312; MatchUp Object Build: 2137; Database Date: 01/15/2014

Changes

Added Congressional District output to MD Cloud mode processing.
Updated GUI Display to properly reflect Geocoding level of accuracy when MD Cloud processing.

Personator Component: Version: 1.0.0.2313

Changes

Fixed issues related to difficulties in the inputting of the License Key.
Fixed Pass-thru All/None button.

MatchUpComponent: Version: 2.2.0.2313

Changes

Added Survivorship processing option.
Expression evaluator didn't recognize fields delimited with square brackets.

Build 3.5

Released November 2013

Installer Changes

The following component is now included in the Data Quality Components for SSIS: Personator

Contact Verification Component: Version: 1.0.1.2280; Address Object Build: 2274; Name Object Build: 2274; Phone Object Build: 2274; Email Object Build: 2274; Geocoder Object Build: 2269; MatchUp Object Build: 2137; Database Date: 10/15/2013

Changes

Fixed rare cloud bug where if an SE01 error did not return 100 records, an incorrect error message was relayed to user.
Updated on-premise e-mail options to reflect new build (Fuzzy Lookup and Web Service Lookup options added).
Fixed a problem where Input Company did not have a [None] option.
Added SSIS variables: CASSFormProcessorName, CASSFormListName, CASSFormName, CASSFormCompany, CASSFormAddress, CASSFormCity,CASSFormState, CASSFormZip, SOAFormProcessorName, SOAFormAddress, SOAFormCity, SOAFormProvince, SOAFormPostalCode, SOAFormFileName
Added ability to standardize Company names

Personator Component: Version: 1.0.1.2280

Changes

Added New Personator Component

SmartMover Component: Version: 1.0.1.2280

Changes

Added Community Edition mode, users can demo UI but cannot process.

Global Verify Component: Version: 1.0.1.2280

Changes

Added Community Edition mode, users can demo UI but cannot process.

Build 08/2013

Released August 2013

Installer Changes

The DQC-web.exe Web Installer now installs a set of required data files:

mdAddr.dat
mdEmail.cfg
mdEmail.dat
mdName.cfg
mdName.dat
mdPhone.dat
mdPhone.idx
ZIPNPA.txt

Contact Verification Component: Version: 1.0.1.2233; Address Object Build: 2214; Name Object Build: 2214; Phone Object Build: 2214; Email Object Build: 2214; Geocoder Object Build: 2225; MatchUp Object Build: 2137; Database Date: 7/15/2013

Changes

Added the Community Edition for non-licensed users.
Added Company Standardization under the Name Tab
Added new properties to the output CASS Form

Smart Mover Component

Version: 1.0.1.2233

Fixed bug (first seen in SmartMover, but likely in all components), where on systems where a full BIDS install was not done, some of the .config settings were not getting loaded.

Build 05/2013

Released May 2013

Contact Verification Component: Version: 1.0.1.2182; Address Object Build: 2149; Name Object Build: 2149; Phone Object Build: 2149; Email Object Build: 2149; Geocoder Object Build: 2182; Database Date: 4/15/201

Changes

Added MatchUp Community and MatchUp Lite Editions
Fixed a bug where you couldn't select "Fixed Length Unicode" on the Default Column Types
Fixed bug, in command-line runs Lookup stream sometimes was not getting records populated (you'd just get null fields).
Fixed crash when processing with Lookup table and Golden Record.
Fixed GUI anomaly, previous changes to Field Mappings would be forgotten if you re-entered that tab from another tab.
Addresses that cannot be GeoCoded will now return a Latitude/Longitude of blank instead of zero (0).ed.
Old Email Data Files are no longer supported.

Deprecated

mdDomain.dat
mdEmail.ini
mdEmailConfig.ini

This release includes new data sets for Email and is not backwards compatible.

New Data Files

mdEmail.dat
mdEmail.cfg

It is required to update both the object and the data files for this update.

Build 02/2013

Released February 2013

Contact Verification Component: Version: 1.0.1.10; Address Object Build: 2085; Name Object Build: 2057; Phone Object Build: 2057; Email Object Build: 2057; Geocoder Object Build: 2134; Database Date: 1/15/2013

MatchUp Component: Version 2.1.0.2137
MatchUp Object Build: 2137

Changes

Added Golden Record capability to Options tab.
Fixed crash when working with very large data sets and limited disk space.
User may now specify where work files are stored in 'Advanced Configuration dialog.
Improved matching speed in some situations.

Build 09/2012

Released September 2012

Intersecting deduper: Re-Worked Intersecting Deduper for improved performance

New Match Code Editor Interface: Simplified and improved the MatchCode Editor

Added Fuzzy Matching Algorithms

The following algorithms were added for fuzzy matching compatibility:

N-Gram
Jaro
Jaro-Winkler
Longest Common Substring
Needleman-Wunsch
MD Keyboard
Smith-Waterman-Gotoh
Dice’s Coefficient
Jaccard Similarity
Overlap Coefficient
Double Metaphone

Added new Match Code Types

The following match code types were added to MatchUp:

Proximity
Numeric
Date

2012 Compatibility: The Data Quality Components for SSIS is now available and supported in SQL Server 2012

New Global Component: Global Component for validating and correcting international addresses is now released for SQL Server 2005, 2008 and 2012.

Notice: 2005 SSIS Components have been deprecated and are no longer fully supported.

Build 06/2012

Released June 2012

Compatibility Summary: Address: None. Object and Data file only update.; Name: None; Phone: None; Email: None

Installer: If the installer cannot recognize (or mis-recognizes) the version of SQL Server SSIS that you have installed, you can force it to install to a particular version with one of the command-line switches: /Force2005x32, /Force2005x64, /Force2008x32 or /Force2008x64. Only use one of these switches at one time. Often, the installer has recognition issues because a critical component of SQL Server may be missing (such as SSIS services). As a result, after forcing an install in this manner, you may have difficulties using the DQS components.

Contact Verification Component: Version: 1.0.1.9; Address Object Build: 1974; Name Object Build: 1974; Phone Object Build: 1974; Email Object Build: 1974; Geocoder Object Build: 1979; Database Date: 5/15/2012

Changes

Added 'Report result codes for empty input' option to 'Output Filter' tab.
User may now specify a proxy server on 'Advanced' dialog.
Fixed bug: sometimes the Canadian Geocoding option wasn't getting recognized.

SmartMover Component: Version: 1.0.1.6

Changes

User may now specify a proxy server on 'Advanced' dialog.

Fuzzy Matching Component: Version 2.0.0.10

Changes

Minor name change.

MatchUp Component: Version 2.0.0.6; MatchUp Object Build: 1985

Changes

Matchcode Editor is now fully integrated into component.
Fixed bug, combination result codes not reported in all setup configurations.
Fixed crash/hang in certain setup configurations involving passthrough fields.
User may now specify where work files are stored in 'Advanced Configuration dialog.
New matching data types: Geographic Proximity, Numeric Difference, Date Difference.
New fuzzy matching rules: N-Gram, Jaro Distance, Jaro-Winkler Distance, Longest Common Substring, Jaccard Index, Dice's Coefficient, Overlap Coefficient, Needleman-Wunsch, Smith-Waterman-Gotoh, MD Keyboard, Double Metaphone.
Improved matching accuracy in some situations.
Improved matching speed in some situations.
Eliminated certain matchcode requirements and restrictions that were previously required.
Added 'Record Suppresion' processing mode.
Added 'Record Intersection' processing mode.

@@ Line 52: / Line 52: @@
 :*Global Verify Name also offers new output fields.
 ::*'''Nickname''' - This is a string value of an identified nickname from an inputted full name.
-::A nickname is defined as an internal string surrounded by one of the nickname identifying characters [double quote], [single quote] or [parenthesis]. The identified nickname will be returned unstandardized with the identifier intact.
+:::A nickname is defined as an internal string surrounded by one of the nickname identifying characters [double quote], [single quote] or [parenthesis]. The identified nickname will be returned unstandardized with the identifier intact.
 ::*'''Professional Title''' - This is a string value of the professional title from an inputted full name.
-::Many countries within the European Union identify professional titles as a datatype preceding the first name but separate from a name prefix.
+:::Many countries within the European Union identify professional titles as a datatype preceding the first name but separate from a name prefix.
 ::*'''Nickname 2''' - This is a string value of an identified nickname from an inputted full name.
-::If the FullName input property contained multiple names, the nickname of the second name will be returned here.
+:::If the FullName input property contained multiple names, the nickname of the second name will be returned here.
 ::*'''Professional Title 2''' - This is a string value of the professional title from an inputted full name.
-::If the FullName input property contained multiple names, the professional title of the second name will be returned here.
+:::If the FullName input property contained multiple names, the professional title of the second name will be returned here.
 <p class="sectionhead">IPLocator Component</p>

Build History:SSIS:Data Quality Components: Difference between revisions

Revision as of 00:21, 3 May 2022

Build 12.2

Build 12.1

Build 11.4

Build 11.3

Build 11.2

Build 11.1

Build 10.4

Build 10.3

Build 10.2

Build 10.1

Build 9.4

Build 9.3

Build 9.2

Build 9.1

Build 8.4

Build 8.3

Build 8.2

Build 8.1

Build 7.4

Build 7.3

Build 7.2

Build 7.1

Build 6.4

Build 6.3

Build 6.2

Build 6.1

Build 5.4

Build 5.3

Build 5.2

Build 5.1

Build 4.4

Build 4.3

Build 4.2

Build 4.1

Build 3.5

Build 08/2013

Build 05/2013

Build 02/2013

Build 09/2012

Build 06/2012

Navigation menu

Search