Third-Party-Services General
Updated 2 months ago
by
Stephanie Krenz
Introduction
Besides storing the data in databases, you can also use Third-Party Services. You can use these to export your extracted and analyzed data.
You have the following options here:
- Excel
- CSV
- Alteryx -> Available with Version 1.12
How to set up these services is explained in the following sections.
Excel Export Creation
- Click on Settings at the top, on Third-Party Services in the section Data on the left and then on + Third-Party-Service at the top right
- Select Excel and click on Configure
The following settings are available:
- Name -> Enter a name for the new Third-Party-Service
- Excel Export Directory -> Select a path in which the exported Excel files should be saved
- Enable Thousands Separators -> By activating the checkbox, you can specify whether numerical values in the Excel file are visually marked in thousands units
- Column Header -> You have the following options here:
- Technical: Display of the technical name -> e.g. EKKO_EBELN
- Descriptive: Display of the descriptive name -> e.g. Purchasing Document Number
- Both: Display of the technical and the descriptive name -> e.g. Purchasing Document Number [EKKO_EBELN]
- Data Limit -> Define a data limit per file (if this limit is reached, a new file is automatically created)
- Test current path -> Test whether the entered export path exists
- If the path exists and is reached, a success message appears
- Create or Create & Close -> Click on Create & Close to save the settings and close this view automatically, a success message will be displayed and you will see your newly created service
After creating it, you will automatically return to the overview of all existing Third-Party-Services.
CSV Export Creation
- Click on Settings at the top, on Third-Party Services in the section Data on the left and then on + Third-Party-Service at the top right
- Select CSV and click on Configure
The following settings are available:
- Name -> Enter a name for the new Third-Party-Service
- CSV Export Directory -> Select a path in which the exported CSV files should be saved
- Delimiter -> Specify a separator to splikt the individual column contents of the tables. You have the following options here:
- Colon -> ,
- Tab (like the Tab-key on your keyboard)
- Pipe -> |
- Hashtag -> #
- Semicolon -> ;
- Column Header -> You have the following options here:
- Technical: Display of the technical name -> e.g. EKKO_EBELN
- Descriptive: Display of the descriptive name -> e.g. Purchasing Document Number
- Both: Display of the technical and the descriptive name -> e.g. Purchasing Document Number [EKKO_EBELN]
- Data Limit -> Define a data limit per file (if this limit is reached, a new file is automatically created)
- Test current path -> Test whether the entered export path exists
- If the path exists and is reached, a success message appears
- Create or Create & Close -> Click on Create & Close to save the settings and close this view automatically, a success message will be displayed and you will see your newly created service
After creating it, you will automatically return to the overview of all existing Third-Party-Services.
Alteryx Export Creation
The Third-Party Service Alteryx will be available with Version 1.12 and must be licensed separately.
- Click on Settings at the top, on Third-Party Services in the section Data on the left and then on + Third-Party-Service at the top right
- Select Alteryx and click on Configure
The following settings are available:
- Name -> Enter a name for the new Third-Party-Service
- Alteryx Export Directory -> Select a path in which the exported Alteryx files should be saved
- Use Unicode -> Tick the checkbox, if the entries should be saved in Unicode
- Test current path -> Test whether the entered export path exists (if the path exists and is reached, a success message appears)
- Create or Create & Close -> Click on Create & Close to save the settings and close this view automatically, a success message will be displayed and you will see your newly created service
After creating it, you will automatically return to the overview of all existing Third-Party-Services.
