Setting advanced connection properties

In the Advanced tab, you can set the following properties:

• Use BCP for loading tables: Select this to transfer data for full-load operations using BCP.

  Information note

  When the target table contains an identity column that does not exist in the source table, you must disable the Use BCP for loading tables option.

• BCP packet size: The maximum size of the packets (in bytes) used to transfer data using BCP.

• File group for Qlik Replicate internal tables: Optionally, specify a filegroup for the Qlik Replicate internal tables. When the replication task starts, all of the internal Qlik Replicatecontrol tables will be created in the specified filegroup.

  The following is an example of a command for creating a filegroup:

  ALTER database replicate

  ADD FILEGROUP Test1FG1;

  GO

  ALTER database replicate

  ADD FILE

  (

  NAME = test1dat5,

  FILENAME = 'C:\temp\DATA\t1dat5.ndf',

  SIZE = 5MB,

  MAXSIZE = 100MB,

  FILEGROWTH = 5MB

  )

  TO FILEGROUP Test1FG1;

  GO

 

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.