Setting advanced connection properties

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

• Max file size (MB): Select or type the maximum size of any CSV file used to transfer data to Amazon Redshift. The default value is 1024.
• Number of threads used to upload a file: Select the number of threads used to upload a single file. The minimum number of threads is 1. The maximum value is 64. The default value is 10.
• ODBC driver: The name of the default ODBC driver you are using to connect to Amazon Redshift. The default value is Amazon Redshift (x64).
• Additional ODBC connection properties: Type any additional ODBC connection properties if required.

• Maximum number of files to copy per batch: If you encounter performance issues, try adjusting this number. The default value is 8.

  Note that increasing the number may not necessarily improve performance and may even degrade it. This is because increasing the number of files also increase the load on the server machine, which may degrade performance (depending on the hardware).

• Use proxy server - Select this option to connect via a proxy server, and then provide the proxy connection settings:
• Proxy connection: Choose one of the following:
  • Use endpoint proxy setting: Choose this option to use the proxy settings defined for this endpoint.
  • Use default proxy settings: Choose this option to use the default proxy settings defined for all endpoints. The default settings are defined in the Replicate server settings' Default Proxy Server tab.
• 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 the proxy server.

• Password: The password for the proxy server.

• Scheme: Select which protocol to use to access the proxy server (HTTP or HTTPS). In order to use HTTPS, you must first install the CA certificate that signed the proxy server's certificate on the Replicate Server machine. Do this as follows:

  Windows

  Add the CA certificate to the Trusted Root Certification Authorities store of Local Computer

  Linux

  Add the CA certificate to /etc/pki/tls/certs/ca-bundle.crt

  • CA Path: Only relevant when the IAM Roles Anywhere access option is selected. The path to the CA certificate that signed the proxy server's certificate.

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.