Connection to Thirdparty Database

[kontrag]

Hi @Gaga,

How did you link the Camunda engine to the MySQL DB server?
Can’t you do a similar integration to Oracle DB?

In this link, I describe some steps how to connect the engine to PostgreSQL, maybe it helps you

How do I use postgresql with camunda

Hi @loserlovey, Here’s my steps for Wildfly edition: In PostgreSQL Server, create the Camunda engine database “Camunda” (if you want to run it there instead of H2 DB). Grant the user (e.g. the default “postgres” user) DELETE, INSERT, SELECT, and UPDATE privileges in this database. Camunda provides script files to create the schemas. These reside in the sql/create folder: ~\camunda-bpm-wildfly10-7.7.0\sql\create\postgres_engine_7.7.0.sql ~\camunda-bpm-wildfly10-7.7.0\sql\create\postgres_ide…

So, for the “engine” DB, there are already scripts to create the schema into the new external DB server. You run those and then you modify the standalone.xml file accordingly.
In the above link I also describe how to create an “application” database as well.