Difference between revisions of "SSIS:Property:Advanced Configuration"

From Melissa Data Wiki
Jump to navigation Jump to search
 
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
[[SSIS:Reference|← SSIS Reference]]
{{SSISPropertyNav
 
|AdvancedConfigCollapse=
{| 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;"|'''Property Navigation'''
|-
| style="padding-right:220px;"|
|-
|[[SSIS:Property|Overview]]
|-
|[[SSIS:Property Tutorial|Tutorial]]
|-
|
{| class="mw-collapsible" style="width:100%;"
|- align="left"
! style="color:black;"|[[SSIS:Property:Advanced Configuration|Advanced Configuration]]
|-
|[[#Melissa Data Cloud|Melissa Data Cloud]]
|}
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|Property Tabs
|-
|[[SSIS:Property:Input|Input]]
|-
|[[SSIS:Property:Pass-Through|Pass-Through Columns]]
|-
|[[SSIS:Property:Output|Output]]
|-
|[[SSIS:Property:Output Filter|Output Filter]]
|}
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|[[SSIS:Property:Result Codes|Result Codes]]
|-
|[[Returned Result Codes:Enterprise Solutions#Data Quality Components for SSIS|Returned Result Codes]]
|-
|[[Result Codes]]
|}
|}




{{CustomTOC}}
{{CustomTOC}}


Advanced Configuration is located in the Reverse GeoCoder Component under File > Advanced Configuration.
Advanced Configuration is located in the Property Component under File > Advanced Configuration.


==Melissa Data Cloud==
==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.
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 String, click the Show Details button at the bottom of this screen to verify that the License String 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_PY_Advanced_Cloud.png|link=]]
[[File:SSIS_PY_Advanced_Cloud.png|link=]]
Line 61: Line 21:


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


;User Name
;User Name
Line 76: Line 36:


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


;Number of Retries
;Number of Retries
:Specify the number of times Reverse GeoCoder should re-send a request to the Melissa Data Cloud due to any exceptions.
:Specify the number of times the Property Component should re-send a request to the Melissa Data Cloud due to any exceptions.


;Abort on Critical Error
;Abort on Critical Error
Line 85: Line 45:


===Test Configuration (Cloud)===
===Test Configuration (Cloud)===
Either the version number or build number will assist Melissa Data Technical Support in determining if you have the latest Reverse GeoCoder software installed on your system.
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_PY_Advanced_Cloud_Test.png|link=]]
[[File:SSIS_PY_Advanced_Cloud_Test.png|link=]]


====Reverse GeoCoder Component====
====Property Component====
;Component Version
;Component Version
:Displays the current SSIS component version.
:Displays the current SSIS component version.


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


====Reverse GeoCoder Web Service====
====Property Web Service====
;Service Response
;Service Response
:Displays the Web Service response status with the number of retries and seconds to connect.
:Displays the Web Service response status with the number of retries and seconds to connect.


;Version
;Version
:This box displays the version number of the Reverse GeoCoder Web Service.
:This box displays the version number of the Property Web Service.




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

Latest revision as of 19:26, 16 December 2016

← SSIS:Data Quality Components

Property Navigation
Overview
Tutorial
Advanced Configuration
Melissa Data Cloud
Property Tabs
Input
Pass-Through Columns
Output
Property Codes
Output Filter
Result Codes
Result Codes



Advanced Configuration is located in the Property Component under File > Advanced Configuration.

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.

SSIS PY 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 Property 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 Property 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 Property 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 PY Advanced Cloud Test.png

Property Component

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

Property 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 Property Web Service.