|
|
| (93 intermediate revisions by 3 users not shown) |
| Line 1: |
Line 1: |
| | [[SSIS:Data Quality Components|← SSIS:Data Quality Components]] |
| {{CustomTOC}} | | {{CustomTOC}} |
| ==Build 3.5==
| | Please visit Melissa’s Release Notes page for the latest SSIS updates and Build History: https://releasenotes.melissa.com/enterprise/dqc-ssis/#build-history. |
| ''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.
| |
| | |
|
| |
|
| [[Category:Build History]] | | [[Category:Build History]] |
| [[Category:SSIS:Data Quality Components]] | | [[Category:SSIS:Data Quality Components]] |