Is there a way to connect Bonita BPM Studio to a MySql database

Q&A
1

Hello,

I know it is possible to connect Bonita BPM platform to a MySql database.

But is it possible to connect Bonita BPM Studio (the development environment) to a MySql database?
The documentation does say anything about it : http://documentation.bonitasoft.com/?page=bonita-bpm-studio-installation

To be perfectly clear :
I installed Bonita using the installer BonitaBPMCommunity-7.5.1-x86_64.exe.
It installs Bonita correctly, and Bonita BPM Studio starts with a H2 database. What should I do to use MySql?

1 Like
2

No it’s not possible and there is no reason to, apart from wanting to…

This is a long standing question that Bonitasoft don’t see the need for, nor do their fee paying clients. So it’s a commercial decision not to and that is unlikely to be changed.

Why would you want to do only the “Business Data database”? You don’t say (though I think I can guess :slight_smile:

regards
Seán

PS: While you may not like the answer, it gives the correct answer, please mark as resolved.

regards
Seán

3

Another thing : the database that would use MySql is the “Business Data database” not the “BPM database”.

4

I think that technically this is actually doable by updating the configuration of the embedded Tomcat data source to target the MySQL database and update the Bonita configuration to generate queries for MySQL instead of H2.

But that is not something that is documented and it’s actually not supported.

For testing purpose I would recommend to setup a test server configured to use the MySQL database.

If you still need to give a try to updating the configuration of the embedded test server in Bonita Studio you should be able to pretty much follow the instruction aimed for Bonita BPM server installation but apply them to the tomcat folder located in Studio workspace folder.

5

Thanks for your answers.

Why would you want to do only the “Business Data database”?

I am developing an application using another tool (WaveMaker) that is connected to a MySql database, and that application contains the business data. So I wanted Bonita to connect directly to that database to get the business data (I don’t want to have the data duplicated in my application database and the Bonita database).
But I guess the clean way to do that is to use connectors.

6

Business Data feature aimed to provide a solution to easily define database model and ensure business data storage. This solution is designed to use the database created based on the model define in Bonita Studio and cannot be used to connect to an existing database.

If you have an existing database that contains business data the recommended solution is to:

  • configure a data source in the application server
  • use the data source connector to to read, update… your business data from the process
  • use the data source REST API extension to read the data from the database and display them in the forms.
7

Antoine has it right. When using external db don’t use BDM. It doesn’t work…use other methods such as REST or direct Sql queries…

Regards