SSIS:Subscribe: Difference between revisions

From Melissa Data Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
 
(4 intermediate revisions by the same user not shown)
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.


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


===Limitations===
===Limitations===
The Community Edition of these components have limited functionality. They provide a few basic abilities for you to sample our products. 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
!colspan="3" style="background-color:rgb(220,220,220)"|Global Verify Component
|Full Name Parse
|-
|-
|Genderization
|Global Address Verification & Standardization||X||
|-
|-
|Company Standardization
|International Geocoding||X||
|-
|-
|Name Verification
!colspan="3" style="background-color:rgb(220,220,220)"|Contact Verification Component
|-
|-
|Suspicious Name/Vulgarity Detection
|Address Parsing||X||X
|-
|-
|rowspan="2" valign="top"|Address Parse
|Name Parsing||X||Last Name Only
|Address Verification/Correction/Enrichment
|-
|CASS Certification
|-
|rowspan="4" valign="top"|Phone Formatting
|Phone Parsing/Formatting
|-
|Phone Verification
|-
|Phone Enrichment
|-
|Landline/ /VoIP Detection
|-
|rowspan="3" valign="top"|Email Formatting
|Email Domain Verification/Email Formatting
|-
|GeoCoding
|-
|Output Filtering
|}
 
 
====Fuzzy Match====
{|class="alternate01" cellspacing="0"
!Community Edition
!style="border-right:0px;"|Standard Edition
|-
|Exact, N-Gram, and Levenshtein Only
|All Matching Algorithms
|-
|Two Match Field Limit
|Unlimited Match Fields
|}
 
 
====MatchUp Component====
{|class="alternate01" cellspacing="0"
!Edition
!Community Edition
!style="border-right:0px;"|Standard Edition
|-
|-
|rowspan="19"|Available Matchcodes
|Email Correction||X||X
|Address
|Address
|-
|-
|Address, Last
|Phone Formatting||X||X
|Address, Last
|-
|-
|Address, Last, First
|Address Verification||X||Does NOT Validate or Standardize
|Address, Last, First
|-
|-
|Address, APT
|Name Verification||X||  
|Address, APT
|-
|-
|Address, APT, Last
|Email Verification||X||  
|Address, APT, Last
|-
|-
|Address, APT, Last, First
|Phone Verification||X||  
|Address, APT, Last, First
|-
|-
|Address, Fuzzy Last
|Geocoding||X||  
|Address, Fuzzy Last
|-
|-
|International Address
|Genderizing||X||  
|International Address
|-
|-
|rowspan="11" valign="top"|General (40)
|License Required||X||  
|General (40)
|-
|-
|Address, Last Name, Gender
!colspan="3" style="background-color:rgb(220,220,220)"|MatchUp Component
|-
|-
|Address, Company
|Record Limit||Unlimited||50,000
|-
|-
|Address, Company AND Last Name
|Matchcodes*||19 Built-in||9 Built-in
|-
|-
|Address, Company AND Last Name, First Name
|Custom Matchcodes||X||
|-
|-
|Address, Company OR Last Name
|License Required||X||
|-
|-
|Address, Company OR Last Name, First Name
!colspan="3" style="background-color:rgb(220,220,220)"|Profiler Component
|-
|-
|United Kingdom Address
|Record Limit||Unlimited||50,000
|-
|-
|Address, Fuzzy Last Name, Init First Name
|Result Codes||X||
|-
|-
|Address, Fuzzy Last Name, Nickname
|License Required||X||
|-
|-
|Name, Address, Proximity Match
!colspan="3" style="background-color:rgb(220,220,220)"|Generalized Cleanser Component
|-
|-
|Custom Matchcodes
|Record Limit||Unlimited||100,000
|No Custom Matchcodes
|Custom Matchcodes
|-
|-
|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