SSIS:Subscribe: Difference between revisions

From Melissa Data Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
 
Line 6: Line 6:


==Subscriptions==
==Subscriptions==
You must have an account with Melissa Data in order to use the full features of Melissa Data's Data Quality Components for SSIS.
You must have an account with Melissa Data in order to use the full features of Melissa Data's Data Quality Components for SSIS.


Line 13: Line 12:


Once you are subscribed, your Customer Service Representative will give you a License Key needed to use the Data Quality Components for SSIS.
Once you are subscribed, your Customer Service Representative will give you a License Key needed to use the Data Quality Components for SSIS.


==Community Edition==
==Community Edition==
Line 21: Line 19:


You may subscribe to Melissa Data's DQC for SSIS through the Melissa Data website at www.MelissaData.com/newuser or by calling a Customer Service Representative at 1-800-MELISSA.
You may subscribe to Melissa Data's DQC for SSIS through the Melissa Data website at www.MelissaData.com/newuser or by calling a Customer Service Representative at 1-800-MELISSA.


Once you have your Community Edition License Key you can use the Community Edition of the Data Quality Suite Components.
Once you have your Community Edition License Key you can use the Community Edition of the Data Quality Suite Components.
Line 28: Line 25:
The Community Edition of these components have limited functionality. They provide a few basic abilities for you to sample our products, while some options may be greyed out. If you wish to unlock the full potential of our products, please subscribe.
The Community Edition of these components have limited functionality. They provide a few basic abilities for you to sample our products, while some options may be greyed out. If you wish to unlock the full potential of our products, please subscribe.


====Contact Verify====
{|class="alternate01" cellspacing="0"
{|class="alternate01" cellspacing="0"
!Community Edition
!Component
!style="border-right:0px;"|Standard Edition
!Full Edition
|-
!style="border-right:0px;"|Community Edition
|rowspan="5" valign="top"|Last Name Parse
|Full Name Parse
|-
|Genderization
|-
|Company Standardization
|-
|Name Verification
|-
|Suspicious Name/Vulgarity Detection
|-
|rowspan="2" valign="top"|Address Parse
|Address Verification/Correction/Enrichment
|-
|CASS Certification
|-
|rowspan="4" valign="top"|Phone Formatting
|Phone Parsing/Formatting
|-
|Phone Verification
|-
|-
|Phone Enrichment
!colspan="3" style="background-color:rgb(220,220,220)"|Global Verify Component
|-
|-
|Landline/ /VoIP Detection
|Global Address Verification & Standardization||X||
|-
|-
|rowspan="3" valign="top"|Email Formatting
|International Geocoding||X||  
|Email Domain Verification/Email Formatting
|-
|-
|GeoCoding
!colspan="3" style="background-color:rgb(220,220,220)"|Contact Verification Component
|-
|-
|Output Filtering
|Address Parsing||X||X
|}
 
 
====Fuzzy Match====
{|class="alternate01" cellspacing="0"
!Community Edition
!style="border-right:0px;"|Standard Edition
|-
|-
|Exact, N-Gram, and Levenshtein Only
|Name Parsing||X||Last Name Only
|All Matching Algorithms
|-
|-
|Two Match Field Limit
|Email Correction||X||X
|Unlimited Match Fields
|}
 
 
====MatchUp Component====
{|class="alternate01" cellspacing="0"
!Functionality
!Community Edition
!style="border-right:0px;"|Standard Edition
|-
|-
|rowspan="19"|Available Matchcodes
|Phone Formatting||X||X
|Address
|Address
|-
|-
|Address, Last
|Address Verification||X||Does NOT Validate or Standardize
|Address, Last
|-
|-
|Address, Last, First
|Name Verification||X||  
|Address, Last, First
|-
|-
|Address, APT
|Email Verification||X||  
|Address, APT
|-
|-
|Address, APT, Last
|Phone Verification||X||  
|Address, APT, Last
|-
|-
|Address, APT, Last, First
|Geocoding||X||  
|Address, APT, Last, First
|-
|-
|Address, Fuzzy Last
|Genderizing||X||  
|Address, Fuzzy Last
|-
|-
|International Address
|License Required||X||  
|International Address
|-
|-
|rowspan="11" valign="top"|General (40)
!colspan="3" style="background-color:rgb(220,220,220)"|MatchUp Component
|General (40)
|-
|-
|Address, Last Name, Gender
|Record Limit||Unlimited||50,000
|-
|-
|Address, Company
|Matchcodes*||19 Built-in||9 Built-in
|-
|-
|Address, Company AND Last Name
|Custom Matchcodes||X||
|-
|-
|Address, Company AND Last Name, First Name
|License Required||X||
|-
|-
|Address, Company OR Last Name
!colspan="3" style="background-color:rgb(220,220,220)"|Profiler Component
|-
|-
|Address, Company OR Last Name, First Name
|Record Limit||Unlimited||50,000
|-
|-
|United Kingdom Address
|Result Codes||X||
|-
|-
|Address, Fuzzy Last Name, Init First Name
|License Required||X||
|-
|-
|Address, Fuzzy Last Name, Nickname
!colspan="3" style="background-color:rgb(220,220,220)"|Generalized Cleanser Component
|-
|Name, Address, Proximity Match
|-
|Custom Matchcodes
|No Custom Matchcodes
|Custom Matchcodes
|-
|Record Limit
|50,000
|Unlimited
|-
|License Required
|No
|Yes
|}
 
 
====Profiler Component====
{|class="alternate01" cellspacing="0"
!Functionality
!Community Edition
!style="border-right:0px;"|Standard Edition
|-
|-
|Result Codes
|Record Limit||Unlimited||100,000
|No Result Codes
|Result Codes Outputted
|-
|-
|Record Limit
|Available Tools
|50,000
|
|Unlimited
*Casing
*Punctuation
*Abbreviation
*Expression
*Regular Expression Search Replace
*Text Search and Replace
|
*Casing
*Punctuation
*Abbreviation
*Expression
*Limited Regular Expression Search Replace
*Limited Text Search and Replace
|-
|-
|License Required
|License Required||X||
|No
|Yes
|}
|}




[[Category:SSIS]]
[[Category:SSIS]]

Latest revision as of 15:26, 6 September 2018

← SSIS:Data Quality Components

SSIS Navigation
Introduction
System Requirements
Quick Start
SSIS Installation
Subscribe



Subscriptions

You must have an account with Melissa Data in order to use the full features of Melissa Data's Data Quality Components for SSIS.

You may subscribe to Melissa Data's Data Quality Components (DQC) for SSIS through the Melissa Data website at https://www.melissa.com/data-integration/microsoft-sql-server or by calling a Customer Service Representative at 1-800-MELISSA.


Once you are subscribed, your Customer Service Representative will give you a License Key needed to use the Data Quality Components for SSIS.

Community Edition

Some of Melissa Data's Data Quality Suite Components have a Community Edition. This is a no-cost version of the component available to you for trying out the components.

To obtain a Community Edition License Key, contact a Customer Service Representative

You may subscribe to Melissa Data's DQC for SSIS through the Melissa Data website at www.MelissaData.com/newuser or by calling a Customer Service Representative at 1-800-MELISSA.

Once you have your Community Edition License Key you can use the Community Edition of the Data Quality Suite Components.

Limitations

The Community Edition of these components have limited functionality. They provide a few basic abilities for you to sample our products, while some options may be greyed out. If you wish to unlock the full potential of our products, please subscribe.

Component Full Edition Community Edition
Global Verify Component
Global Address Verification & Standardization X
International Geocoding X
Contact Verification Component
Address Parsing X X
Name Parsing X Last Name Only
Email Correction X X
Phone Formatting X X
Address Verification X Does NOT Validate or Standardize
Name Verification X
Email Verification X
Phone Verification X
Geocoding X
Genderizing X
License Required X
MatchUp Component
Record Limit Unlimited 50,000
Matchcodes* 19 Built-in 9 Built-in
Custom Matchcodes X
License Required X
Profiler Component
Record Limit Unlimited 50,000
Result Codes X
License Required X
Generalized Cleanser Component
Record Limit Unlimited 100,000
Available Tools
  • Casing
  • Punctuation
  • Abbreviation
  • Expression
  • Regular Expression Search Replace
  • Text Search and Replace
  • Casing
  • Punctuation
  • Abbreviation
  • Expression
  • Limited Regular Expression Search Replace
  • Limited Text Search and Replace
License Required X