Setting advanced connection properties
You can set additional properties in the Advanced tab of the Oracle database connection settings.
You can set the following properties:
-
The first time the task runs, no error will be issued and rows with the same Primary Key may be added to the target table.
-
The second time the task runs, the setting will take effect.
-
Any subsequent times the task runs, an error will be generated.
Use direct path full load: Select this to use the OCI direct path protocol for bulk loading Oracle tables. This is the default selection.
This option requires the user specified in the General tab to be granted the LOCK ANY TABLE permission.
Due to an issue with Oracle Direct Path, when this option is selected and If target table already exists is set to Do nothing in the Full Load Settings, the following occurs:
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.