KNIME

This page shows how to set up and use the KNIME destination. The KNIME destination loads data to KNIME.

Create a new KNIME Destination

Follow the steps below to add a new KNIME destination to Xtract Universal:

In the main window of the Designer, navigate to Server > Manage Destinations. The window “Manage Destinations” opens.
Click [Add] to create a new destination. The window "Destination Details" opens.
Enter a Name for the destination.
Select the destination type KNIME from the drop-down menu. A list of connection details opens.
Fill out the destination details to connect to the destination.
Click [OK] to confirm your input.

The destination can now be assigned to extractions.

Destination Details

The destination details define the connection to the destination. To use the KNIME destination, no further settings are necessary.

Destination-Details

Assign the KNIME Destination to an Extraction

Extractions write data to their assigned destination. Follow the steps below to assign a destination to an extraction:

In the main window of the Designer, select an extraction.
Click [ Destination]. The window “Destination Settings” opens.
In the “Destination Settings” window, select a destination from the drop down menu.
Optional: edit the destination settings.
Click [OK] to confirm your input.

When running the extraction, the extracted SAP data is now written to the destination.

Destination Settings

The destination settings only affect the extraction type that the destination is assigned to. To open the destination settings, select an extraction in the main window of the Designer and click [ Destination]. The window "Destination Settings" opens.

Destination-settings

Column Name Style

Defines the style of the column name. Following options are available:

column_name_style_options

Option	Description
Code	The SAP technical column name is used as column name in the destination e.g., MAKTX.
PrefixedCode	The SAP technical column name is prefixed by SAP object name and the tilde character e.g., MAKT~MAKTX
CodeAndText	The SAP technical column name and the SAP description separated by an underscore are used as column name in the destination e.g., MAKTX_Material Description (Short Text).
TextAndCode	The SAP description and the SAP technical column name description separated by an underscore are used as column name in the destination e.g., Material Description (Short Text)_MAKTX.
Text	The SAP description is used as column name in the destination e.g., Material Description (Short Text).

Convert dates

Converts the character-type SAP date (YYYYMMDD, e.g., 19900101) to a special date format (YYYY-MM-DD, e.g., 1990-01-01). Target data uses a real date data-type and not the string data-type to store dates.

Year 0

Converts the SAP date 00000000 to the entered value.

Year 9999

Converts the SAP date 9999XXXX to the entered value.

Invalid values

If an SAP date cannot be converted to a valid date format, the invalid date is converted to the entered value. NULL is supported as a value. When converting the SAP date the two special cases 00000000 and 9999XXXX are checked first.

KNIME Integration via SAP Reader

Requirements

The following software applications must be installed for integration into KNIME:

Latest version of Xtract Universal, see Download Trial Version
Latest version of the KNIME Analytics Platform

Step by Step Guide

Create an extraction in Xtract Universal. Select KNIME as the destination for the extraction .
Start the KNIME Analytics Platform.
Install the extension SAP Reader (Theobald Software).
Drag & Drop the Node / Source 'SAP Reader (Theobald Software)' onto the KNIME Canvas.
Open the SAP Reader Task 'Settings' and enter the URL address of the Xtract Universal Server, e.g. http://localhost:8065/ .
Click [Fetch Queries] and select an extraction.
Confirm your input with [OK] .
Start the extraction via [Execute].
Check the extracted SAP data via [SAP Query Result].

Last update: August 2, 2024