Qlik Replicate Extractor performance parameter

Bill_Steinagle — Wed, 31 Jan 2024 20:32:53 GMT

Qlik Replicate SAP Extractor Endpoint can be tuned to improve the performance of data being processed from an SAP environment. This is achieved by adding an internal parameter: sqlConnector. To confirm the performance improvements of the task, first record the task duration before implementing the parameter, then compare it to the subsequent runs.

Requirements

Before the internal parameter can be added to the Qlik Replicate Extractor Endpoint, the below SAP Transports must be installed:

sqlConnector Transport
H6AK900114 - Data Extractor
E66K900154 - User profile Extractor for the same client

Once the transports have been installed make sure you follow the below steps to set the added Permissions on the SAP Replicate User:

Add the following authorization objects and settings to the RFC user ID:

Do the following:

Import the appropriate data extraction transport into the base client, usually 000. This is client-independent.
Import the appropriate user profile transports into every client where they will be used. This is client-dependent.

For more information on how to import/upgrade the sqlConnector Transport, see Importing the SAP transports.

Configuration

Configure the SAP Extractor Endpoint by defining the useSqlConnector Internal Parameter.

Open the SAP Extractor Endpoint
Switch to the Advanced tab
Click Internal Parameters
Enter '!' in the search bar to list available entries, then scroll to useSqlConnector.

Alternatively, enter the parameter directly.

For more information about Internal Parameters, see Qlik Replicate: How to set Internal Parameters and what are they for?
Set the Internal Parameter as:

Parameter: useSqlConnector
Value: true
Save the Endpoint

article Qlik Replicate Extractor performance parameter in Official Support Articles

Qlik Replicate Extractor performance parameter

Requirements

Configuration

Related Content

Environment