Setting advanced connection properties

The table below describes the settings in the Advanced tab.

File format

If your cluster type is SQL Warehouse, then select either Parquet (the default) or CSV.

If your cluster type is All-purpose, then select either Text (the default), Parquet or Sequence.

See information on setting the cluster type, see Setting general connection properties.

File attributes

• Maximum file size: Specify the maximum file size of each target file. When the data reaches the maximum size, the file will be closed and written to the specified target folder.
• Compress files using: Select the compression method to use in the selected storage.

Change processing

Apply/Store changes when:

• File size reaches: Specify the minimum size of the data required to create a file in idle state.
• Elapsed time reaches: Specify the maximum time to wait before applying the changes in idle state.

Proxy Server

• Use proxy server - Select this option to connect via a proxy server, and then provide the proxy connection settings:

• Choose Connect via proxy server to options according to which resources you want to access via a proxy server:

  • Database (via ODBC)

  • Cloud storage

    Information note

    When the Cloud storage option is selected and the storage type is either Google Cloud Storage or Microsoft Azure Data Lake Storage (ADLS) Gen2, proxy authentication is not supported.

  • Azure Active Directory

    Information noteOnly available when Microsoft Azure Data Lake Storage (ADLS) Gen2 is the selected storage type. When Azure Active Directory is selected, proxy authentication is not supported.
• 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’s certificate on the Replicate Server machine. Do this as follows:

  • On Windows: Add the CA certificate to the Trusted Root Certification Authorities store of Local Computer
  • On Linux: Add the CA certificate to /etc/pki/tls/certs/ca-bundle.crt
  Information note

  The HTTPS scheme is only supported when both the Amazon S3 storage type and the Cloud storage proxy option (only) are selected.

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.