SSIS:Subscribe

From Melissa Data Wiki
Revision as of 15:46, 22 August 2018 by Admin (talk | contribs)
Jump to navigation Jump to search

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