SSIS:Subscribe
← SSIS:Data Quality Components
| SSIS Navigation | |||
|---|---|---|---|
| Introduction | |||
| System Requirements | |||
|
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 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 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. If you wish to unlock the full potential of our products, please subscribe.
Contact Verify
| Community Edition | Standard Edition |
|---|---|
| Last Name Parse | Full Name Parse |
| Genderization | |
| Company Standardization | |
| Name Verification | |
| Suspicious Name/Vulgarity Detection | |
| Address Parse | Address Verification/Correction/Enrichment |
| CASS Certification | |
| Phone Formatting | Phone Parsing/Formatting |
| Phone Verification | |
| Phone Enrichment | |
| Landline/ /VoIP Detection | |
| Email Formatting | Email Domain Verification/Email Formatting |
| GeoCoding | |
| Output Filtering |
Fuzzy Match
| Community Edition | Standard Edition |
|---|---|
| Exact, N-Gram, and Levenshtein Only | All Matching Algorithms |
| Two Match Field Limit | Unlimited Match Fields |
MatchUp Component
| Functionality | Community Edition | Standard Edition |
|---|---|---|
| Available Matchcodes | Address | Address |
| Address, Last | Address, Last | |
| Address, Last, First | Address, Last, First | |
| Address, APT | Address, APT | |
| Address, APT, Last | Address, APT, Last | |
| Address, APT, Last, First | Address, APT, Last, First | |
| Address, Fuzzy Last | Address, Fuzzy Last | |
| International Address | International Address | |
| General (40) | General (40) | |
| Address, Last Name, Gender | ||
| Address, Company | ||
| 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
| Functionality | Community Edition | Standard Edition |
|---|---|---|
| Result Codes | No Result Codes | Result Codes Outputted |
| Record Limit | 50,000 | Unlimited |
| License Required | No | Yes |