How to upgrade the Qlik SAP connector

[Sonja_Bauernfeind]

For general installation instructions and backwards compatibility information, see SAP Connector installation.

Qlik SAP Connector versions 8.0.1 or earlier include the SAP libraries.

Qlik SAP Connector versions 8.0.2 and later do not include the SAP libraries. You can download the SAP libraries from the SAP support download portal in accordance with SAP regulations after the upgrade of the Connector was performed. The Connector can be upgraded without issues first.

Index:

• Qlik SAP Extractor Connector
• Not using Qlik SAP Extractor Connector:
• Downloading and installing the SAP Libraries for connector 8.0.2 or later:

 

Qlik SAP Extractor Connector

Step 1:

For the SAP Extractor connector, follow the below steps before upgrading:

1. Open Services.MSC, find Qlik SAP Network Service, and then click "Stop."
2. Open cmd as an administrator and change the directory to C:\Program Files\Common Files\QlikTech\Custom Data\QvSAPConnector 
3. Run the SrvService Console.bat file.
4. Choose the option to uninstall the Qlik SAP Network Service. 

Step 2:

Once the service has been uninstalled, please proceed as follows:

1. Uninstall the SAP connector.
2. Install the new version SAP connector.

Step 3:

After installing the updated version of the Sap connector, follow the steps below to install the Qlik SAP extractor connector service "Qlik SAP Network Service."

1. Open cmd as an administrator and change the directory to C:\Program Files\Common Files\QlikTech\Custom Data\QvSAPConnector 
2. Run the SrvService_Console.bat file.
3. Choose option 2 to install the Qlik SAP Network Service. 
4. Open Services.MSC, find Qlik SAP Network Service, and then click "Start."

Note: Restart all the Qlik Sense Services if the installation is on a Qlik Sense system. The SAP Connector is not available in Qlik Sense until all the services are restarted.

Not using Qlik SAP Extractor Connector:

Examples: SQL, Bex, Info provider, Report, BW etc.

Once the service has been uninstalled, please proceed as follows:

1. Uninstall the SAP connector.
2. Install the new version SAP connector.

Downloading and installing the SAP Libraries for connector 8.0.2 or later:

The "SAP Connector for Microsoft.NET" and "SAP NW RFC SDK" versions will change for each connector upgrade based on SAP security patch releases, refer to the help page for additional information. Installing the connectors - Windows

1. Log into the SAP Support Portal with an S-user ID.
   
   
2. Go to SAP Connector for Microsoft .NET and search for: SAP Connector for Microsoft .NET, 64-bit, version 3.1 or later. This library is used by the Connectors with file extension .exe and contains sapnco.dll and sapnco_utils.dll.

3. Download these library files. Double-click the SapNCox64Setup.exe file. The installation wizard starts, and the files are installed in Global Assembly Cache (GAC).

4. Go back to the SAP Support Portal and search for: SAP NW RFC SDK, 64-bit, version 7.50 or later. This library is used by the legacy connectors with file extension .dll.

5. Download and unzip the library. The library contains all required files.
   • icudt50.dll
   • icuin50.dll
   • icuuc50.dll
   • libsapucum.dll
   • sapnwrfc.dll
     
     
6. Place the files in this folder: C:\Program Files\Common Files\QlikTech\externals

[Brysonds]

Does this impact any of the apps that are using the SAP connector? (i.e. will the connection string need to be updated in the load editor, or anything like that?)

[Sonja_Bauernfeind]

@Brysonds Existing apps will not be affected. The connection strings remain the same. 

[rakeshshah]

Hi Sonja, Thank you for the instructions, I've followed these steps and the Connectors are still not appearing in the list. Are there any other troubleshooting steps that I can do?

Thanks

Rakesh

[Sonja_Bauernfeind]

Hello @rakeshshah

Let me find out for you!

All the best,
Sonja

[Sonja_Bauernfeind]

Hello @rakeshshah

I've spoken to our subject matter expert and he recommended logging a case for troubleshooting, as it will require direct assistance.

All the best,
Sonja

[rakeshshah]

cheers

[Ciri]

Thanks this post.

I think,

4. Choose option 3 to uninstall the Qlik SAP Network Service. 

is wrong. 

It should be,

"4. Choose option 5 to uninstall the Qlik SAP Network Service. "

FYI.

[Sonja_Bauernfeind]

Thank you for your input, @Ciri 

I have removed the numbered option to make sure we are compatible with any changes in the GUI and instead focused on what the option would be called.

All the best,
Sonja 

[LDR]

Hi @Sonja_Bauernfeind 

Do you know if after uninstalling the old SAP Connector and installing the new one (8.0.2) I'll have to license the connector again?

Thanks 

[SankarReddyK]

Hi @LDR , This folder, C:\ProgramData\QlikTech\Custom Data\QvSAPConnector, contains the connector LEF.
You do not need to re-register if you are not making any changes.