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.
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
Theobald Software 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 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 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.
- 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 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
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:
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.
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.