0 ×

SAP Reader (Theobald Software)

StreamableKNIME SAP Integration based on Theobald Xtract Universal version 4.3.2.v202103021016 by KNIME AG, Zurich, Switzerland

This node requires the commercial Xtract Universal Server from Theobald Software to load data from various SAP systems (e.g. SAP S/4HANA, SAP BW, SAP R/3) into a KNIME data table. For a full list of supported SAP systems see the Xtract Universal documentation.

The node utilizes the HTTP interface of the Xtract Universal Server to retrieve the data from all queries with the Web Service-CSV destination.



This tab allows you to specify the general settings such as the connection URL and the query to execute.

The URL to the Xtract Universal Server.
Required when the SAP Connection is setup to Require SAP credentials to be explicitly supplied for execution. For further details see the Theobald Software documentation.
If no user name and password are required.
KNIME Credentials
Use workflow or flow variable credentials.
SAP username and password
Use this to manually input the username and password.
The query to execute on the Xtract Universal Server. The list of available queries is fetched from the server by clicking 'Fetch queries'.


This tab allows you to specify various parameters such as the number of rows to extract, where-clauses or custom parameters. For further information on the available parameters and how to use them please see the Theobald Software documentation.

Fetch Parameters...
Fetches the parameters of the selected query. This needs to be done every time a query has been selected or changed to ensure that all available parameters are present. When fetched, parameters can be added by pressing 'Add'. This will create a new row in which a parameter (key) can be selected in a drop down box. A default value will be provided, but this can be overwritten as needed.
Here you can set the extraction parameters of the query.
Here you can set the source parameters of the query.
Here you can set the custom parameters of the query.


This tab allows you to specify advanced parameters such as the SSL certificate validation options or the connection timeout.

Ignore hostname mismatches
If checked, the node trusts the server's SSL certificate even if it was generated for a different host.
Trust all certificates
If checked, the node trusts all certificates regardless of their origin or expiration date.
Connection Timeout (s)
Timeout for a single request in seconds
CSV Settings
Set these settings to match the global settings of the Xtract Universal Server
The decimal separator


To read a data extraction which contains characters in a different encoding, you can select the character set in this tab (UTF-8, UTF-16, etc.), or specify any other encoding supported by your Java VM. The default value uses the default encoding of the Java VM, which may depend on the locale or the Java property "file.encoding"

Output Ports

SAP query result.

Best Friends (Outgoing)



To use this node in KNIME, install KNIME SAP Integration based on Theobald Xtract Universal from the following update site:


A zipped version of the software site can be downloaded here.

You don't know what to do with this link? Read our NodePit Product and Node Installation Guide that explains you in detail how to install nodes to your KNIME Analytics Platform.

Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform. Browse NodePit from within KNIME, install nodes with just one click and share your workflows with NodePit Space.


You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.