Skip to main content

CPM

Importing data

The data import process is used to create a new data model or add new tables to your current data model.

New data model

34439929.png

After a name is selected (see item 2)

34439927.png

To add a new data model, click on the "Add new data model" button on the Data Models screen (item 4). This will lead you to the data model creation wizard.

  1. Data model name: type here the name of your new data model.

  2. Click on the next button to continue.

  3. Select the source from which the data will be imported (file or database).

  4. Import file: you can import your data from a file (.xlsx, .csv and .xes are supported). For this option, go to the 'File connection' section.

  5. Connect to database: you can import your data from a live database. For this option, go to the 'Database connection' section.

File connection

To import the data from a file, first select a valid file (.xlsx, .csv and .xes are supported) for upload. Once the upload is successful, the Celonis engine will proceed on parsing the file into the desired column format (step 1) and then assigning a data type to each of these columns (step 2).

Step 1: File parsing
csv_file_parsing_options.png
  1. File encoding: define the character encoding in the file. Default: UTF-8.

  2. Field separator: character used to delimit different columns in the data file. Common values are quotes ( " ), commas ( , ), semi-colons ( ; ), or vertical bars ( | ).

  3. Quote character: define, if necessary, the character used as a quote inside the data file. Quotes may be in the varied formats, such as the straight sin­gle quote ( ' ), the straight dou­ble quote ( " ), the open­ing sin­gle quote ( ‘ ), the clos­ing sin­gle quote ( ’ ), the open­ing dou­ble quote ( “ ), and the clos­ing dou­ble quote ( ” ).

  4. Escape sequence: defines the escape character, if necessary. Escape characters invoke an alternative interpretation on subsequent characters in a character sequence.

  5. Line ending: character or sequence of characters that mark the ending of a line or row.

  6. Header row: defines if the first row should be considered a header row or not.

  7. Imported columns: display the columns imported and parsed from your database file.

Step 2: Data types
34439924.png

In the following steps, the column's data types are detected. This is done automatically and can be customized afterwards with the dropdown on each column.

  1. Table name: assign a name to your table.

  2. Column name: define the name of each column in the data table.

  3. Data type: define the name of each column in the data table.

  4. Date formatting: for 'DATE' data types, you may also define the date format style.

  5. To proceed, head to the 'Configure data model' section below.

Database connection

To import the data from a database, first connect to a valid database (step 1). Once the connection is successful, the Celonis engine will prompt you to select the tables to import (step 2) and then assign a data type to each of these columns (step 3).

Step 1: Database connection
34439923.png
  1. Database name: name of the database. Click on the row to select the database.

  2. New DB connection: connects to a new database. Opens the database connection settings panel to configure a new connection (see 'Database connection settings' below).

  3. Connection status: displays if the connection status to the database was successful ('connected') or not ('connection problem'). To retry the connection, click on the refresh button.

  4. Edit database: hover your mouse over a certain database to view its edit buttons. Opens the database connection settings panel for the selected database (see 'Database connection settings' below).

Database connection settings (if items 2 or 4 are clicked)
34439922.png

5. Template: if you use a common database, choose the respective entry from the dropdown list. This will insert a Connection String with wildcards, as well as the common Driver Name for this database. Find a list of the available templates here.

6. Name: enter a name for your data source. This name will also appear in the list of existing data sources.

7. Connection string: link to your source database. By choosing a connection template, this will be filled out automatically, and you only need to adapt the wildcards.

8. User name: your database access user name.

9. Password: your database access password.

10. Schema name: schemas name a subset of tables and other dictionary objects within a database.

11. Driver name: provide the driver implementation name for the engine to fulfill your communication requests. If you choose a connection template, this is filled out automatically. Usually, you don't need to add anything here within a connection template.

Step 2: Select tables to import
34439915.png

Use the provided checkboxes to select the tables that you wish to import.

You must select at least one table (if it is a new data model, this should be the activity table). For a sufficient analysis document, you will most likely require at least two tables, a case table and an activity table (read more about tables).

Step 3: Select activity table
34439916.png

The activity table (item 12) includes all activities, and is required by any component in the analysis document.To proceed, head to the 'Configure data model' section below.

Configure data model

34439914.png

To finalize the creation of a data model, you must to provide the three mandatory eventlog configuration tables (Case ID, Activity, and Time stamp) and two optional additional tables (End time stamp, Sorting).

  1. Case ID: On the first step, click on the column that contains the Case IDs.

  2. Activity: On the second step, click on the column that contains the description of the activities.

  3. Time stamp: On the third step, click on the column that contains the time in which the activities took place.

  4. Optional activities: on the forth step, click on the column with the time in which the activities ended. If such column doesn't exist, click on the 'Skip' link. The same applies for the fifth step, in which the sorting column may be chosen.

  5. Click on Next to finalize the selection.

After the database model is created, you can create a new Celonis analysis automatically associated with this database or do it later on by creating an analysis.

Table connection

Don't forget to check that all tables in your data models are correctly connected through their foreign keys.