Setting advanced connection properties

You can set custom properties or change the default settings for various parameters by adding them to a custom connect string in the Advanced tab of the Add Database dialog box.

You can set the following parameters:

• TPT Operator: Select the TPT Operator used to access the Teradata Database. The possible options are:

  • Load: Select this to use the TPT load mode.
  • Stream: Select this to use the TPT stream mode.

  See Teradata Database target load options.

• TPT Attributes: You can define one or more of the following attributes:

• Account String: The account (database server login) that the DBA assigned to the username for the Qlik Replicate user.

• Buffer Size: The output buffer size (in KB) for sending Load parcels to the Teradata Database.

  You can enter a value from 1 to 64.

• Buffers: The number of request buffers used.

  You can enter any value from 2 or higher.

• Explicit sessions range: Select this if you want set a minimum and/or maximum number of sessions that can log on to the Teradata Database.

  • Maximum: The maximum number of sessions that can log on to the Teradata Database. The default value is 1. The value cannot be higher than the number of Access Module Processors (AMPs) available.
  • Minimum: The minimum number of sessions that can log on to the Teradata Database.

• Dynamic statement packing: Select this check box if you want the stream driver to dynamically determine the maximum possible pack for the current STREAM job.

  • Statement packing: Use the counter or type the number of statements that can be packed into a multiple-statement request (STREAM).

    You can enter a value from 2 to 600.

    This is available only if Statement packing is not selected.

• Additional ODBC connection properties: Type any additional ODBC connection properties, if required.

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.