Third-Party-Services General

Updated 3 weeks 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

Note
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.


How did we do?


Powered by HelpDocs (opens in a new tab)

Powered by HelpDocs (opens in a new tab)