Setting advanced properties
In the Advanced tab, you can set the following parameters:
-
Subscriber type - Choose one of the following:
- SAP NetWeaver Business Warehouse - This is the default ODP subscriber type.
- RODPS_REPL_TEST - Used mainly for testing and is not recommended to use for production.
- Others - This will expose the field Other subscriber type, where you can specify a subscriber type that is not listed.
-
Subscriber name - Specify the subscriber name. This will be the name shown in SAP for all subscriptions opened by this endpoint connection.
-
ODP context - Choose one of the following:
- ABAP Core Data Services (CDS) views - The context of the CDS views. This is the default ODP context.
- SAP NetWeaver Business Warehouse - The context of the BW objects.
- SAP DataSources/Extractors - The context of the data sources and extractors.
- SAP HANA Information Views - The context of the HANA views.
-
SAP LT Replication (SLT) - Required to work with a SAP Landscape Transformation Replication Server.
See also: Setting up SLT on SAP
- SLT alias - This field is only visible when the ODP context is set to SAP LT Replication (SLT). Specify the SLT alias as defined in the configuration created in Setting up SLT on SAP
-
Delta extraction interval - Defines how frequently the deltas are extracted from your system.
- The default value is 60 minutes.
- Setting the value to 0 means that all the datasets of the task will run only one delta/initial load and then the task will stop automatically.
- Max package size - The size of the data package in bytes. This value can be adjusted according to your network and system capabilities.
Delta processing settings
- Delta processing mode - Select one of the following:
- History data - This is the default mode. When this mode is selected, all data will be applied as INSERTS, thereby preserving previous record versions. When working in this mode, the following options are also available:
- Apply original primary key - Retrieve the primary key settings from the ODP metadata.
- Reverse summable fields - Reverse the values of summable fields. Before-image values have reversed signs. Enabling this setting will restore the sign to its prior state and recalculate the original value.
Current data - When this mode is selected, the actual change operation (INSERT, UPDATE, or DELETE) will be performed on the target.
Information note- Changes operations are determined by the ODP source. Some operations might not be supported on the target.
- We recommend manually setting a Primary Key for those ODP sources that are not set up to use the default Primary Key.
Some UPDATEs are received as INSERTs. Therefore, to prevent conflicts on the target, set the Duplicate key when applying an INSERT Apply Conflicts handling policy to UPDATE the existing target record.
For more information on this setting, see Apply Conflicts.
- History data - This is the default mode. When this mode is selected, all data will be applied as INSERTS, thereby preserving previous record versions. When working in this mode, the following options are also available:
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.