Difference between revisions of "SSIS:Global Verify:Advanced Configuration"

From Melissa Data Wiki
Jump to navigation Jump to search
Line 1: Line 1:
[[SSIS:Reference|← SSIS Reference]]
{{SSISGlobalVerifyNav
 
|AdvancedCollapse=
{| 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;"|'''Global Verify Navigation'''
|-
| style="padding-right:220px;"|
|-
|[[SSIS:Global Verify|Overview]]
|-
|[[SSIS:Global Verify Tutorial|Tutorial]]
|-
|
{| class="mw-collapsible" style="width:100%;"
|- align="left"
! style="color:black;"|[[SSIS:Global Verify:Advanced Configuration|Advanced Configuration]]
|-
|[[#Melissa Data Cloud|Melissa Data Cloud]]
|}
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|Global Verify Tabs
|-
|[[SSIS:Global Verify:Name|Name]]
|-
|[[SSIS:Global Verify:Address|Address]]
|-
|[[SSIS:Global Verify:Phone|Phone]]
|-
|[[SSIS:Global Verify:Email|Email]]
|-
|[[SSIS:Global Verify:Pass-Through Columns|Pass-Through Columns]]
|-
|[[SSIS:Global Verify:Output Filter|Output Filter]]
|}
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|[[SSIS:Global Verify:Result Codes|Result Codes]]
|-
|[[Returned Result Codes:Enterprise Solutions#Data Quality Components for SSIS|Returned Result Codes]]
|-
|[[Result Codes]]
|}
|}
 


{{CustomTOC}}
{{CustomTOC}}
Line 112: Line 67:
;Service Request
;Service Request
:Displays the Web Service request status with the number of retries and seconds to connect.
:Displays the Web Service request status with the number of retries and seconds to connect.
==On-Premise==
For Melissa Data On-Premise processing, you need the License String 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 License String, click the Show Details button at the bottom of this screen to verify that the License String was entered correctly. If you have a on-premise license, the on-premise settings buttons should now appear. Please check the countries you want to be processed locally on your machine by clicking the checkbox. Make sure to put the data file path where all of your global data files are stored.
[[File:SSIS_GV_Advanced_OnPremise.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 the Global Verify Component 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 objects to be initialized and threaded to run in parallel. Recommended one thread per core.
;Maximum Transaction Size
:Specify the number of records to be sent to the object per request.
;Request Timeout
:Specify the number of seconds for the Global Verify Component to wait before timing out. Some requests may experience connection lag or timeouts due to network problems or hard drive I/O.
;Number of Retries
:Specify the number of times the Global Verify Component 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 (On Premise)===
Either the version number or build number will assist Melissa Data Technical Support in determining if you have the latest software installed on your system.
[[File:SSIS_GV_Advanced_OnPremise_Test.png|link=]]
====Global Verify Component====
;Component Version
:Displays the current SSIS component version.
;Build Number
:Displays the current development release build number of the Global Verify Component for SSIS. This is usually a three or four-character string.
====Web Services Connectivity Info====
;Connect
:Displays an icon indicating if there is a connection to the web service or object initialization.
;Web Service
:Displays the name of the web service or object.
;Version
:This box displays the version number of the Web Service or Object DLL.
;Service Request
:Displays the Web/On-Premise Service request status with the number of retries and seconds to connect.




[[Category:SSIS]]
[[Category:SSIS]]
[[Category:SSIS Global Verify]]
[[Category:SSIS Global Verify]]

Revision as of 20:49, 13 August 2015

← SSIS:Data Quality Components

Global Verify Navigation
Overview
Tutorial
Advanced Configuration
Melissa Data Cloud
On-Premise
Global Verify Tabs
Name
Address
Phone
Email
Pass-Through Columns
Output Filter
Result Codes
Returned Result Codes
Result Codes



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

Melissa Data Cloud

For Melissa Data Cloud processing, you need the License String 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 License String, click the Show Details button at the bottom of this screen to verify that the License String was entered correctly.

SSIS GV Advanced Cloud.png

The following items should only be altered if directed by Melissa Data's support staff.

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 the Global Verify Component 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.
Maximum Transaction Size
Specify the number of records to be sent to the Melissa Data Cloud per request.
Request Timeout
Specify the number of seconds for the Global Verify Component 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 the Global Verify Component 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 software installed on your system.

SSIS GV Advanced Cloud Test.png

Global Verify Component

Component Version
Displays the current SSIS component version.
Build Number
Displays the current development release build number of the Global Verify Component for SSIS. This is usually a three or four-character string.

Web Services Connectivity Info

Connect
Displays an icon indicating if there is a connection to the web service or not.
Web Service
Displays the name of the web service.
Version
This box displays the version number of the Property Web Service.
Service Request
Displays the Web Service request status with the number of retries and seconds to connect.


On-Premise

For Melissa Data On-Premise processing, you need the License String 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 License String, click the Show Details button at the bottom of this screen to verify that the License String was entered correctly. If you have a on-premise license, the on-premise settings buttons should now appear. Please check the countries you want to be processed locally on your machine by clicking the checkbox. Make sure to put the data file path where all of your global data files are stored.

SSIS GV Advanced OnPremise.png

The following items should only be altered if directed by Melissa Data's support staff.

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 the Global Verify Component 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 objects to be initialized and threaded to run in parallel. Recommended one thread per core.
Maximum Transaction Size
Specify the number of records to be sent to the object per request.
Request Timeout
Specify the number of seconds for the Global Verify Component to wait before timing out. Some requests may experience connection lag or timeouts due to network problems or hard drive I/O.
Number of Retries
Specify the number of times the Global Verify Component 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 (On Premise)

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

SSIS GV Advanced OnPremise Test.png

Global Verify Component

Component Version
Displays the current SSIS component version.
Build Number
Displays the current development release build number of the Global Verify Component for SSIS. This is usually a three or four-character string.

Web Services Connectivity Info

Connect
Displays an icon indicating if there is a connection to the web service or object initialization.
Web Service
Displays the name of the web service or object.
Version
This box displays the version number of the Web Service or Object DLL.
Service Request
Displays the Web/On-Premise Service request status with the number of retries and seconds to connect.