SAP Reader (Theobald Software)

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.

Notice: Please make sure to use YYYY-MM-DD as extraction format for date fields and HH:MM:SS for time fields. Please see the Xtract Universal documentation for further details.

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 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 Xtract Universal 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.
Kerberos
Use an existing Kerberos ticket.
Query
The query to execute on the 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 Xtract Universal 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 (user-defined) 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 CSV settings of the CSV destination in your Xtract Universal Server.
Convert
The decimal separator as specified in the Convert/Encoding section of the CSV destination in your Xtract Universal Server.
Notice: Please make sure to use YYYY-MM-DD as extraction format for date fields and HH:MM:SS for time fields. For further details please see the Xtract Universal documentation.

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"

Input Ports

This node has no input ports

Output Ports

Icon
SAP query result.

Views

This node has no views

Workflows

Links

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.