Celonis Product Documentation

In Studio, go to your package and click New asset > Action Flow.

Click Add module and from the list select Celonis > Write back to data pool table.

Add a connection to the module using one of the following methods:

• Celonis Application Key

  The Celonis App Key connection will reflect the data permissions granted to the selected Application Key and allow you to query data to which you may not otherwise have access.

  1. Give your connection a name.

  2. In a separate window, create an application key and copy it. See Application keys.

  3. Paste the application key and click Save.

• Celonis user

  The Celonis User connection will reflect your existing data permissions and allow you to query data to which you already have access.

  Note

  You must have Data integration service permission to use this connection method. See Data Integration permissions.

  1. Give your connection a name.

  2. Click Save.

Choose the Data selection method for the following fields:

Select the Data Pool.

You can only select from Data Pools to which you have access.

Select Data connection.

This Action Flow module allows you to select only from Data Connections of the “Push data into Celonis” type, which we refer to as Data ingestion connections here. If there are no Data connections of this type on your list, you must create one first. You can do it directly from the Data ingestion connection dropdown by clicking + New connection. See Using the Standard Data Ingestion API.

Select a table in which you want to save data from Action Flow.

• Select an existing table from the list.

• Create a new table.

Select your data source:

• Manually map table columns

  Use this option to populate columns in your data table with fixed values you enter manually or using Action Flow variables. You can enter values for existing columns in your selected table or add new columns if needed. You can also select individual columns for Primary Key.

• Manually map table columns from CSV

  Use this option to upload data from a CSV format into Celonis Platform. This option can be particularly useful for importing bulk data.

  1. Select the module from which you want to import the aggregated data in the CSV format.

  2. Select delimiter type.

  3. Select if your CSV contains headers in the first row.

     The first row will be skipped if the CSV file contains headers. This option is set to Yes by default.

  4. Enter values for existing table columns.

     You can enter values for columns manually or use variables from the Action Flow. You can also define if a given column is part of Primary Key.

  5. (optional) Click Add item to add new columns to the table.

     You can provide values for individual columns manually or use variables from the Action Flow.

  6. (optional) Toggle Advanced settings for the following additional configuration settings:

     • Quote sequence

     • Espace sequence

     • Data format

     • Date time format

• Automatically map table columns from CSV

  Use this option to upload data from a CSV format into Celonis Platform. In this method, your tables and columns are created automatically based on your CSV files.

  Important

  For automatic mapping to be successful, your CSV file must contain headers.

  1. Select the module from which you want to import the aggregated data in the CSV format.

  2. Select delimiter type.