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 KNIME destination.

For further details on how to configure Xtract Universal please see the documentation.

Options

URL
The URL to the Xtract Universal Server.
Authentication
Method for authentication
  • Credentials: Use credentials via flow variable.
  • Username and password: Use this to manually input the username and password.
  • Kerberos: Use an existing Kerberos ticket. For more information, see the KNIME Kerberos User Guide.
  • None: If no user name and password are required.
SAP username and password
Enter your SAP username and password to authenticate with the Xtract Universal Server.
Use credentials
Use credentials from a flow variable for authentication.
Query
The query to execute on the Xtract Universal Server. The list of available queries with the KNIME destination is fetched from the server by clicking 'Fetch queries'.
Fetch queries
Fetches the list of available queries with the KNIME destination from the Xtract Universal Server. The list of available queries will be cached for 10 minutes. Subsequent fetches will refresh the cache.
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.
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, though the results will be cached for 10 minutes for each node. Subsequent fetches will refresh the cache. Once fetched, parameters can be added by pressing 'Add parameter'. For further information on the available parameters and how to use them please see the Xtract Universal documentation.
Extraction parameters
Here you can set the extraction parameters of the query.
  • Key: Select a parameter name from the available options. Use the 'Fetch parameters' button to populate the list of available parameters.
  • Value: The value to assign to the parameter. A default value is provided when the parameter is added, but this can be overwritten as needed.
Source parameters
Here you can set the source parameters of the query.
  • Key: Select a parameter name from the available options. Use the 'Fetch parameters' button to populate the list of available parameters.
  • Value: The value to assign to the parameter. A default value is provided when the parameter is added, but this can be overwritten as needed.
Custom parameters
Here you can set the custom (user-defined) parameters of the query. For more information, see the Xtract Universal documentation.
  • Key: Select a parameter name from the available options. Use the 'Fetch parameters' button to populate the list of available parameters.
  • Value: The value to assign to the parameter. A default value is provided when the parameter is added, but this can be overwritten as needed.

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.