SAP Reader (Theobald Software)

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"

Views

This node has no views

Workflows

• 14_Theobald_meets_SAP_HANAKNIME Hub
• 14_Theobald_meets_SAP_HANAKNIME Hub

Links

• SAP CONNECT ERRORby AnotherFraudUser on 2021-10-17

  forum.knime.com/p/137135

Developers