Skip to main content
Close announcements banner

SAP Connector installation

The Qlik connectors for use with SAP NetWeaver are installed using an installation package (.exe) for Windows. The package must be installed on systems running Qlik Sense or QlikView, either an SAP system client computer, or the SAP system server.

Information noteThe SAP SQL connector is not available on Qlik Sense Business.

Objects, roles, and transports

When extracting data, the connectors use Qlik objects in the SAP system to communicate with the client. These objects are stored in:

  • /QTQVC/QTDEV_BW for the BW, BEx, and InfoProvider connectors

  • /QTQVC/QTDEV for all others

All objects are unique and prefixed with the reserved name space /QTQVC/. After the objects have been imported in an SAP system, it is possible to import a deletion transport to remove them.

The SAP user ID needs to have a role assigned that includes authorization objects. The provided roles contain the necessary authorization objects, and can be checked by Qlik objects and by standard SAP objects. Using the provided roles is not mandatory. Roles can be copied or modified, and custom roles containing the necessary authorization objects can be used instead.

Objects (such as ABAP programs, function modules, and dictionary objects) are distributed using data extraction transports, and roles are distributed using user profile transports. The transports are imported into the SAP system using the SAP transport management system.

SAP connector installation on Qlik Sense SaaS

Some Qlik connectors for use with SAP NetWeaver are supported on Qlik Sense SaaS when using a valid Enterprise license. The connectors are installed and updated automatically. However, the transports are not.

Do the following:

  1. Go to the Qlik Download Site.

  2. Select Value Added, and then select Qlik Connector for use with SAP NetWeaver.
  3. Use the Release filters to narrow your list of possible downloads.

  4. Download the transports: [version].SAP.transports.zip

    [version] will be replaced with a number. If you are downloading version 8.7.2 of the transports, the file will be: 872.SAP.transports.zip

Information note

There is an installation guide in PDF format available on Community. It is attached to the release notes. Go to Release Notes, click on Products, and filter on Qlik SAP Connectors. There is also a release notes summary in PDF format attached to the release notes.

Backwards compatibility

When there is a new connector release, the SAP transports should be updated. There is backwards compatibility to the SAP code, so it is possible for a SAP connector to be added, without also installing the corresponding SAP transports.

Warning noteIf you do not update the transports, new SAP functionality dependent on changes in the connector SAP code cannot be used.

The following table shows the current backwards compatibility of the components of the connector package:

SaaS SAP connector backwards compatibility
Connector Client SAP transport (data extraction)
SQL Connector Qlik Sense SaaS December 2019 or later 6.1.2 or later
BW Connector Qlik Sense SaaS February 2021 or later 7.0.6 or later

SAP connector installation on Windows

The Qlik Connector for use with SAP NetWeaver is installed with the QlikSAP_x64Setup.exe, which is the 64-bit (x64) installation package (.exe) for Windows. The package must be installed on systems running Qlik Sense or QlikView, either an SAP system client computer, or the SAP system server.

The installation package must also be installed on all client computers that will use the SAP Connectors. Those computers must also be running Qlik Sense or QlikView.

The transports must be imported on all systems that will use the SAP Connectors. They are a separate package from release 7.0.3 or after. Before release 7.0.3, the transports were installed by the installation package.

Do the following:

  1. Go to the Qlik Download Site.

  2. Select Value Added, and then select Qlik Connector for use with SAP NetWeaver.
  3. Use the Release filters to narrow your list of possible downloads.

  4. Download the following:

    • The installation package: QlikSAP_x64Setup.exe

    • The transports: [version].SAP.transports.zip

      [version] will be replaced with a number. If you are downloading SAP Connector version 8.7.2, the file will be: 872.SAP.transports.zip

For information on installing these files, see:

  1. Installing the connectors

  2. Installing the SAP transports - Windows

Information note

There is an installation guide in PDF format available on Community. It is attached to the release notes. Go to Release Notes, click on Products, and filter on Qlik SAP Connectors. There is also a release notes summary in PDF format attached to the release notes.

Prerequisites

The connectors have the following requirements:

  • Qlik Sense version 3.2 or later
  • QlikView version 11.00 or later

Each of the individual connectors has the following installation requirement:

  • SQL Connector - SAP BASIS system 7.31 - 7.5x
  • Query Connector - SAP BASIS system 7.31 - 7.5x
  • Report Connector - SAP BASIS system 7.31 - 7.5x
  • BEx Connector - SAP BASIS system 7.31 - 7.5x
  • InfoProvider Connector - SAP BASIS system 7.31 - 7.5x
  • OLAP Connector - SAP BW/NetWeaver BI 7.31- 7.5x
  • DSO/ODS Connector -SAP BW/NetWeaver BI 7.31 - 7.5x
  • Extractor Connector - SAP BASIS system 7.31 - 7.5x

    Information noteBW/4HANA systems must be connected via ODP technology. This means that the Extractor connector cannot be used with BW/4HANA systems.
  • BAPI Connector - SAP BASIS system 7.31 - 7.5x
Information note If there is a firewall between the connector and the SAP system, port 33nn has to be open. nn = system number of the SAP system.

Backwards compatibility

As a general rule, all components are recompiled for new releases. It is recommended that you always update both the SAP and Windows systems. There is backward compatibility to the SAP code, so it is possible to install the new release of the connector on Windows without installing the corresponding SAP transports. In that case, however, new functionality and bug fixes that are dependent on changes in the SAP code cannot be used.

The SAP code component of the connector software is backwards compatible to release 5.80 SR2 of the connector software. This means that you can install the Windows part of the connectors for a new release without installing the corresponding SAP transports.

Warning noteIf you do not update the transports, new SAP functionality dependent on changes in the connector SAP code cannot be used.

The BEx Connector and the SQL Connector are based on a new framework on the Windows side. For these connectors, the backwards compatibility will start with the connector SAP code of release 6.3.0.

The following table shows the current backwards compatibility of the components of the connector package:

SAP Connector backwards compatibility

Connectors

Windows files

SAP transport (data extraction)

SQL

8.0.1

6.1.2 or later

Bex

8.0.1

7.0.5 or later

SAP Query

8.0.1

5.80 SR2 or later

Report

8.0.1

5.80 SR2 or later

Extractor

8.0.1

5.80 SR2 or later

BAPI

8.0.1

5.80 SR2 or later

InfoProvider

8.0.1

6.5.0 or later

BW

8.0.1

7.0.6 or later

SAP Connector backwards compatibility
Connectors Windows files SAP transport (data extraction)
SQL Connector 8.0.0 6.1.2 or later
SAP Query Connector 8.0.0 5.80 SR2 or later
Report Connector 8.0.0 5.80 SR2 or later
Extractor Connector 8.0.0 5.80 SR2 or later
BAPI Connector 8.0.0 5.80 SR2 or later
BW Connector 8.0.0 7.0.6 or later
BEx Connector 8.0.0 7.0.5 or later
InfoProvider Connector 8.0.0 6.5.0 or later
SAP Connector backwards compatibility
Connectors Windows files SAP transport (data extraction)
SQL Connector 7.0.3/7.0.4 6.1.2 or later
BEx Connector 7.0.3/7.0.4 6.1.2 or later
InfoProvider Connector 7.0.3/7.0.4 6.5.0 or later
Query Connector 7.0.3/7.0.4 5.80 SR2 or later
Report Connector 7.0.3/7.0.4 5.80 SR2 or later
Extractor Connector 7.0.3/7.0.4 5.80 SR2 or later
BAPI Connector 7.0.3/7.0.4 5.80 SR2 or later*
SAP Connector backwards compatibility
Connectors Windows files SAP transport (data extraction)
SQL Connector 7.0.2 6.1.1 or later
BEx Connector 7.0.2 6.1.2 or later
InfoProvider Connector 7.0.2 6.5.0 or later
Query Connector 7.0.2 5.80 SR2 or later
Report Connector 7.0.2 5.80 SR2 or later
Extractor Connector 7.0.2 5.80 SR2 or later
BAPI Connector 7.0.2 5.80 SR2 or later*