SSIS:IP Locator:Advanced Configuration - Revision history

Admin at 23:56, 22 December 2016

2016-12-22T23:56:24Z

← Older revision		Revision as of 23:56, 22 December 2016
Line 101:		Line 101:

	==Melissa Data Cloud==		==Melissa Data Cloud==
	For Melissa Data Cloud processing, you need the ~~Customer ID number~~ issued to you by your sales representative. The other settings on this part of the Advanced Configuration screen should not be changed unless you are specifically directed to do so by Melissa Data Technical Support.		For Melissa Data Cloud processing, you need the License Key issued to you by your sales representative. The other settings on this part of the Advanced Configuration screen should not be changed unless you are specifically directed to do so by Melissa Data Technical Support.

	After entering the ~~Customer ID number~~, click the Show Details button at the bottom of this screen to verify that the ~~Customer ID~~ was entered correctly.		After entering the License Key, click the Show Details button at the bottom of this screen to verify that the License Key was entered correctly.

	[[File:SSIS_IP_Advanced_Cloud.png\|link=]]		[[File:SSIS_IP_Advanced_Cloud.png\|link=]]
Line 191:		Line 191:

	;Failover to MD Servers		;Failover to MD Servers
	:Check this box to use Cloud (Melissa Data Cloud) processing as a redundant backup for Local Appliance (Dedicated Cloud) processing. You must have a valid ~~Customer ID~~ and also configure the Web settings in addition to the Local Appliance settings.		:Check this box to use Cloud (Melissa Data Cloud) processing as a redundant backup for Local Appliance (Dedicated Cloud) processing. You must have a valid License Key and also configure the Web settings in addition to the Local Appliance settings.


	[[Category:SSIS]]		[[Category:SSIS]]

Admin at 18:39, 16 December 2016

2016-12-16T18:39:33Z

← Older revision		Revision as of 18:39, 16 December 2016
Line 15:		Line 15:
	[[File:SSIS_IP_Advanced.png\|link=]]		[[File:SSIS_IP_Advanced.png\|link=]]

	;License ~~String~~		;License Key
	:Your ~~license string~~ will activate the product for use.		:Your License Key will activate the product for use.

	;Community Edition		;Community Edition

Admin at 00:12, 14 November 2015

2015-11-14T00:12:24Z

@@ Line 1: / Line 1: @@
-[[SSIS:Reference|&larr; SSIS Reference]]
+{{SSISIPLocatorNav
+|AdvancedConfigCollapse=
-{| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"
+}}

Admin at 22:47, 15 October 2014

2014-10-15T22:47:09Z

← Older revision		Revision as of 22:47, 15 October 2014
Line 157:		Line 157:

	;Proxy URL		;Proxy URL
	:If your network uses a Proxy Server, enter the Proxy URL information on this field in order for IP Locator to communicate with the Melissa Cloud. The format is "URL:port".		:If your network uses a Proxy Server, enter the Proxy URL information on this field in order for IP Locator to communicate with the Melissa Data Cloud. The format is "URL:port".

	;User Name		;User Name
Line 208:		Line 208:

	;Proxy URL		;Proxy URL
	:If your network uses a Proxy Server, enter the Proxy URL information on this field in order for IP Locator to communicate with the Melissa Cloud. The format is "URL:port".		:If your network uses a Proxy Server, enter the Proxy URL information on this field in order for IP Locator to communicate with the Melissa Data Cloud. The format is "URL:port".

	;User Name		;User Name

Admin at 21:29, 7 October 2014

2014-10-07T21:29:49Z

← Older revision		Revision as of 21:29, 7 October 2014
Line 39:		Line 39:
	{\| class="mw-collapsible mw-collapsed" style="width:100%;"		{\| class="mw-collapsible mw-collapsed" style="width:100%;"
	\|- align="left"		\|- align="left"
	! style="color:black;"\|Result Codes		! style="color:black;"\|[[SSIS:IP Locator:Result Codes\|Result Codes]]
	\|-		\|-
	\|[[Returned Result Codes:Enterprise Solutions#Data Quality Components for SSIS\|Returned Result Codes]]		\|[[Returned Result Codes:Enterprise Solutions#Data Quality Components for SSIS\|Returned Result Codes]]

Admin at 21:18, 7 October 2014

2014-10-07T21:18:36Z

← Older revision		Revision as of 21:18, 7 October 2014
Line 41:		Line 41:
	! style="color:black;"\|Result Codes		! style="color:black;"\|Result Codes
	\|-		\|-
	\|[[Returned Result Codes:Enterprise Solutions#SSIS\|Returned Result Codes]]		\|[[Returned Result Codes:Enterprise Solutions#Data Quality Components for SSIS\|Returned Result Codes]]
	\|-		\|-
	\|[[Result Codes]]		\|[[Result Codes]]

Admin at 18:29, 13 August 2014

2014-08-13T18:29:12Z

← Older revision		Revision as of 18:29, 13 August 2014
Line 52:		Line 52:
	Advanced Configuration is located in the IP Locator Component under File > Advanced Configuration.		Advanced Configuration is located in the IP Locator Component under File > Advanced Configuration.

	[[File:~~SSIS_IP_Advanced_Menu~~.png\|link=]]		[[File:SSIS_Advanced_Menu.png\|link=]]

Admin at 18:07, 25 July 2014

2014-07-25T18:07:58Z

← Older revision		Revision as of 18:07, 25 July 2014
Line 15:		Line 15:
	! style="color:black;"\|[[SSIS:IP Locator:Advanced Configuration\|Advanced Configuration]]		! style="color:black;"\|[[SSIS:IP Locator:Advanced Configuration\|Advanced Configuration]]
	\|-		\|-
	\|[[SSIS:IP Locator:Advanced Configuration#~~Test~~ Configuration\|~~Test~~ Configuration]]		\|[[SSIS:IP Locator:Advanced Configuration#Community\|Community]]
			\|-
			\|[[SSIS:IP Locator:Advanced Configuration#On-Premise\|On-Premise]]
			\|-
			\|[[SSIS:IP Locator:Advanced Configuration#Melissa Data Cloud\|Melissa Data Cloud]]
			\|-
			\|[[SSIS:IP Locator:Advanced Configuration#Dedicated Cloud\|Dedicated Cloud]]
	\|}		\|}
	\|-		\|-
Line 46:		Line 52:
	Advanced Configuration is located in the IP Locator Component under File > Advanced Configuration.		Advanced Configuration is located in the IP Locator Component under File > Advanced Configuration.

	[[File:~~SSIS_IP_ComponentSettings_Menu~~.png\|link=]]		[[File:SSIS_IP_Advanced_Menu.png\|link=]]


	==Processing Mode==		==Processing Mode==

			[[File:SSIS_IP_Advanced.png\|link=]]

	;License String		;License String
	:Your license string will activate the product for use.		:Your license string will activate the product for use.
Line 190:		Line 199:
	==Dedicated Cloud==		==Dedicated Cloud==

	[[File:~~SSIS_IP_ComponentSettings_LocalAppliance~~.png\|link=]]		[[File:SSIS_IP_Advanced_Dedicated.png\|link=]]

	;Server URL		;Server URL

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-07-25T18:04:10Z

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;"|'''IP Locator Navigation'''
|-
| style="padding-right:220px;"|
|-
|[[SSIS:IP Locator|Overview]]
|-
|[[SSIS:IP Locator Tutorial|Tutorial]]
|-
|
{| class="mw-collapsible" style="width:100%;"
|- align="left"
! style="color:black;"|[[SSIS:IP Locator:Advanced Configuration|Advanced Configuration]]
|-
|[[SSIS:IP Locator:Advanced Configuration#Test Configuration|Test Configuration]]
|}
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|IP Locator Tabs
|-
|[[SSIS:IP Locator:Input/Output|Input/Output]]
|-
|[[SSIS:IP Locator:Pass-Through|Pass-Through Columns]]
|-
|[[SSIS:IP Locator:Output Filter|Output Filter]]
|}
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|Result Codes
|-
|[[Returned Result Codes:Enterprise Solutions#SSIS|Returned Result Codes]]
|-
|[[Result Codes]]
|}
|}

{{CustomTOC}}

Advanced Configuration is located in the IP Locator Component under File > Advanced Configuration.

[[File:SSIS_IP_ComponentSettings_Menu.png|link=]]

==Processing Mode==
;License String
:Your license string will activate the product for use.

;Community Edition
:The Community Edition of Contact Verify allows you to explore the full capabilities of this component (with some limitations). Contact a Melissa Data sales representative (call 1-800-MELISSA) for licensing information to unlock this component's full functionality.

;On-Premise
:Processing will be performed on this machine using local data files. This method is the fastest and most secure option as no data leaves your premises. It is ideal for large batch processing where speed and/or security is a concern, but requires periodic updates to be performed on each machine.

;Melissa Data Cloud
:Processing will be performed on Melissa Data's servers using Web service protocols over the internet. This method is slower but no maintenance is required. It is ideal for processing smaller files and for quickly running this component without installing the local data files.

;Dedicated Cloud
:Processing will be performed on a dedicated Contact Verification Server using Web service protocols. These servers may be hosted locally or remotely and will be dedicated to your organization for increased speed and security.

==Community==
;Data File Path
:This should point to the folder on the local system that contains the IP Locator Component and its data files. The default path should work unless you install the component to a different folder.

After entering the Data Path, click the Test Configuration button immediately below the Data File Path to verify that the Data Path was entered correctly.

[[File:SSIS_IP_Advanced_Community.png|link=]]

===Test Configuration (Community)===
The Test Configuration screen for On-Premise Processing displays basic information about the object libraries being used by the IP Locator.

[[File:SSIS_IP_Advanced_Community_Test.png|link=]]

====Community Object====
;Component Version
:Displays the current SSIS component version.

;License Expiration
:Displays the date when the IP Locator Component license will expire.

;Build Number
:Displays the current development release build number of the IP Locator Component for SSIS. This is usually a three or four-character string.

;IP Locator Initialization
:Displays any error messages generated by initializing the IP Locator Object.

;Build Number
:Displays the current development release build number of the IP Locator Object. This is usually a three or four-character string.

==On-Premise==
;Data File Path
:This should point to the folder on the local system that contains the IP Locator Component and its data files. The default path should work unless you install the component to a different folder.

After entering the Data Path, click the Test Configuration button immediately below the Data File Path to verify that the Data Path was entered correctly.

[[File:SSIS_IP_Advanced_OnPremise.png|link=]]

===Test Configuration (On-Premise)===
The Test Configuration screen for On-Premise Processing displays basic information about the object libraries being used by the IP Locator.

[[File:SSIS_IP_Advanced_OnPremise_Test.png|link=]]

====IP Locator SSIS Component====
;Component Version
:Displays the current SSIS component version.

;License Expiration
:Displays the date when the IP Locator Component license will expire.

;Build Number
:Displays the current development release build number of the IP Locator Component for SSIS. This is usually a three or four-character string.

====IP Locator Object====
;Initialization
:Displays any error messages generated by initializing the IP Locator Object.

;Build Number
:Displays the current development release build number of the IP Locator Object. This is usually a three or four-character string.

;Database Date
:Displays the date of the IP Locator Object data files. This date confirms that the data files are the latest available.

;Database Expiration Date
:Displays the date when the IP Locator Object data files will expire. This date confirms that the data files are the latest available.

==Melissa Data Cloud==
For Melissa Data Cloud processing, you need the Customer ID number issued to you by your sales representative. The other settings on this part of the Advanced Configuration screen should not be changed unless you are specifically directed to do so by Melissa Data Technical Support.

After entering the Customer ID number, click the Show Details button at the bottom of this screen to verify that the Customer ID was entered correctly.

[[File:SSIS_IP_Advanced_Cloud.png|link=]]

<span style="color:red;">'''The following items should only be altered if directed by Melissa Data's support staff.'''</span>

;Use Proxy
:If your network uses a Proxy Server, check this box and enter the Proxy information below.

;Proxy URL
:If your network uses a Proxy Server, enter the Proxy URL information on this field in order for IP Locator to communicate with the Melissa Cloud. The format is "URL:port".

;User Name
:The user name for your Proxy Server, if any.

;Password
:The password for your Proxy Server, if any.

;Maximum Threads
:Specify the number of simultaneous requests to be sent to the Melissa Data Cloud Services to run in parallel.

;Request Timeout
:Specify the number of seconds for IP Locator to wait before timing out. Some requests may experience connection lag or timeouts due to network problems.

;Number of Retries
:Specify the number of times IP Locator should re-send a request to the Melissa Data Cloud due to any exceptions.

;Abort on Critical Error
:Will abort the process, in event of critical errors related to the Component such as the Web service code WSE00; Unexpected Error-Please Retry.

===Test Configuration (Cloud)===
Either the version number or build number will assist Melissa Data Technical Support in determining if you have the latest IP Locator software installed on your system.

[[File:SSIS_IP_Advanced_Cloud_Test.png|link=]]

====IP Locator Component====
;Component Version
:Displays the current SSIS component version.

;Build Number
:Displays the current development release build number of the IP Locator Component for SSIS. This is usually a three or four-character string.

====IP Locator Web Service====
;Service Response
:Displays the Web Service response status with the number of retries and seconds to connect.

;Version
:This box displays the version number of the IP Locator Web Service.

==Dedicated Cloud==

[[File:SSIS_IP_ComponentSettings_LocalAppliance.png|link=]]

;Server URL
:This is the internet or intranet address of the server to be used by the IP Locator for processing. Check with your network administrator if you need help with this setting.

;Use Proxy
:If your network uses a Proxy Server, check this box and enter the Proxy information below.

;Proxy URL
:If your network uses a Proxy Server, enter the Proxy URL information on this field in order for IP Locator to communicate with the Melissa Cloud. The format is "URL:port".

;User Name
:The user name for your Proxy Server, if any.

;Password
:The password for your Proxy Server, if any.

;Enable Compression
:Check this to enable GZip compression. This can have up to a 10% increase in speed.

;Maximum Threads
:Specify the number of simultaneous requests to be sent to the Melissa Data Appliance to run in parallel.

;Maximum Transaction Size
:Specify the number of records to be sent in a single request. A single request may contain between 1 – 100 records. It is recommended to set this value to 100 for optimal throughput.

;Request Timeout
:Specify the number of seconds for IP Locator to wait before timing out. Some requests may experience connection lag or timeouts due to network problems.

;Number of Retries
:Specify the number of times IP Locator should re-send a request to the Appliance due to any exceptions.

;Abort on Critical Error
:Enable this option to stop file processing when any exception is thrown. Disabling this option will disregard any exceptions and continue processing your file.

;Failover to MD Servers
:Check this box to use Cloud (Melissa Data Cloud) processing as a redundant backup for Local Appliance (Dedicated Cloud) processing. You must have a valid Customer ID and also configure the Web settings in addition to the Local Appliance settings.

[[Category:SSIS]]