SAP Connector in Qlik Sense using Standard mode

Andre_Sostizzo · Feb 17, 2025 4:28:40 AM

This document explains how to manually setup custom connectors within Qlik Sense with Standard mode without legacy mode. More info can be found in Legacy vs. Standard Mode in Qlik Sense: Explainer and Security Considerations

Pre-requisites

QlikView Desktop Client where SAP Connectors has been installed
Qlik Sense Server installed and working perfectly
Granted permission to copy files

After installing Qlik SAP Connectors on a Qlik Sense Enterprise Server, some connectors like Qlik SAP Report Connector, Qlik SAP Query Connector..., are not automatically installed. Thus, when migrating from a "QlikView environment" to "Qlik Sense Enterprise", those specific connectors need to be manually set in Qlik Sense.

Step One

Login to Qlik Sense Hub
Create a new app
Name the Application, then click Create button
Click Open app button
Click on Data Load editor
Click on Create New Connection button
Click on OLE DB
Select OLE DB Provider for Microsoft Directory Service
Named the Data source as for example Dummy DataSource Connection. Choose the default selection, Specific user name and password
Put a name for the Connection, for instance, SAP Connection
Click Test connection button. Test must be successful similar to screenshot below

After a successful connection, click the Create button

Create connection.png

Step Two

Open QlikView Desktop Client
Generate a connection string for this example QvSAPQueryConnector
CUSTOM CONNECT TO "Provider=QvSAPQueryConnector.dll;ASHOST=xx.xx.xxx.xx;SYSNR=00;CLIENT=000;XUserId=xxxxxxxxxxxxx;XPassword=xxxxxxxxxxx;";

Step Three

Login to Qlik Sense Management Console (QMC)
Click on Data connections
Select SAP Connection, press Edit button found at the bottom left of the window
Remove the entry on the Connection string
Edit the generated connection string from QlikView Desktop
Remove the XUserID and XPassword parameter on the connection string

It should look like:

CUSTOM CONNECT TO "Provider=C:\Program Files\Common Files\QlikTech\Custom Data\QvSAPConnector\QvSAPQueryConnector.dll;ASHOST=xx.xx.xxx.xx;SYSNR=00;CLIENT=000;";

Note the use of the full path to the DLL: "C:\Program Files\Common Files\QlikTech\Custom Data\QvSAPConnector"

Step Four

In the QMC, now paste the revised connection string to the Connection string field

image step10.png

Provide the SAP user credential (UserID / Password), then click Apply button

Step Four

Log in or go back to the document created earlier in the Qlik Sense Hub
Click on Insert Script from Data connections (left corner of the Editor Script Window)
Then, finally copy and paste the Load script generated in QlikView Desktop to the Qlik Sense Editor window. Note that, in this scenario, you need to copy scripts from QlikView and not generate scripts using Qlik sense editor/select data.
Save the application and press the Load data button

Optional Steps

With the latest QlikView and Qlik SAP Connector versions, you don't need to perform this step.

Login to the machine which has QlikView Desktop Client
Copy all the folders (by default) under C:\Program Files\Common Files\QlikTech\Custom Data\
Login to the Qlik Sense server
Copy over the folders earlier (by default) to C:\Program Files\Common Files\Qlik\Custom Data
Restart all Qlik Sense services