SSIS:Data Quality Components: Difference between revisions

From Melissa Data Wiki
Jump to navigation Jump to search
← Older edit
No edit summary
No edit summary
 
(119 intermediate revisions by 3 users not shown)
Line 1: Line 1:
{{ProductInfoWidget
__NOTOC__
|ProductName=SSIS:DQC
{{ProductV2
|ReleaseDate=June 2012
|ProductImage=[[File:TILE_ENT_DataQualityComponentsforSSIS.png|link=]]
|CurrentBuild=
|ProductBody=
|SupportedPlatform=Microsoft SSIS
Melissa Data’s Data Quality Components for SSIS are a suite of custom Data Transformation components for Microsoft's SQL Server SSIS that encapsulate the six levels of complete Data Quality as defined by Gartner™.
|SupportedLanguage=
<br>[[File:Request-free-demo.png|link=https://www.melissa.com/request-demo?product=wiki+ssis]]
|BodyText=
|CurrentBody=
}}
<h3>Current Build</h3>
{{CustomTOC}}
*[https://releasenotes.melissa.com/enterprise/dqc-ssis/#build-history Build History]
 
<h3>Notices</h3>
Melissa Data’s Data Quality Components for SSIS are a suite of custom Data Transformation components for Microsoft's SQL Server SSIS that encapsulate the six levels of complete Data Quality as defined by Gartner™. High quality data is the basis for solid business decisions. Having an accurate view of your organization, your customers, and your business environment allows organizations to maximize profitability and reduce costly operational inefficiencies. Melissa Data's Data Quality Components for SSIS are the most affordable, full featured enterprise data quality tools to help IT professionals integrate increasingly complex enterprise data - in different formats, structures, and sources, and deliver a single view of critical information assets.
*[[SSIS:Advisory:SQL Server 2012 End of Support|Microsoft SQL Server 2012 End of Support – Melissa SSIS 2012 Platform Deprecation]]
 
*[[SSIS:Advisory:Global Address Object 32bit dll Deprecation|SSIS Global Verify Address On Premise Users – Global Address Object 32bit dll Deprecation]]
==Components==
<!--*[[SSIS:Advisory:2020 Census Data Update|Advisory: Contact Verify - Cloud Processing, Global Verify and Personator components 2020 Census Data Update November 15th 2021]]-->
<!--*[[SSIS:Advisory:DQC for SSIS & TLS 1.2|Advisory:DQC for SSIS & TLS 1.2]]-->
<!--*[[SSIS:Advisory|Global Verify Component - Global Email Update Advisory]]-->
*[[FAQ:SSIS:Known Issues|Known Issues]]
<!--*[[SSIS:System Requirements#What Versions of SQL Server/Visual Studio Is Your Components Supported in?|Regarding SQL Server 2017 Compatibility]]-->
<!--*[[SSIS:System Requirements#Regarding SQL Server 2019 Compatibility|Regarding SQL Server 2019 Compatibility]]-->
<h3>SSIS Advisories</h3>
*[[SSIS:Recent Advisories|Recent Advisories]]
|EssentialsBody=
<h3>Getting Started</h3>
*[[Media:DQT_ENT_SSIS_DQC_QSG.pdf|Quick Start Guide]]
<h3>Basics</h3>
*[[SSIS:Introduction|Introduction]]
*[[SSIS:System Requirements|System Requirements]]
*[[SSIS:Installation|Installation]]
*[[SSIS:Subscribe|Subscribe/Community Edition]]
*[[SSIS:Best Practices|SSIS Best Practices]]
*[[Data Coverage by Country|Data Coverage by Country]]
<h3>FAQ</h3>
*[[FAQ:SSIS:Common Issues|Common Issues]]
*[[FAQ:SSIS:2012 Platform Deprecation|Melissa’s SSIS 2012 Platform Deprecation FAQ]]
*[[FAQ:SSIS:Contact Verify Dedicated Cloud (Appliance Mode) Deprecation|Contact Verify Dedicated Cloud (Appliance Mode) Deprecation]]
*[[FAQ:SSIS:Data Quality Components|Data Quality Components for SSIS]]
*[[FAQ:SSIS:Data Type Conversions|Data Type Conversions]]
*[[FAQ:SSIS:Component Specific|Component Specific FAQ & Optimizations]]
*[[FAQ:SSIS:GeoCode Logging Advisory|GeoCode Logging Advisory]]
*[[FAQ:SSIS:Install Other Than C: Drive|SSIS Install Other Than C: Drive]]
*[[FAQ:SSIS:Update Public Key Token|SSIS How to Update Public Key Token]]
*[[FAQ:SSIS:Target Server Version Option|SSIS Setting Target Server Version Option]]
*[[FAQ:SSIS:Service Speed|SSIS Service Speed]]
<h3>Tutorials</h3>
*[[SSIS:Custom Output Filters|Custom Output Filters]]
*[https://vimeo.com/293592747 General Overview Video]
*[https://vimeo.com/293593269 Contact Verification Video]
*[https://vimeo.com/293593026 Fuzzy Matching Video]
|ReferenceBody=
<h3>Components</h3>
*[[SSIS:Business Coder|Business Coder]]
*[[SSIS:Contact Verify|Contact Verify]]
*[[SSIS:Contact Verify|Contact Verify]]
*[[SSIS:Fuzzy Match|Fuzzy Match]]
*[[SSIS:Fuzzy Match|Fuzzy Match]]
*[[SSIS:Generalized Cleanser|Generalized Cleanser]]
*[[SSIS:Global Verify|Global Verify]]
*[[SSIS:Global Verify|Global Verify]]
*[[SSIS:IP Locator|IP Locator]]
*[[SSIS:MatchUp|MatchUp]]
*[[SSIS:MatchUp|MatchUp]]
*[[SSIS:Personator|Personator]]
*[[SSIS:Personator World|Personator World]]
*[[SSIS:Property|Property]]
*[[SSIS:Profiler|Profiler]]
*[[SSIS:SmartMover|SmartMover]]
*[[SSIS:SmartMover|SmartMover]]
 
<h3>Whitepapers</h3>
==Support==
*[https://www.melissa.com/resources/whitepapers/global-data-integration Global Address Data Integration in SSIS]
*[[Best Practices]]
<h3>Result Codes</h3>
 
*[[Result Code Details#SSIS Data Quality Components|SSIS DQC Result Codes]]
===FAQ===
}}
*[[FAQ:Data Quality Components for SSIS|Data Quality Components for SSIS]]
 
===Results Codes===
*[[Address Status Codes]]
*[[Address Error Codes]]
*[[Address Change Codes]]
*[[Email Results Codes]]
*[[GeoCoder Results Codes]]
*[[Name Results Codes]]
*[[Phone Results Codes]]
 
==Tutorials==
 
===Videos===
*[http://www.melissadata.com/multimedia/ssis-components/general-overview.wmv Overview]
*[http://www.melissadata.com/multimedia/ssis-components/contact-verification-fundamentals.wmv Contact Verify]
*[http://www.melissadata.com/multimedia/ssis-components/fuzzy-matching-fundamentals.wmv Fuzzy Matching]
 
<!--==Downloads==-->
===Documentation===
*[[Media:DQT_ENT_DQC_QSG.pdf|Data Quality Components for SSIS Quick Start Guide]]
 
<!--===Sample Code===-->
==Current Build==
''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.
 
===Build History===
*[[Build History:Data Quality Component for SSIS|Build History]]




[[Category:Enterprise Solutions]]
[[Category:Enterprise Solutions]]
[[Category:SSIS:Data Quality Components]]
[[Category:SSIS:Data Quality Components]]

Latest revision as of 17:07, 8 November 2024

Melissa Data’s Data Quality Components for SSIS are a suite of custom Data Transformation components for Microsoft's SQL Server SSIS that encapsulate the six levels of complete Data Quality as defined by Gartner™.
Retrieved from "http://wiki.melissadata.com/index.php?title=SSIS:Data_Quality_Components&oldid=20226"