Skip to main content

Get help for ARIS Process Mining functions and services

Change the name and type of a source table

You can change the name and type of a source table.

For table of Table type, only the Replace option is available. This replaces the entire table by the newly uploaded table. If you change the type to Incremental table, the Update option is provided instead of the Replace option. In this case, the existing source table and the uploaded data are merged. That is, only individual records in the source table are replaced with actually changed records and new records are simply added to the table.

A merge key is required for an incremental update. The merge key is used to replace only the records in the source table that have actually changed.

Procedure. Procedure

  1. Open the Extractions section of a data set.

  2. Click a JDBC extraction in the Extractions list. The Tables page of the selected extraction opens.

  3. Click the ... button of a table -> Configure assigned source table.

  4. To change the table name of the selected table, enable the Rename source table option and enter a new name.

  5. Select the table type for the source table.

  6. Click Next.

    If you selected a table of Table type, the Target column names dialog opens.

    If you selected a table of Incremental type, the Source table merge key dialog opens. Here you can specify a merge key used for an incremental update. The merge key is used to replace only the records in the source table that have actually changed. You can select one or more columns to specify the merge key. Click Next to open the Target column names dialog.

  7. Click Done.

You changed the table name and the source table type.