Qlik Replicate Extractor performance parameter

[Bill_Steinagle]

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:

1. Import the appropriate data extraction transport into the base client, usually 000. This is client-independent.
2. 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.

1. Open the SAP Extractor Endpoint
2. Switch to the Advanced tab
3. Click Internal Parameters
4. 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?
   
   
5. Set the Internal Parameter as:
   
   Parameter: useSqlConnector
   Value: true
   
   
6. Save the Endpoint

Related Content 

SAP Transports
Importing the SAP transports

Environment

Qlik Replicate