SSIS:Subscribe - Revision history

Admin at 15:26, 6 September 2018

2018-09-06T15:26:35Z

Admin at 23:20, 5 September 2018

2018-09-05T23:20:32Z

← Older revision		Revision as of 23:20, 5 September 2018
Line 9:		Line 9:
	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 Data Quality Components (DQC) for SSIS through the Melissa Data website at [www.melissa.com/data-integration/microsoft-sql-server] 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.

Admin at 23:18, 5 September 2018

2018-09-05T23:18:31Z

← Older revision		Revision as of 23:18, 5 September 2018
Line 9:		Line 9:
	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 [www.melissa.com/data-integration/microsoft-sql-server] or by calling a Customer Service Representative at 1-800-MELISSA.


Line 26:		Line 26:

	===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.

Admin at 16:00, 22 August 2018

2018-08-22T16:00:56Z

← Older revision		Revision as of 16:00, 22 August 2018
Line 149:		Line 149:


	===Profiler Component===		====Profiler Component====
	{\|class="alternate01" cellspacing="0"		{\|class="alternate01" cellspacing="0"
	!Functionality		!Functionality

Admin at 15:46, 22 August 2018

2018-08-22T15:46:19Z

@@ Line 83: / Line 83: @@
 ====MatchUp Component====
 {|class="alternate01" cellspacing="0"
-!Edition
+!Functionality
 !Community Edition
 !style="border-right:0px;"|Standard Edition
@@ Line 138: / Line 138: @@
 |No Custom Matchcodes
 |Custom Matchcodes
 |-
 |Record Limit

Admin at 23:31, 30 December 2016

2016-12-30T23:31:12Z

@@ Line 1: / Line 1: @@
-[[SSIS:Reference|&larr; 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;"
+}}
 {{CustomTOC}}

Admin at 19:25, 16 December 2016

2016-12-16T19:25:31Z

← Older revision		Revision as of 19:25, 16 December 2016
Line 35:		Line 35:


	Once you are subscribed, your Customer Service Representative will give you a ~~Customer~~ License ~~String~~ 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.


Line 41:		Line 41:
	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.		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 ~~String~~, contact a Customer Service Representative		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.		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 ~~String~~ 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===

Admin at 01:18, 17 December 2014

2014-12-17T01:18:26Z

← Older revision		Revision as of 01:18, 17 December 2014
Line 15:		Line 15:
	! style="color:black;"\|Quick Start		! style="color:black;"\|Quick Start
	\|-		\|-
	\|[[SSIS:Installation\|Installation]]		\|[[SSIS:Installation\|SSIS Installation]]
			\|-
			\|[[SSIS:Component Installation\|Component Installation]]
	\|-		\|-
	\|[[SSIS:Subscribe\|Subscribe]]		\|[[SSIS:Subscribe\|Subscribe]]
			\|-
			\|[[SSIS:Project Setup\|Project Setup]]
	\|}		\|}
	\|}		\|}

Admin: Created page with "← SSIS Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; pa..."

2014-10-11T00:40:38Z

Created page with "← SSIS Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; pa..."

New page

[[SSIS:Reference|← SSIS Reference]]

{| 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|Installation]]
|-
|[[SSIS:Subscribe|Subscribe]]
|}
|}

{{CustomTOC}}

==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 Customer License String 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 String, 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 String 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====
{|class="alternate01" cellspacing="0"
!Community Edition
!style="border-right:0px;"|Standard Edition
|-
|rowspan="5" valign="top"|Last Name Parse
|Full Name Parse
|-
|Genderization
|-
|Company Standardization
|-
|Name Verification
|-
|Suspicious Name/Vulgarity Detection
|-
|rowspan="2" valign="top"|Address Parse
|Address Verification/Correction/Enrichment
|-
|CASS Certification
|-
|rowspan="4" valign="top"|Phone Formatting
|Phone Parsing/Formatting
|-
|Phone Verification
|-
|Phone Enrichment
|-
|Landline/ /VoIP Detection
|-
|rowspan="3" valign="top"|Email Formatting
|Email Domain Verification/Email Formatting
|-
|GeoCoding
|-
|Output Filtering
|}

====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
|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
|-
|rowspan="11" valign="top"|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
|}

[[Category:SSIS]]