Setting advanced connection properties

In the Advanced tab, you can enable the creation of reference files and set post-processing actions. These options are described below.

Post-upload processing

Run command after upload - You can process the final target files using a custom command. The command will be run whenever a data file is created.

• Command name - The location of the command e.g. C:\utils\move.exe.

• Working directory - The directory where you want the command to run.

• Parameters - Specify any parameters that need to be passed to the command during runtime. You can use the following built-in parameters:

  ${FILENAME} - The full path to the CSV file containing the full load or CDC data.

  ${METADATA_FILENAME} - The full path to the DFM file containing the metadata.

  For information on creating metadata files, see Setting general connection properties.

  Information note

  • If the CSV/DFM file paths contain spaces, you must enclose these parameters with quotation marks (e.g "${FILENAME}").
  • The post-processing command must return a proper exit code. For information on the available exit code options, see Exit codes for the post-processing command.

Generate Reference Files - Select this option to generate a Reference File (on Replicate Server) containing the full path to the Apply Changes data files.

Reference File(s) folder - The folder on the Replicate machine in which the Reference File will be created.

Example:

c:\temp\

Exit codes for the post-processing command

The post-processing command must return a proper exit code. You can either use the standard exit code values described below or set a custom exit code value as described in Setting Post Command exit codes with an internal parameter below.

Standard Post Command exit codes

• 0 - Success
• 1 - Recoverable error. The task will recover from the point of failure according to the settings in the Environmental errors tab.
• 2 - Table error. If a table error occurs, Replicate will handle the error according to the settings in the Table Errors tab.
• 3 (or any other value e.g. -100) - Fatal error. The task will fail and not attempt recovery.

Setting Post Command Exit Codes with an Internal Parameter

You can use internal parameters to set exit codes with custom values. This is especially useful if your application already uses the standard exit code values.

See Standard Post Command exit codes above for a description of the exit codes.

• successExitCode
• recoverableErrorExitCode
• tableErrorExitCode
• fatalErrorExitCode

Proxy server

Use proxy server - Select this option to access Amazon S3 via a proxy server.

• 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 accessing the proxy server.
• Password - The password for accessing 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 and should only be used 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 setting by clicking the View Setting Summary link. This is useful if you need to send a summary of your setting to Qlik Support.