Global Resource Property

Connection Settings

Global resource connection setting can be created or edited by ["Global Resource Settings"] in the Control Panel or in properties of each adapter.

Basic Settings

Item name	Required/Optional	Use of Variables	Description	Supplement
Name	Required	Not Available	Enter the destination setting name.

Required Settings

Item name	Required/Optional	Use of Variables	Description	Supplement
User ID	Required	Only environment variables are available	Enter the login user ID.	If the [Connect with OAuth] is not checked, this field becomes valid and an input required attribute.
Password	Required	Only environment variables are available	Enter the login password.	If the [Connect with OAuth] is not checked, this field becomes valid and an input required attribute.
Login Type	Required	Not Available	Choose login type. [login.salesforce.com]:(default) Login to a Production/Developer environment. [Sandbox]: Login to a SandBox environment. [Other]: Directly define the login URL.	If the [Connect with OAuth] is not checked, this field becomes valid.
Login URL	Optional	Only environment variables are available	Input the login URL.	If the [Login Type] is set to [Other] and the [Connect with OAuth] is not checked, this field becomes valid and an input required attribute.
Connect to OAuth	Optional	Not Available	Choose the type of destination. [login.salesforce.com]:(default) Connect to a Production/Developer environment. [SandBox]: Connect to a SandBox environment.	If the [Connect with OAuth] is checked, this field becomes valid.
Refresh Token	Optional	Only environment variables are available	Input the Refresh Token.	If the [Connect with OAuth] is checked, this field becomes valid and an input required attribute.
Timeout (sec)	Optional	Only environment variables are available	The timeout duration of the socket level connection to Salesforce is specified by seconds. Specifically, a request, for example a query, is sent to Salesforce, and the response waiting time is displayed.	The default value is "600."
Connection timeout (sec)	Optional	Only environment variables are available	The waiting time, when establishing a connection to Salesforce, is configured by the second. Specifically, depending on whether or not to make a connection from the DataSpiderServer to multiple Salesforces simultaneously, or depending on the load or overload of the network itself, the below mentioned exception occurrence timing is adjusted. org.apache.commons.httpclient.HttpException: Timeout waiting for connection	The default value is "60."
I/O bound Data Compression	Required	Not Available	Select whether or not to GZIP compression of the request messages and response messages from/to Salesforce. By compressing the transmission data the process effectivity increases. [Compress]:(default) Data is compressed. [Not Compress]: Data is not compressed.
Connect with OAuth	Optional	Not Available	Choose the method of connecting to Salesforce. [Checked]: Connect with OAuth2.0. [Not Checked]:(default) Connect by User ID/Password.

Property Action

Item name	Description	Supplement
Connection Test	Check the connection to the host.

Option Settings

Item name	Required/Optional	Use of Variables	Description	Supplement
Allow field truncation	Required	Not Available	Select whether to truncate the update value's character string if, during an update, the update value's character string length is larger than the number of item length. [Truncate]:(default) Truncates the character string. [Not Truncate]: Does not truncate the character string. If larger than the item length, an error will occur.	Please refer to the "AllowFieldTruncationHeader" page of the API document "SOAP API Developer's Guide" for details.

PROXY setting

Item name	Required/Optional	Use of Variables	Description	Supplement
Use a Proxy Server	Required	Not Available	Select whether or not to use the proxy server. [Checked]: Use the proxy server. [Not Checked]:(defualt) Not use the proxy server.
Proxy host	Optional	Only environment variables are available	Enter the proxy server's host address. This becomes valid and required when [USE] is selected for the [Use a Proxy Server].
Proxy port	Optional	Only environment variables are available	Enter the proxy server's port number. This becomes valid and required when [USE] is selected for the [Use a Proxy Server].
Proxy user	Optional	Only environment variables are available	Enter the proxy server's authentication User. This becomes valid when [USE] is selected for the [Use a Proxy Server].	Only the basic authentication is available.
Proxy password	Optional	Only environment variables are available	Enter the proxy server's authentication password. This becomes valid when [USE] is selected for the [Use a Proxy Server].

Connection Retry Settings

Item name	Required/Optional	Use of Variables	Description	Supplement
Type of API call for retry target	Optional	Not Available	Set the range of the retry process target API calls in the case that a specific error occurs during connecting to Salesforce. [Unspecified (do not retry)]: All API calls, used during the execution of the operation, will be excluded from retry targets. [Until auth-related calls]: Out of the API calls used for the operation, the Login, Describe calls will be the targets of the retry process. [Until read-related calls]:(default) Out of the API calls used for the operation, Login, Describe, as well as read-related API calls will be targeted for the retry process. [All calls]: All API calls used during the operation will be targets of the retry process.	For details, please refer to "Connection Retry Process."
Number of connection retries	Optional	Only environment variables are available	Set the number of retries to be performed in the case that a specific error occurs when connecting to Salesforce.	The default value is "5."
Waiting time (sec) during a connection retry	Optional	Only environment variables are available	Set the the waiting time, in seconds, until the retry process in the case that a specific error occurs while connecting to Salesforce.	The default value is "1."

Connection Retry Details Settings

Item name

Required/Optional

Use of Variables

Description

Supplement

All Exception are handled as the connection retry target

Optional

Not Available

Specify whether or not all exceptions which occur during connection to Salesforce will be retry targets.

[Checked]:
All Exceptions will be retry targets.
[Not Checked]:(default)
The retry target exceptions are specified individually.

This becomes valid if [Unspecified (do not retry)] is not selected in the [Type of API call for retry target].

Specify Exception class and message for the connection retry target

Optional

Specify the connection retry target exception class and the message as a one combination.
Multiple combinations can be specified.
Rows of each combination can be manipulated with the below mentioned buttons.

[Add]:
Add a row.
[Move Up]:
Move the selected row upward by one row.
[Move Down]:
Move the selected row downward by one row
[Remove]:
Delete the row.

This becomes valid when an item other than [Unspecified (do not retry)] has been selected in the [Type of API call for retry target], and additionally, [Not Checked] has been selected for [All Exception are handled as the connection retry target].

As a default, the following condition will be specified.

The Conditions of the Connection Retry Exceptions
Error Message contains "connection reset"
Error Message contains "error in parsing the status line from the response: unable to find line starting with "http""

Specify Exception class and message for the connection retry target/Exception class name

Optional

Only environment variables are available

Specify the exception class name.
If not specified, only the [Error Message] will be the condition.

Rows in which both [Exception class name] and [ErrorMessage] are unspecified will be ignored.
Configuration Examples:
- java.net.SocketException
- org.apache.commons.httpclient.HttpException

Specify Exception class and message for the connection retry target/ErrorMessage

Optional

Only environment variables are available

Specify the error message.
Whether or not the specified character string is included in the message of the occurred exception is determined. Capitalised and non capitalised letters will not be differentiated.
If not specified, only the [Exception class name] will be used as the condition.

Rows in which both [Exception class name] and [Error Message] are unspecified will be ignored.

Specify API ExceptionCode for the connection retry target

Optional

Specify tte the exception code which targets the connection retry, in the case where the API returns an error.
Multiple ExceptionCodes can be specified.
Each row can be manipulated by the below mentioned buttons.

[Add]:
Add a row.
[Move Up]:
Move the selected row upward by one row.
[Move Down]:
Move the selected row downward by one row
[Remove]:
Delete the row.

This becomes valid when an item other than [Unspecified (do not retry)] has been selected in the [Type of API call for retry target], and additionally, [Not Checked] has been selected for [All Exception are handled as the connection retry target].
As a default, the following ExceptionCode will be specified.

ExceptionCode

SERVER_UNAVAILABLE

Specify API ExceptionCode for the connection retry target/ExceptionCode

Required

Only environment variables are available

Specify the ExceptionCode.

Unspecified rows will be ignored.
For the ExceptionCode, please refer to the "Exception Code" page in the API Document "SOAP API Developer's Guide."

Component Pool Settings

Component pool is not supported.

Security

Security can only be set from "Global Resource Settings" from Control Panel.

About connection retry

An exception will occur when connection with Salesforce fails at API call. For example, in cases of a temporary poor network, it is likely to succeed at a retry.
Connection retry process is a feature to automatically retry the API call when an API network error occurs.

Connection retry will run when an exception specified under [Type of API call for retry target] occur and also the condition matches with the detail in [detail settings for connection retry]
Connection retry will run per failed request. The [Number of connection retry] count will reset every time the request is successful.
Requests may be sent twice when running a connection retry. For example, if an API call to add a record is requested twice, it may create duplicate records. Please consider about the degree of allowing double transmission and the limit of API calls.

Type of API calls for retry target

Please specify the type of API call for retry target in [Type of API call for retry target]
Please refer to the list below for detail.

Type of API call for retry target	auth	Read Related	Update Related
Type of API call for retry target	login new access token	query queryMore	upsert
[Unspecified (do not retry)]	×	×	×
[Until auth-related calls]	○	×	×
[Until read-related calls]	○	○	×
[All calls]	○	○	○

Please refer to help for details on the type of API call used in each operation.
Auth related calls will occur either when the adapter conducts an initial transmission or when the session time expires during run-time.

Detail settings for connection retry

[Detail settings for connection retry] specifies the type of retry target when an exception occur.
When [Retry unconditionally] is [checked off], [Specify exceptional class and message for connection retry] and [Specify API ExceptionCode for connection retry] can be configured. If so, anything that matches the exceptions will be targeted for the retry.

[Specify exceptional class and message for connection retry]
- Set the exceptional condition at transmission failure.
- When [Exceptional Class name] and [Error Message] is input, both must match as a condition.
- If either [Exceptional Class name] or [Error message] is left blank, it will become unconditional.
[Specify API ExceptionCode for connection retry]
- Specify the ExceptionCode when API fault exception is returned from Salesforce.