Setting advanced connection properties

In the Advanced tab, you can enable PK chunking and set internal parameters and review your settings.

• Use labels for column name - Select this option if you wish to use Salesforce field labels as column names.

  Information note

  • If you clear this option while the task is stopped, you will need to select the DROP and CREATE table option in the task settings’ Full Load Settings tab, and then reload the task.
  • Tables containing multiple instances of the same label are not supported.

• 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.

  • Replicating encrypted columns will not impact performance

• Perform Full Load using - Choose whether to use Bulk API or SOAP API for Full Load replication. While Bulk API (the default) 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

• Enable PK chunking (Available for Bulk API Full Load only) - Select to enable Primary Key chunking of supported tables during Full Load. PK chunking can be used to split bulk queries on very large tables into chunks based on the record IDs, or primary keys of the queried records.

  Information note

  When this option is enabled, all selected tables will be replicated regardless of whether or not they support PK chunking. Unsupported tables will simply be replicated without being split into chunks.

  As each chunk is processed as a separate batch that counts toward the user's daily batch limit, this option should not be enabled for standard-sized tables. In fact, Salesforce recommends that PK chunking should only be enabled when querying tables with more than 10 million records or when a bulk query consistently times out. Therefore, instead of enabling this option for all tables, it is recommended to set up two different tasks with two different Salesforce endpoints - one (with Enable PK chunking turned on) for replication of tables containing 10 million records or more, and the other (with Enable PK chunking turned off) for any other tables that you need to replicate.

  For more information on the PK chunking feature as well as a list of supported objects, see the Salesforce online help.

  • Chunk size - Specify the number of records within the ID boundaries for each chunk. The default is 200,000, and the maximum size is 250,000.

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.