Camunda using Oracle DB via SpringBoot

Camunda 7 Topics Discussion & Questions
,
1

Relatively new to Camunda here, trying to plan out setting up Camunda using Oracle DB via SpringBoot but am having some trouble verifying some assumptions I have regarding how Camunda works:

  1. If we roll out Camunda via SpringBoot to use a Oracle database, the schema should be automatically generated so long as we include spring-boot-starter-jdbc in our dependencies. Similar to how the pilot project at https://start.camunda.com/ works, except we configure the connection for Oracle.

  2. It seems like the service account (sa) for the database will be used to generate the initial schema as well as for the connection between spring and the db. Is it safe to assume that the sa pretty much needs full access to the db? I’ve been searching for documentation that outlines how the sa should be set up but haven’t had seen any yet.

Any insights would be helpful.

Thanks!

2

You probably want to start here, just to be sure your environment(s) is(are) supported

Then make sure your jdbc connection is setup to match your environment. The connection string will dictate what user owns the schema automatically created (don’t forget the isolation level).

Then configure the engine the way you want. Have a look at the Datasources section to configure whether or not the schema is created automatically.