Qlik Connector for use with SAP NetWeaver

The Qlik Connector for use with SAP NetWeaver provides a means for the Qlik Sense and QlikView data discovery platforms to efficiently load data into a Qlik Sense or QlikView app from SAP NetWeaver. The information may be stored in a number of different repositories within the SAP architecture, be that in an SAP BI/BW, an SAP ERP, or CRM system.

To access data, the user must have an SAP NetWeaver account with current access credentials. Once a connection to an SAP NetWeaver account has been created, data can be selected from tables available to the user’s account and then loaded into an app where it can be used in visualizations.

What's new in this version

For a complete history of changes through all versions, see Version history.

7.0.1

Version 7.0.1 adds CDS view select to the SAP SQL Connector. See the section on SQL CDSSELECT syntax in Using the SAP SQL Connector. Version 7.0.1 also requires transport updates. See Installing the SAP transports.

Version 7.0 provides additional functionality for the SAP InfoProvider Connector:

  • Extended functionality in systems with SAP BASIS 740 and later (with HANA). The InfoProvider Connector now supports data extraction from
    • DataStore Object (Advance) (ADSO)

    • CompositeProvider (HCPR)
    • Open ODS View (FBPA)

    It is also possible to load the InfoObject Text and Attribute data associated with an InfoProvider.

  • The handling of Data Types in the InfoProvider Connector has changed to improve the data interpretation in Qlik and to better resemble the Data Types in SAP. This will affect the display of fields with the type Date, Time, and Decimal Numbers, which are now handled according to the data type they are set to in SAP. This could affect association to fields from other sources in Qlik, or if Date and Time functions are used in the load script. It is therefore recommended that you review existing scripts for possible implications before upgrading the connector.

  • The Qlik role QTQVCBWACCESS has been extended to allow extraction of the new InfoProvider types. The authorization objects S_ADMI_FCD and S_RS_ADSO are new. As always, Qlik roles are suggestions. The roles can be modified according to customer needs.

Version 7.0 provides additional functionality for the SAP BAPI Connector:

  • Qlik Sense it is now possible to enter language in the GUI. A BAPI is created with a language code. To be able to lookup a BAPI, the correct language code must be entered. If no language code is entered, the connector uses the following priority to decide which language to use:

    1. SAP user default logon language, if set.

    2. System language
    3. If no language can be found, then English.

    To lookup BAPI’s in all available language codes, enter ‘ALL’ as language.

    This functionality is only valid for the lookup function. It is always possible to enter a name of a BAPI in any language directly in the script.

The additional functionality requires that the SAP transports be updated.

In version 7.0, the connectors available in Qlik Sense are:

  • SAP Extractor Connector
  • SAP BAPI Connector
  • SAP SQL Connector
  • SAP BEx Connector
  • SAP InfoProvider Connector

Qlik Sense compatibility

Connector version Qlik Sense versions
7.0 November 2018, September 2018, June, 2018, April 2018, February 2018, November 2017, September 2017, June 2017, 3.2
6.6 November 2017, September 2017, June 2017, 3.1, 3.0
6.5 November 2017, September 2017, June 2017, 3.1, 3.0
6.4 3.1, 3.0, 2.2, 2.1, 2.0
6.3 2.1, 2.0
6.2 2.0
6.1 2.0

QlikView compatibility

Connector version QlikView versions
7.0 November 2018, November 2017, 12.10, 12.00, 11.00
6.6 November 2017, 12.10, 12.00, 11.00
6.5 12.10, 12.00, 11.00
6.4 12.10, 12.00, 11.00
6.3 12.00, 11.00
6.2 12.00, 11.00
6.1 12.00, 11.00

Version history

6.6

In version 6.6, the connectors available in Qlik Sense are:

  • SAP Extractor Connector
  • SAP BAPI Connector
  • SAP SQL Connector
  • SAP BEx Connector
  • SAP InfoProvider Connector

The following features and improvements are included in version 6.6 of the SAP Connectors:

  • SAP BAPI Connector is supported in Qlik Sense for the first time in version 6.6.
    • If a BAPI has multiple output, the connector now can handle that in one execution.
    • It is now possible to call a BAPI that has no output.

    • The new connector GUI has an improved search functionality to find a BAPI. It is now possible to enter a search string (can contain one or more * as wildcard) which will return all BAPI modules where the search string is part of the BAPI name or description. (Requires SAP transport update).

  • In the SAP BEx Connector, text fields for all selected dimensions are now added when adding data.
  • The SAP Extractor Connector has two new connection string properties: ReplaceNullValue and ReplaceNullValueChar. If ReplaceNullValue=true (default) and there are null values in the data, they are replaced with blank spaces. Set ReplaceNullValueChar=’x’ to replace null values with a character other than blank space. It is necessary to replace null values in the data, otherwise the connector will fail.
  • The Qlik Network Server has a redesigned logging functionality. It is now possible to change log levels during runtime and to capture meta data and data rows (for TRFC method only).

6.5

In version 6.5, the connectors available in Qlik Sense are:

  • SAP Extractor Connector
  • SAP SQL Connector
  • SAP BEx Connector
  • SAP InfoProvider Connector

The following features and improvements are included in version 6.5 of the SAP Connectors:

  • SAP Extractor Connector is supported in Qlik Sense for the first time in version 6.5.

6.4

In version 6.4, the connectors available in Qlik Sense are:

  • SAP SQL Connector
  • SAP BEx Connector
  • SAP InfoProvider Connector

The following features and improvements are included in version 6.4 of the SAP Connectors:

  • SAP InfoProvider Connector connects to two SAP InfoProviders:
    • InfoCube
    • MultiProvider

6.3

In version 6.3, the connectors available in Qlik Sense are:

  • SAP SQL Connector
  • SAP BEx Connector

The following features and improvements are included in version 6.3 of the SAP Connectors:

  • The BEx Connector is now available in Qlik Sense.
  • New functionality to delete records for the Qlik database tables in the background. This functionality is useful for deleting large numbers of records.
  • The BEx Connector performs a consistency check when a query is performed.

    If the query contains errors, an error message is displayed.

    The BEx Connector also performs this check during a reload, before the query is extracted, to avoid a dump in SAP.

  • The BEx Connector performs a validity check for each Characteristic Value used.
  • The SAP Extractor Connector cancels an SAP extraction job when the corresponding connector job is aborted.

  • An error occurs when more than one Service points to the same SAP system.

6.2

In version 6.2 the only connector available in Qlik Sense is the SAP SQL Connector.

The following features and improvements are included in version 6.2 of the SAP Connector:

  • New ‘wideselect’ functionality. SAP database fields with a column width exceeding 800 characters cannot be extracted by the current SQL Connector. With the ‘wideselect’ functionality there is no limitation to column width. It is possible to extract one wide field column at a time together with a number of associated key fields.

    For the Extractor Connector there is a new optional parameter “SocketTimeout”, used to fine tune the timeout triggered by the first connection to the Qlik SAP Network Server. Default value is 900 (seconds). The parameter can be added to the connection string. (Example: SocketTimeout=500).

    Variables maintained in the Default Values section in BEx Query Designer are now available in the variables section in the BEx Connector select window.

  • The backwards compatibility of both the SQL and BEx Connectors has changed.

6.1

Version 6.1 of the Qlik Connectorfor use withSAP NetWeaver is the first version to support Qlik Sense.

In this version the only connector available is the SAP SQL Connector.

The following features and improvements are included in version 6.1 of the SAP Connector:

  • It is now possible to decide how many buffers of data to fetch from SAP. The parameter FetchBuffers is used and can be combined with the parameter PacketSize to decide how many rows there should be in each buffer. To fetch one buffer with 100 rows, set the parameters as follows:

  • FetchBuffers=1

    PacketSize=100

  • The backwards compatibility of both the SQL and BEx Connectors has changed.
  • The field width limit for the SQL Connector has been increased from 800 characters to 8192.
  • The path to the log and the name of the log are now fixed and cannot be changed.
  • New ‘wideselect’ functionality. SAP database fields with a column width exceeding 800 characters cannot be extracted by the current SQL Connector. With the ‘wideselect’ functionality there is no limitation to column width. It is possible to extract one wide field column at a time together with a number of associated key fields.

    For the Extractor connector there is a new optional parameter “SocketTimeout”, used to fine tune the timeout triggered by the first connection to the Qlik SAP Network Server. Default value is 900 (seconds). The parameter can be added to the connection string. (Example: SocketTimeout=500).

    Variables maintained in the Default Values section in BEx Query Designer are now available in the variables section in the BEx Connector select window.