Setting advanced connection properties

In the Advanced tab, additional configuration options are available, including fine-tuning performance, setting up proxy server connectivity, and setting internal parameters.

Data loading

• Select one of the following Check for changes options:

  • Periodically - When this option is selected, Replicate checks for changes according to the Incremental load interval (seconds)

    Information noteThe interval will start after each "round". A round can be defined as the time it takes for Replicate to read the changes from the source tables, and send them to the target (as a single transaction). The length of a round varies according to the number of tables and changes. So if you specify an interval of 10 minutes and a round takes 4 minutes, then the actual time between checking for changes will be 14 minutes.

  • On initial run and then as scheduled - When this option is selected, to continue capturing changes after the initial task run, you need to schedule the task to run according to your needs.

    Information noteThis option is only relevant if the interval between the CDC cycles is 24 hours or more.

    For information on scheduling tasks, see Scheduling jobs.

• Full Load method: Choose Select API automatically (default), SOAP API, or Bulk API.

  While Bulk API is much faster, it is subject to more restrictive quotas and may also sometimes be unavailable due to heavy load.

  See also: Calculating the Salesforce quota

  • API switchover threshold (records): Only relevant when Select API automatically is selected. If the number of records per table matches or exceeds the specified value, Replicate will retrieve the data using the Bulk API (if the object support Bulk API); otherwise, it will retrieve the data using the SOAP API.

• CDC method: Choose Select API automatically (default), SOAP API, or Bulk API.

  While SOAP API is slower than Bulk API, it has less restrictive quotas and, unlike Bulk API, is usually always available (even during heavy load).

  See also: Calculating the Salesforce quota

  • API switchover threshold (records): Only relevant when Select API automatically is selected. If the number of records per table matches or exceeds the specified value, Replicate will retrieve the data using the Bulk API (if the object support Bulk API); otherwise, it will retrieve the data using the SOAP API.

• Maximum data chunk size (records): If you encounter performance issues, increasing this value might improve performance. However, excessive chunk sizes might result in connection timeouts. In such a case, reduce the value until normal operation is restored.

  Information noteOnly relevant when the Full Load method or CDC method is Bulk API.

• Transaction consistency timeout (sec.): To maintain transactional consistency, increase this value as necessary if your longest transaction exceeds 10 seconds.

  Information noteOnly relevant when the task replication option is set to Full Load and Apply Changes.

• Replicate encrypted columns - Select this option to include encrypted columns in the replication task.

  Information note

  • To replicate encrypted columns, the user specified in the General tab must have the Salesforce "View Encrypted Data" permission.
  • Encrypted columns will not be encrypted on the target.

Metadata

Select the Use labels for column name check box if you want to use Salesforce field labels as column names.

Proxy server

If your Salesforce instance needs to be accessed via a proxy server, specify the access settings below.

• Use proxy server: Select this option to access Salesforce via a proxy server.
• Host name: The host name of the proxy server.
• Port: The port via which to access the proxy server.
• User name: The user name for accessing the proxy server.
• Password: The password for accessing the proxy server.

Internal parameters

Internal parameters are parameters that are not exposed in the UI. You should only use them if instructed by Qlik Support.

To add internal Qlik Replicate parameters:

1. Click the Internal Parameters link.

   The Internal Parameters dialog box opens.

2. In the edit box, type the name of the parameter you need to add and then click it.
3. The parameter is added to the table below the search box with its default value.
4. Change the default value as required.
5. To reset the parameter value to its default, click the "Restore default value" icon at the end of the row.

More options

These options are not exposed in the UI as they are only relevant to specific versions or environments. Consequently, do not set these options unless explicitly instructed to do so by Qlik Support or product documentation.

To set an option, simply copy the option into the Add feature name field and click Add. Then set the value or enable the option according to the instructions you received.

Settings summary

You can view a summary of your settings by clicking the Setting Summary link. This is useful if you need to send a summary of your settings to Qlik Support.