SSIS:Subscribe: Difference between revisions

From Melissa Data Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
 
(5 intermediate revisions by the same user not shown)
Line 1: Line 1:
[[SSIS:Reference|← SSIS Reference]]
{{SSISIntroNav
 
|QuickStartCollapse=
{| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"
}}
! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"|'''SSIS Navigation'''
|-
| style="padding-right:220px;"|
|-
|[[SSIS:Introduction|Introduction]]
|-
|[[SSIS:System Requirements|System Requirements]]
|-
|
{| class="mw-collapsible" style="width:100%;"
|- align="left"
! style="color:black;"|Quick Start
|-
|[[SSIS:Installation|SSIS Installation]]
|-
|[[SSIS:Component Installation|Component Installation]]
|-
|[[SSIS:Subscribe|Subscribe]]
|-
|[[SSIS:Project Setup|Project Setup]]
|}
|}
 


{{CustomTOC}}
{{CustomTOC}}


==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 44: 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
|Email Correction||X||X
|-
|-
|rowspan="4" valign="top"|Phone Formatting
|Phone Formatting||X||X
|Phone Parsing/Formatting
|-
|-
|Phone Verification
|Address Verification||X||Does NOT Validate or Standardize
|-
|-
|Phone Enrichment
|Name Verification||X||
|-
|-
|Landline/ /VoIP Detection
|Email Verification||X||
|-
|-
|rowspan="3" valign="top"|Email Formatting
|Phone Verification||X||  
|Email Domain Verification/Email Formatting
|-
|-
|GeoCoding
|Geocoding||X||
|-
|-
|Output Filtering
|Genderizing||X||  
|}
 
 
====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
|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
|Record Limit||Unlimited||100,000
|-
|-
|Address, Company AND Last Name, First Name
|Available Tools
|-
|
|Address, Company OR Last Name
*Casing
|-
*Punctuation
|Address, Company OR Last Name, First Name
*Abbreviation
|-
*Expression
|United Kingdom Address
*Regular Expression Search Replace
|-
*Text Search and Replace
|Address, Fuzzy Last Name, Init First Name
|
|-
*Casing
|Address, Fuzzy Last Name, Nickname
*Punctuation
|-
*Abbreviation
|Name, Address, Proximity Match
*Expression
|-
*Limited Regular Expression Search Replace
|Custom Matchcodes
*Limited Text Search and Replace
|No Custom Matchcodes
|Custom Matchcodes
|-
|Record Limit
|50,000
|Unlimited
|-
|-
|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