Timeout for the HTTPS connection to Salesforce.com. The default is 60 seconds. This is not a session timeout. Salesforce.com session timeout (default 120 minutes) is configurable at Setup | Security Controls on the Salesforce.com website.

The maximum number of concurrent calls for the current user. The default is 3.

The maximum number of concurrent calls for this data source. The default is 5. This setting prevents TDV from emitting too many concurrent requests to Salesforce.com. For example, if set at 5 but there are 20 views scheduled to trigger concurrently, TDV will queue 15 views. Typically, this limit should not be increased, but might be decreased in case there are several Salesforce.com data sources configured.

The maximum number of rows returned from a single request to Salesforce.com. The default is 500 rows. The maximum query batch size is 2,000 records; however the maximum is automatically reduced if you select large text fields or many fields. This behavior is implemented by Salesforce.com on their servers to maintain performance. Even if a query batch size of 200 is selected, Salesforce.com reserves the right to return more or fewer records. For example, the batch size will be no more than 200 if a query selects two or more custom fields of type long text. This is to prevent large SOAP messages from being returned. The Salesforce.com driver for TDV makes as many requests as necessary to Salesforce.com to fully evaluate a query, regardless of the number of rows returned per request by Salesforce.com. For example, if the batch size is set to 2,000 rows (and assuming Salesforce.com honors this number of rows) but there are 4,000 rows in the object and a query spans all of them, TDV issues two requests to Salesforce.com.

Since Salesforce.com is a collection of Web services accessed over the Internet using HTTPS, connections are inherently unreliable. They may timeout or fail altogether. To improve reliability of queries built upon this infrastructure, the Maximum retries can be set to automatically retry any Salesforce.com request upon connectivity failure. The default is 0, meaning the feature is disabled and no retries are attempted.

If the maximum retries feature is enabled, this property specifies the number of seconds to wait between retry attempts. It defaults to 0.

If this checkbox is selected, all requests to Salesforce.com for this data source are passed through a Web proxy specified by the properties Proxy host, Proxy port, and optionally Proxy username and Proxy password.

Host name or IP address of Web proxy. The proxy is used only if the Proxy enabled property is selected.

Port of Web proxy. The proxy is used only if the Proxy enabled property is selected.

Specifies the username and password to be used to authenticate to the selected Web proxy.

Salesforce.com limits the number of records that can be impacted with a single update request to 200. If this option is disabled (the default), Salesforce.com throws an exception if this limit is exceeded. If this option is enabled, updates impacting more than 200 rows are batched to Salesforce.com to workaround the limit. The batches are not transactional, so if the first batch succeeds but the second fails, the first batch still causes an update of Salesforce.com records.

Salesforce.com limits the number of records that can be impacted with a single delete request to 200. If this option is disabled (the default), Salesforce.com throws an exception if this limit is exceeded. If this option is enabled, deletes impacting more than 200 rows are batched to Salesforce.com to workaround the limit. The batches are not transactional, so if the first batch succeeds but the second fails, the first batch still causes a delete of Salesforce.com records.

This property specifies the location of the Salesforce.com environment. It contains two preset values and allows custom values to be provided. By default it is set to the first preset value in the list, the URL of the production Salesforce.com environment. It can also be set to the Salesforce.com Sandbox (the second preset URL), or to the URL of a customer-provided, system on the premises.