Third-Party-Services General
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.