SSIS:Subscribe

From Melissa Data Wiki
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 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