Associate a table with a process

Camunda 7 Topics Discussion & Questions
1

Hello,

How can we associate a database table with a process in Camunda?

How new records will be added and existing records will be updated or deleted ?

Thanks.

2

Hi,

What are you trying to achieve?
Interacting directly with the database is not recommended.

3

Suppose there is a process customer onboarding.
We want to have a table for this process, for e.g. tbl_cust_onboard

So how can this be achieved.
Thanks.

4

Could you please explain a little bit more about the use case.

5

I found there is already the table ACT_RU_VARIABLE which keep all information of the process variables.
Is it possible to create a custom table for a process so that all variables are stored there?
Thanks.

6

Hi @yuvrajkeenoo

Every process instance can have a so-called “business key”.
You can use it to associate your custom table with act_hi_procinst table using such below condition

act_hi_procinst.BUSINESS_KEY_ = <YOUR_TABLE>.<KEY_COLUMN>

Below you can find how to set business key
https://blog.camunda.com/post/2018/10/business-key/

7

Thanks @hassang
I will try it.