View source for SSIS:Contact Verify:Advanced Configuration

{{SSISContactVerifyNav
|AdvancedConfigCollapse=
}}


{{CustomTOC}}

Advanced Configuration is located in the Contact Verify Component under File > Advanced Configuration.

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


==Processing Mode==

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

;License Key
:Your License Key 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 Contact Verify 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_CV_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 Contact Verify.

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

====All Objects====
;Component Version
:Displays the current SSIS component version.

;License Expiration
:Displays the date when the Contact Verify Component License Key will expire.

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

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

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

;Parse Initialization
:Displays any error messages generated by initializing the Parser.

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

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

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

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

:;Build Number
::Displays the current development release build number of the Email 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 Contact Verify 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_CV_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 Contact Verify.

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

====All Objects====
;Component Version
:Displays the current SSIS component version.

;License Expiration
:Displays the date when the Contact Verify Component License Key will expire.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

;Database Expiration
:Displays the date when the Email 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 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 License Key, click the Show Details button at the bottom of this screen to verify that the License Key was entered correctly.

[[File:SSIS_CV_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 Contact Verify to communicate with the Melissa Data 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 Contact Verify 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 Contact Verify 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 Contact Verify software installed on your system.

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

====Contact Verify Component====
Either the version number or build number will assist Melissa Data Technical Support in determining if you have the latest CVC software installed on your system.

;Version
:The version number of the component installed on your local system.

;Build Number
:The build number of the component installed on your local system.

====Name Parser Web Service====
;Service Response
:This will indicate if the CVC was able to successfully connect to the Name Parser Web Service and authorize your License Key. If the CVC was unable to connect to the service or your License Key is not authorized to use the Name Parser Web Service, this will be indicated in this box.

:To add access to the Name Parser Web Service to your account, contact your Melissa Data sales representative at 1-800-MELISSA.

:If this indicates that you could not connect to the Name Parser Web Service, check your Internet connectivity before contacting Melissa Data Technical Support.

;Version
:The current version number of the Name Parser Web Service.

====Address Verifier Web Service====
;Service Response
:This will indicate if the CVC was able to successfully connect to the Address Verifier Web Service and authorize your License Key. If the CVC was unable to connect to the service or your License Key is not authorized to use the Address Verifier Web Service, this will be indicated in this box.

:To add access to the Address Verifier Web Service to your account, contact your Melissa Data sales representative at 1-800-MELISSA.

:If this indicates that you could not connect to the Address Verifier Web Service, check your Internet connectivity before contacting Melissa Data Technical Support.

;Version
:The current version number of the Address Verifier Web Service.

====Delivery Indicator Web Service====
;Service Response
:This will indicate if the CVC was able to successfully connect to the Delivery Indicator Web Service and authorize your License Key. If the CVC was unable to connect to the service or your License Key is not authorized to use the Delivery Indicator Web Service, this will be indicated in this box.

:To add access to the Delivery Indicator Web Service to your account, contact your Melissa Data sales representative at 1-800-MELISSA.

:If this indicates that you could not connect to the Delivery Indicator Web Service, check your Internet connectivity before contacting Melissa Data Technical Support.

;Version
:The current version number of the Delivery Indicator Web Service.

====GeoCoder Web Service====
;Service Response
:This will indicate if the CVC was able to successfully connect to the GeoCoder Web Service and authorize your License Key. If the CVC was unable to connect to the service or your License Key is not authorized to use the GeoCoder Web Service, this will be indicated in this box.

:To add access to the GeoCoder Web Service to your account, contact your Melissa Data sales representative at 1-800-MELISSA.

:If this indicates that you could not connect to the GeoCoder Web Service, check your Internet connectivity before contacting Melissa Data Technical Support.

;Version
:The current version number of the GeoCoder Web Service.

====Phone Verifier Web Service====
;Service Response
:This will indicate if the CVC was able to successfully connect to the Phone Verifier Web Service and authorize your License Key. If the CVC was unable to connect to the service or your License Key is not authorized to use the Phone Verifier Web Service, this will be indicated in this box.

:To add access to the Phone Verifier Web Service to your account, contact your Melissa Data sales representative at 1-800-MELISSA.

:If this indicates that you could not connect to the Phone Verifier Web Service, check your Internet connectivity before contacting Melissa Data Technical Support.

;Version
:The current version number of the Phone Verifier Web Service.

====Email Verifier Web Service====
;Service Response
:This will indicate if the CVC was able to successfully connect to the Email Verifier Web Service and authorize your License Key. If the CVC was unable to connect to the service or your License Key is not authorized to use the Email Verifier Web Service, this will be indicated in this box.

:To add access to the Email Verifier Web Service to your account, contact your Melissa Data sales representative at 1-800-MELISSA.

:If this indicates that you could not connect to the Email Verifier Web Service, check your Internet connectivity before contacting Melissa Data Technical Support.

;Version
:The current version number of the Email Verifier Web Service.


==Dedicated Cloud==

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

;Server URL
:This is the internet or intranet address of the server to be used by the Contact Verify 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 Contact Verify to communicate with the Melissa Data 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 Contact Verify 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 Contact Verify 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 License Key and also configure the Web settings in addition to the Local Appliance settings.


[[Category:SSIS]]
[[Category:SSIS Contact Verify]]