Skip to content

Data Quality Components for SSIS

Important Announcements

None

General Information

Release Frequency: Quarterly

Release Date: Monday closest to the 7th of the month.

Next Release Date: May 06, 2024

Build History

2024.Q1

Released on: February 05, 2024

Component Version
BusinessCoder 1.0.0.5089
Contact Verification 1.0.1.5102
Fuzzy Matching 2.0.0.5033
Generalized Cleanser 1.0.1.5037
Global Verify 2.1.0.5203
IP Locator 1.0.0.5047
MatchUp 2.2.0.5054
Personator 1.0.0.5121
Personator World 1.0.0.5059
Profiler 1.0.0.5036
Property 1.0.0.5073
SmartMover 1.2.0.5074

Added

  • None

Changed

  • None

Deprecated

  • None

Removed

  • None

Fixed

  • Minor bug fixes

Security

  • None

2023.Q4

Released on: November 06, 2023

Component Version
BusinessCoder 1.0.0.5089
Contact Verification 1.0.1.5102
Fuzzy Matching 2.0.0.5033
Generalized Cleanser 1.0.1.5037
Global Verify 2.1.0.5203
IP Locator 1.0.0.5047
MatchUp 2.2.0.5052
Personator 1.0.0.5121
Personator World 1.0.0.5059
Profiler 1.0.0.5036
Property 1.0.0.5073
SmartMover 1.2.0.5074

Added

  • New Address Status (AS) result code filters for Personator, SmartMover, BusinessCoder, ContactVerify, and GlobalVerify (US only).
  • New Input/Output Melissa Identity Key (MIK) field for Personator

Changed

  • None

Deprecated

  • None

Removed

  • None

Fixed

  • None

Security

  • None

2023.Q3

Released on: August 07, 2023

Component Version
BusinessCoder 1.0.0.5081
Contact Verification 1.0.1.5096
Fuzzy Matching 2.0.0.5033
Generalized Cleanser 1.0.1.5037
Global Verify 2.1.0.5196
IP Locator 1.0.0.5047
MatchUp 2.2.0.5052
Personator 1.0.0.5114
Personator World 1.0.0.5059
Profiler 1.0.0.5036
Property 1.0.0.5073
SmartMover 1.2.0.5071

Added

  • None

Changed

  • None

Deprecated

  • None

Removed

  • None

Fixed

  • None

Security

  • None

2023.Q2

Released on: June 08, 2023

Component Version
BusinessCoder 1.0.0.5081
Contact Verification 1.0.1.5096
Fuzzy Matching 2.0.0.5033
Generalized Cleanser 1.0.1.5037
Global Verify 2.1.0.5196
IP Locator 1.0.0.5047
MatchUp 2.2.0.5052
Personator 1.0.0.5114
Personator World 1.0.0.5059
Profiler 1.0.0.5036
Property 1.0.0.5073
SmartMover 1.2.0.5071

Added

  • SSIS 2022 is now available!
    • Utilize Melissa's powerful Data Quality components with Microsoft Visual Studio and SQL Server 2022!
    • See Melissa's SSIS Wiki page for SSIS 2022 System Requirements

Changed

Deprecated

Removed

  • None

Fixed

  • A bug fix has been made that addresses the issue of the BusinessCoder component not returning all of the records processed to the destination component.

Security

  • None

Released on: May 08, 2023

Component Version
BusinessCoder 1.0.0.5076
Contact Verification 1.0.1.5096
Fuzzy Matching 2.0.0.5033
Generalized Cleanser 1.0.1.5037
Global Verify 2.1.0.5196
IP Locator 1.0.0.5047
MatchUp 2.2.0.5052
Personator 1.0.0.5114
Personator World 1.0.0.5059
Profiler 1.0.0.5036
Property 1.0.0.5073
SmartMover 1.2.0.5071

Added

  • SSIS 2022 is now available!
    • Utilize Melissa's powerful Data Quality components with Microsoft Visual Studio and SQL Server 2022!
    • See Melissa's SSIS Wiki page for SSIS 2022 System Requirements

Changed

Deprecated

Removed

  • None

Fixed

  • None

Security

  • None

2023.Q1

Released on: February 06, 2023

Component Version
BusinessCoder 1.0.0.5069
Contact Verification 1.0.1.5082
Fuzzy Matching 2.0.0.5028
Generalized Cleanser 1.0.0.5033
Global Verify 2.1.0.5184
IP Locator 1.0.0.5042
MatchUp 2.2.0.5047
Personator 1.0.0.5109
Personator World 1.0.0.5018
Profiler 1.0.0.5031
Property 1.0.0.5069
SmartMover 1.2.0.5066

Added

  • Personator Component - Decennial Census Key Options Added
    • Set the preferred Census information returned, whether the latest version or the decennial version
      • 2020 - Return the 2020 static decennial census database released
      • 2010 - Return the 2010 static decennial census database released
      • Off - Default. Return the latest Census information available

Changed

  • None

Deprecated

  • None

Removed

  • None

Fixed

  • None

Security

  • None

2022.Q4

Released on: November 07, 2022

Component Version
BusinessCoder 1.0.0.5069
Contact Verification 1.0.1.5082
Fuzzy Matching 2.0.0.5028
Generalized Cleanser 1.0.0.5033
Global Verify 2.1.0.5184
IP Locator 1.0.0.5042
MatchUp 2.2.0.5047
Personator 1.0.0.5106
Personator World 1.0.0.5018
Profiler 1.0.0.5031
Property 1.0.0.5069
SmartMover 1.2.0.5066

Added

  • SmartMover Component

  • Glboal Verify Component

    • Global Verify Email offers 3 new output fields.
      • DomainAuthenticationStatus: Returns security protocols used on the receiving mail server
      • DomainTypeIndicator: Predicts if email belongs to a personal or business/organization email by analyzing the domain
      • BreachCount: Returns the known number of breaches that this email account has been involved in

Changed

  • None

Deprecated

  • SSIS Global Verify Address On Premise Users – Global Address Object 32bit dll Deprecation - April 24th, 2023

    The Global Address Object 32bit mdGlobalAddr.dll file will be deprecated on April 24th, 2023. SSIS Global Verify Address On Premise users will be directly affected and will not be able to continue using SSIS Global Verify Address On Premise option. The reason for deprecating the 32bit mdGlobalAddr.dll is due to issues encountered with backwards compatibility. As Visual Studio is a 32bit program and utilizes the 32bit directory during processing. The 32bit mdGlobalAddr.dll deprecation will directly affect functionality for SSIS Global Verify Address On Premise users. SSIS Global Verify Cloud users will not be affected by this change. For more information please visit Melissa's SSIS Wiki page

  • Microsoft SQL Server 2012 End of Support – Melissa SSIS 2012 Platform Deprecation - July 24th, 2023

    As of July 12th, 2022, Microsoft has ended support for its SQL Server 2012 platform. This change will also end Melissa’s support for its SSIS 2012 platform. Beginning July 24th, 2023, Melissa will officially end support for the SSIS 2012 platform, which consists of Visual Studio 2010 and SQL Server 2012. We understand that performing a migration to another supported platform is a significant task. However, to maintain security standards and with the lack of support from Microsoft for SQL Server 2012, we believe it is in our client’s best interest to deprecate Melissa’s SSIS 2012 platform. For more information please visit Melissa's SSIS Wiki page

Removed

  • None

Fixed

  • None

Security

  • None

2022.Q3

Released on: August 08, 2022

Component Version
BusinessCoder 1.0.0.5069
Contact Verification 1.0.1.5082
Fuzzy Matching 2.0.0.5028
Generalized Cleanser 1.0.0.5033
Global Verify 2.1.0.5178
IP Locator 1.0.0.5042
MatchUp 2.2.0.5047
Personator 1.0.0.5106
Personator World 1.0.0.5018
Profiler 1.0.0.5031
Property 1.0.0.5069
SmartMover 1.2.0.5054

Added

  • None

Changed

  • None

Deprecated

  • None

Removed

  • None

Fixed

  • Personator Component
    • Fixed issue in Personator. Ethnic Code and Ethnic Group fields are now returning values.

Security

  • None

2022.Q2

Released on: April 15, 2022

Component Version
BusinessCoder 1.0.0.5062
Contact Verification 1.0.1.5082
Fuzzy Matching 2.0.0.5028
Generalized Cleanser 1.0.0.5033
Global Verify 2.1.0.5178
IP Locator 1.0.0.5042
MatchUp 2.2.0.5047
Personator 1.0.0.5103
Personator World 1.0.0.5018
Profiler 1.0.0.5031
Property 1.0.0.5069
SmartMover 1.2.0.5054

Added

  • Global Verify Component
    • 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.

Changed

  • None

Deprecated

  • None

Removed

  • None

Fixed

  • None

Security

  • None

2022.Q1

Released on: January 26, 2022

Component Version
BusinessCoder 1.0.0.5056
Contact Verification 1.0.1.5079
Fuzzy Matching 2.0.0.5028
Generalized Cleanser 1.0.0.5033
Global Verify 2.1.0.5169
IP Locator 1.0.0.5038
MatchUp 2.2.0.5047
Personator 1.0.0.5094
Personator World 1.0.0.5018
Profiler 1.0.0.5031
Property 1.0.0.5069
SmartMover 1.2.0.5054

Added

  • None

Changed

  • None

Deprecated

  • None

Removed

  • None

Fixed

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

Security

  • In case of vulnerabilities

2021.Q4

Released on: October 29, 2021

Component Version
BusinessCoder 1.0.0.5056
Contact Verification 1.0.1.5075
Fuzzy Matching 2.0.0.5028
Generalized Cleanser 1.0.0.5033
Global Verify 2.1.0.5169
IP Locator 1.0.0.5038
MatchUp 2.2.0.5047
Personator 1.0.0.5094
Personator World 1.0.0.5018
Profiler 1.0.0.5031
Property 1.0.0.5069
SmartMover 1.2.0.5054

The BusinessCoder, Personator and Global Verify (Global Name and Global Address) components have been converted from SOAP to POST endpoints. Contact Verify Cloud Processing and SmartMover will convert to POST at a later date.

This also includes Melissa Token Server endpoints for BusinessCoder, Personator and Contact Verify web service components.

Added

  • None

Changed

  • BussinessCoder Component

  • Contact Verification Component

    • 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: http://creditservice.melissadata.net/v3/JSON/service.svc

  • Global Verify Component

  • Personator Component

    • 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.

Deprecated

  • None

Removed

  • None

Fixed

  • None

Security

  • None

2021.Q3

Released on: August 13, 2021

Component Version
BusinessCoder 1.0.0.5052
Contact Verification 1.0.1.5072
Fuzzy Matching 2.0.0.5028
Generalized Cleanser 1.0.0.5033
Global Verify 2.1.0.5156
IP Locator 1.0.0.5038
MatchUp 2.2.0.5047
Personator 1.0.0.5081
Personator World 1.0.0.5018
Profiler 1.0.0.5031
Property 1.0.0.5069
SmartMover 1.2.0.5054

Added

  • None

Changed

  • Contact Verification Component

    • The Congress.dbf has been replaced with the Congress.csv file.
  • MatchUp Component

    • 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.
  • Personator Component

    • 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.

Deprecated

  • None

Removed

  • None

Fixed

  • None

Security

  • None

2021.Q2

Released on: May 12, 2021

Component Version
BusinessCoder 1.0.0.5052
Contact Verification 1.0.1.5068
Fuzzy Matching 2.0.0.5028
Generalized Cleanser 1.0.0.5033
Global Verify 2.1.0.5154
IP Locator 1.0.0.5038
MatchUp 2.2.0.5047
Personator 1.0.0.5076
Personator World 1.0.0.5018
Profiler 1.0.0.5031
Property 1.0.0.5069
SmartMover 1.2.0.5054

Added

  • None

Changed

  • None

Deprecated

  • None

Removed

  • None

Fixed

  • None

Security

  • None

2021.Q1

Released on: February 18, 2021

Component Version
BusinessCoder 1.0.0.5052
Contact Verification 1.0.1.5065
Fuzzy Matching 2.0.0.5028
Generalized Cleanser 1.0.0.5033
Global Verify 2.1.0.5154
IP Locator 1.0.0.5038
MatchUp 2.2.0.5047
Personator 1.0.0.5076
Personator World 1.0.0.5018
Profiler 1.0.0.5031
Property 1.0.0.5069
SmartMover 1.2.0.5054

Added

  • None

Changed

  • Personator Component
    • The Melissa Address Key (MAK) is now available as input for processing.
  • SmartMover Component
    • 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.

Deprecated

  • None

Removed

  • None

Fixed

  • IPLocator Component
    • The AbortOnFailure behavior has been fixed.
  • SmartMover Component
    • Fixed COA report time out.

Security

  • None

2020.Q4

Released on: November 23, 2020

Component Version
BusinessCoder 1.0.0.5052
Contact Verification 1.0.1.5065
Fuzzy Matching 2.0.0.5028
Generalized Cleanser 1.0.0.5033
Global Verify 2.1.0.5154
IP Locator 1.0.0.5035
MatchUp 2.2.0.5047
Personator 1.0.0.5073
Personator World 1.0.0.5018
Profiler 1.0.0.5031
Property 1.0.0.5069
SmartMover 1.2.0.5040

Added

  • Global Verify Component

    • 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
      
      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.

    • 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.
    • 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, and PT 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.

        • 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.

        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.

        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 - Core-Based Statistical Areas (CBSA) outputs. These values are assigned by the US Census.

        • 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"
        • DV01 - Valid domain
        • DE03 - Invalid domain
      • The following Global Verify Phone service Result Codes have been removed

        • 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:

        • PS07 – Cellphone
        • PS08 – Landline Activity

Changed

  • Personator Component
    • The Melissa Address Key (MAK) is now available as input for processing.
  • Personator World Component
    • Personator World Email TimeToWait option has been modified to 5-45s.

Deprecated

  • None

Removed

  • None

Fixed

  • None

Security

  • None

2020.Q3

Released on: August 20, 2020

Component Version
BusinessCoder 1.0.0.5049
Contact Verification 1.0.1.5062
Fuzzy Matching 2.0.0.5028
Generalized Cleanser 1.0.0.5033
Global Verify 2.1.0.5112
IP Locator 1.0.0.5035
MatchUp 2.2.0.5047
Personator 1.0.0.5067
Personator World 1.0.0.5018
Profiler 1.0.0.5031
Property 1.0.0.5069
SmartMover 1.2.0.5037

Added

  • None

Changed

  • Global Verify Component
    • 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.

Deprecated

  • None

Removed

  • None

Fixed

  • None

Security

  • None

2020.Q2

Released on: June 01, 2020

Component Version
BusinessCoder 1.0.0.5043
Contact Verification 1.0.1.5048
Fuzzy Matching 2.0.0.5025
Generalized Cleanser 1.0.0.5030
Global Verify 2.1.0.5102
IP Locator 1.0.0.5029
MatchUp 2.2.0.5043
Personator 1.0.0.5061
Personator World 1.0.0.5018
Profiler 1.0.0.5028
Property 1.0.0.5061
SmartMover 1.2.0.5031

Added

  • None

Changed

  • Contact Verification Component
    • 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.
  • Global Verify Component
    • 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.

Deprecated

  • None

Removed

  • None

Fixed

  • None

Security

  • None

2020.Q1

Released on: February 28, 2020

Component Version
BusinessCoder 1.0.0.5032
Contact Verification 1.0.1.5043
Fuzzy Matching 2.0.0.5017
Generalized Cleanser 1.0.0.5022
Global Verify 2.1.0.5063
IP Locator 1.0.0.5025
MatchUp 2.2.0.5040
Personator 1.0.0.5055
Personator World 1.0.0.5018
Profiler 1.0.0.5024
Property 1.0.0.5057
SmartMover 1.2.0.5027

Added

  • None

Changed

  • Contact Verification Component
    • Contact Verify Email has been reverted to include the mdEmail.dat file instead of the mdEmail.db3 file.

Deprecated

  • None

Removed

  • None

Fixed

  • Contact Verification Component
    • Fixed bug with result code GW05 returning when using Contact Verify Email

Security

  • None

2019.Q4

Released on: November 26, 2019

Component Version
BusinessCoder 1.0.0.5032
Contact Verification 1.0.1.5030
Fuzzy Matching 2.0.0.5017
Generalized Cleanser 1.0.0.5022
Global Verify 2.1.0.5063
IP Locator 1.0.0.5025
MatchUp 2.2.0.5040
Personator 1.0.0.5055
Personator World 1.0.0.5018
Profiler 1.0.0.5024
Property 1.0.0.5057
SmartMover 1.2.0.5027

Added

  • Personator World Component
    • 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.
    • PS18 Do Not Call The phone number was found in Melissa's proprietary Do Not Call list.
  • Global Verify Component
    • New Result Code added to Global Verify Phone. The PS18 Result Code will inform if the phone number is on Melissa's Do Not Call list.
    • PS18 Do Not Call The phone number was found in Melissa's proprietary Do Not Call list.

Changed

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

Deprecated

  • None

Removed

  • None

Fixed

  • None

Security

  • None

2019.Q3

Released on: September 11, 2019

Component Version
BusinessCoder 1.0.0.5032
Contact Verification 1.0.1.5030
Fuzzy Matching 2.0.0.5016
Generalized Cleanser 1.0.0.5022
Global Verify 2.1.0.5049
IP Locator 1.0.0.5024
MatchUp 2.2.0.5040
Personator 1.0.0.5052
Personator World 1.0.0.5018
Profiler 1.0.0.5024
Property 1.0.0.5057
SmartMover 1.2.0.5027

Added

  • Property Component

    • New Output Field Available:

      AssociatedParcels - Returns parcel information that matched the users input. AssociatedParcels 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, AssociatedParcels will provide the list of matching parcels.

  • Personator Component

    • Added Demographics CreditCardUser to output
    • CreditCardUser - Returns whether the user has a credit card or not.

Changed

  • None

Deprecated

  • None

Removed

  • None

Fixed

  • None

Security

  • None

2019.Q2

Released on: June 04, 2019

Component Version
BusinessCoder 1.0.0.5032
Contact Verification 1.0.1.5030
Fuzzy Matching 2.0.0.5016
Generalized Cleanser 1.0.0.5022
Global Verify 2.1.0.5049
IP Locator 1.0.0.5024
MatchUp 2.2.0.5040
Personator 1.0.0.5050
Personator World 1.0.0.5018
Profiler 1.0.0.5024
Property 1.0.0.5053
SmartMover 1.2.0.5027

Added

  • Global Verify Component
    • 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.

Changed

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

Deprecated

  • None

Removed

  • None

Fixed

  • None

Security

  • None

2019.Q1

Released on: March 01, 2019

Component Version
BusinessCoder 1.0.0.5031
Contact Verification 1.0.1.5029
Fuzzy Matching 2.0.0.5016
Generalized Cleanser 1.0.0.5022
Global Verify 2.1.0.5042
IP Locator 1.0.0.5024
MatchUp 2.2.0.5040
Personator 1.0.0.5049
Personator World 1.0.0.5018
Profiler 1.0.0.5024
Property 1.0.0.5051
SmartMover 1.2.0.5027

Added

  • None

Changed

  • BussinessCoder Component
    • Record ID output column length has been extended.
  • MatchUp Component
    • Component is now appending environmental variable license string.
  • Personator Component
    • License string is now appended to Personator component when license is entered in the installer.
    • Address House Number output column length has been extended.
  • Contact Verification Component
    • Custom Expression Filter and Pre-built filter is now accessible when switching processing modes.

Deprecated

  • None

Removed

  • None

Fixed

  • None

Security

  • None

2018.Q4

Released on: December 05, 2018

Component Version
BusinessCoder 1.0.0.5027
Contact Verification 1.0.1.5023
Fuzzy Matching 2.0.0.5014
Generalized Cleanser 1.0.0.5018
Global Verify 2.1.0.5038
IP Locator 1.0.0.5020
MatchUp 2.2.0.5038
Personator 1.0.0.5040
Personator World 1.0.0.5018
Profiler 1.0.0.5019
Property 1.0.0.5047
SmartMover 1.2.0.5023

Added

  • BussinessCoder Component
    • New Credit Subscription Available - BusinessCoder now accepts developer credit licenses.
  • Property Component
    • New Credit Subscription Available - Property now accepts developer credit licenses.
  • IP Locator Component
    • New Credit Subscription Available - IPLocator now accepts developer credit licenses.
  • Global Verify Component
    • New Credit Subscription Available - Global Verify now accepts developer credit licenses.
  • Personator Component
    • 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

Changed

  • MatchUp Component

    • 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
  • Contact Verification Component

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

Deprecated

  • None

Removed

  • None

Fixed

  • None

Security

  • None

2018.Q3

Released on: August 13, 2018

Component Version
BusinessCoder 1.0.0.5023
Contact Verification 1.0.1.5022
Fuzzy Matching 2.0.0.5014
Generalized Cleanser 1.0.0.5018
Global Verify 2.1.0.5028
IP Locator 1.0.0.5016
MatchUp 2.2.0.5029
Personator 1.0.0.5026
Personator World 1.0.0.5018
Profiler 1.0.0.5019
Property 1.0.0.5038
SmartMover 1.2.0.5023

Added

  • Personator Component

    • 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 Component

    • New Dynamic Variable Available - SmartMover has included JobID as a dynamic variable

Changed

  • Contact Verification Component
    • When Processing Mode is set to Melissa Data Cloud, Contact Verify exludes Melissa Address Key and Melissa Address Key Base output fields.

Deprecated

  • None

Removed

  • None

Fixed

  • Global Verify Component
    • Fixed Sub Administrative Area data for Australia not being returned.

Security

  • None

2018.Q2

Released on: June 01, 2018

Component Version
BusinessCoder 1.0.0.5021
Contact Verification 1.0.1.5018
Fuzzy Matching 2.0.0.5012
Generalized Cleanser 1.0.0.5016
Global Verify 2.1.0.5023
IP Locator 1.0.0.5014
MatchUp 2.2.0.5024
Personator 1.0.0.5023
Personator World 1.0.0.5021
Profiler 1.0.0.5017
Property 1.0.0.5036
SmartMover 1.2.0.5019

Added

  • Property Component
    • The following output fields have been added
      • Shape - Well Known Text - Returns parcel shape information
  • SmartMover Component
    • 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.

Changed

  • None

Deprecated

  • None

Removed

  • None

Fixed

  • Property Component
    • 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

Security

  • None

2018.Q1

Released on: March 08, 2018

Component Version
BusinessCoder 1.0.0.5011
Contact Verification 1.0.1.5009
Fuzzy Matching 2.0.0.5006
Generalized Cleanser 1.0.0.5006
Global Verify 2.1.0.5014
IP Locator 1.0.0.5007
MatchUp 2.2.0.5013
Personator 1.0.0.5013
Personator World 1.0.0.5014
Profiler 1.0.0.5007
Property 1.0.0.5024
SmartMover 1.2.0.5008

Added

  • Contact Verification Component

    • 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

    • 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

    • Added MoveTypeCode to output column
      • MoveTypeCode - Type of move (individual or business)
  • Global Verify Compoent

    • 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.
  • Property Component

    • 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

Changed

  • None

Deprecated

  • None

Removed

  • Personator Component
    • Move Confidence Removal

Fixed

  • MatchUp Component

    • Fixed Bugs - Mappings reset when global matchcode components changed
  • Generalized Cleanser Component

    • Fixed Bugs - Invalid Expression error now fixed

Security

  • None

Past Important Announcements