How let the tables of camunda itself create into another schema

Camunda 7 Topics Discussion & Questions
1

I am useing camunda work flow enginer with springBoot. But when i use the default config of the camunda to start application. The camunda will create lot of tables on my business schema. The question is how let the camunda create itself tables to another schema.

I tried config the camunda.bpm.database.schema-name to another schema name, But it doesnt work.

Can someone help me?

2

I am tyied use the camunda.bpm.database.table-prefix to camunda. And i alrady created a schema name as camunda. But camunda always create the tables of itself to my business schema.

Here is my config
camunda: bpm: datasource: table-prefix: "camunda."

1 Like
3

Hi @himly,

if you want to use a different schema then you must create the database tables by your own. It can only create the tables on the default schema. Additionally, you must set the table prefix in the configuration.

Best regards,
Philipp

1 Like
4

Thanks you for your answer. But i think this design is bad.

5 Likes
5

What if we create a secondary datasource and point this source to the schema which we want to use with Camunda and then configure Camunda to use the secondary datasource rather than the primary. As the desired schema for Camunda will be the default database for the secondary datasource, Camunda will still be connecting to the “default” schema yet creating tables in our desired schema. Is this work around feasible?

6

Hi @Philipp_Ossler

How to use multiple schemas? is there an option?

Thanks

7