SSIS:Subscribe: Difference between revisions

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