SAP Connector in Qlik Sense using Standard mode

[Andre_Sostizzo]

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

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

After a successful connection, click the Create button

Step Two

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

Step Three

1. Login to Qlik Sense Management Console (QMC)
2. Click on Data connections
   
   
   
   
3. Select SAP Connection, press Edit button found at the bottom left of the window
   
   
   
   
4. Remove the entry on the Connection string
   
   
   
   
5. Edit the generated connection string from QlikView Desktop
6. 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

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

Step Four

1. Log in or go back to the document created earlier in the Qlik Sense Hub
2. Click on Insert Script from Data connections (left corner of the Editor Script Window)
   
   
   
   
3. 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.
   
   
   
   
4. 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.

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

[prinzchristian]

Hi @Andre_Sostizzo ,

After the upgrade to 2024 November Patch 1, the solution is no longer executable - we get the error that the DDL is not available.

It affects the connectors: Report and Query

Do you have an update for me?

Many thanks and best regards from Germany!

Best regards
Christian

[prinzchristian]

UPDATE - 2024.05 Patch 11: 

I now get the same behavior with the patch to the latest May release! 

Qlik Case Number: 
# 00334265: SAP Connector in Qlik Sense using Standard mode is not working anymore