0 ×

SAP Reader (Theobald)

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

This node requires the commercial Theobald Xtract Universal Server 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.

Options

Settings

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

URL: The URL to the Theobald Xtract Universal Server.
Authentication: Required when the SAP Connection is setup to Require SAP credentials to be explicitly supplied for execution. For further details see the Theobald documentation.
None
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.
Query: The query to execute on the Theobald Xtract Universal Server. The list of available queries is fetched from the server by clicking 'Fetch queries'.

Parameters

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 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.
Extraction: Here you can set the extraction parameters of the query.
Source: Here you can set the source parameters of the query.
Custom: Here you can set the custom parameters of the query.

Advanced

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 Theobald Xtract Universal Server
Convert: The decimal separator

Encoding

Encoding: 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)

~~CSV Writer~~ (50 %) StreamableDeprecated
Table Writer (50 %)

Workflows

14_Theobald_meets_SAP_HANA (KNIME Hub)
14_Theobald_meets_SAP_HANA (KNIME Hub)

Installation

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

KNIME 4.3

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.

Developers

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.