Setting advanced options
In the Advanced tab, the following options are available.
| Option | Description |
|---|---|
|
File preprocessing command |
The source file must be in delimited text format. If your source files (Full Load and/or Change Files) are not in delimited text format, you can use your own program to convert them to the required format. Before the Full Load task starts, the program will be executed on Location of full load data file(s). Then, during Change Processing, it will be executed on the files specified in the Change File location. The command should be specified as in the following example:
Information note
The path is only necessary if the conversion program’s location is not defined in the "Path" system variable For a detailed explanation, see Setting up a File Pre-processing Command. |
|
Check for changes every |
Specify how often to check the Change Files for updates. |
|
Change Processing Cleanup |
Select one of the following cleanup options to determine what Replicate should do with the processed Change Files/Reference Files:
|
Setting up a File Pre-processing Command
Your program will be executed on each of the input files, and should accept the following parameters:
- The location of the input file(s) (as specified in the Location of full load data file(s) and/or the Change File location)
-
The full path of the output file
The output file(s) will be written to the following location:
PRODUCT_INSTALLATION\data\tasks\TASK_NAME\trans_files\OUTPUT_FILE_NAME(s)Where
OUTPUT_FILE_NAME(s)are determined by your program.
Example:
Let's assume the following:
-
The following files reside in the Location of full load data file(s):
c:\temp\fl\table1.csv,c:\temp\fl\table2.csv
-
The following files reside in the Change File location:
c:\temp\cdc\table1.txtc:\temp\cdc\table2.txt -
The following program is specified in the File preprocessing command field:
c:\temp\convertfile.exe - Both the Full Load and Apply Changes replication options are enabled.
In such a scenario, Replicate will execute the following commands in sequence:
Before Full Load Starts:
c:\temp\convertfile.exe c:\temp\fl\table1.csv <PRODUCT_INSTALLATION>\data\tasks\TASK_NAME\trans_files\table1.csv
c:\temp\convertfile.exe c:\temp\fl\table2.csv <PRODUCT_INSTALLATION>\data\tasks\TASK_NAME\trans_files\table2.csv
During Change Processing:
c:\temp\convertfile.exe c:\tempcdc\table1.txt <PRODUCT_INSTALLATION>\data\tasks\TASK_NAME\trans_files\table1.txt
c:\temp\convertfile.exe c:\tempcdc\table2.txt <PRODUCT_INSTALLATION>\data\tasks\TASK_NAME\trans_files\table2.txt
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:
-
Click the Internal Parameters link.
The Internal Parameters dialog box opens.
- In the edit box, type the name of the parameter you need to add and then click it.
- The parameter is added to the table below the search box with its default value.
- Change the default value as required.
- 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.