To connect to the Database, we need to go to the database access information screen

Submitted by rajat.sehgal_1392000 on Fri, 02/22/2019 - 06:46
1
0
-1

Where i can find this database access screen? . I am unable to find it and you have also methioned about the checkinig of graphical query builder. Just let me know the methods to connect to database like postgres and mongodb or mysql.

#postgresql
#mongodb
#connector
#database_access_screen
1 answer

Submitted by Dibyajit.Roy on Fri, 02/22/2019 - 14:32
1
0
-1

Hi Rajat

Are you using Bonita Studio or is Bonita Hosted on a Application server ?

for Bonita Studio, you can use any Database access tool. Personally I use Dbeaver to access local database.
You can also use SQL Developer.
you need to create connection string to access your database and tables.
Bonita has 2 databases. Schema DB and Business Data.
I will look it up but usually to connect to Business Data, you need
hostname is localhost , username is Sa , there is no password and db name is business_data.db

hope this helps

Comments

Submitted by rajat.sehgal_1392000 on Mon, 02/25/2019 - 18:26

I am using Bonita studio, and i have tried to connect to my postgresql database by changing the configuration in the database.properties file , but after that also i am unable to see the change in it, means nothing is saved in my database.

Permalink
Submitted by rajat.sehgal_1392000 on Mon, 02/25/2019 - 19:03

@Dibyajit.Roy can i get your email id, i have few queries related to bonitasoft, so can you help me ?

Permalink
Submitted by Dibyajit.Roy on Mon, 02/25/2019 - 19:09

dbyajitroy@gmail.com

P.S - I am also a newbie here. Please dont expect that I will be able to sort out bigger issues. But I will try my best.

Permalink
Submitted by antoine.mottier on Tue, 02/26/2019 - 15:29

Note that the Bonita Server embedded in Bonita Studio should only be used for testing purpose. It was not designed to allow customization of the database connection for the Bonita Engine and BDM database schemas.

You can safely do your test in the Studio and setup a separated test server (using for example Tomcat+Bonita bundle or Bonita Docker image) and configure this server to use a PostgreSQL database.

On another hand you might also want for example to use MySQL as DBMS for Bonita Engine and BDM database but read and update data store in a PostgreSQL database from your process. To do so you should use connectors and maybe also REST API extension.

Permalink
Submitted by pinerodanie_1404393 on Wed, 07/10/2019 - 21:45

Hello antoine
I'm using bonita 7.8.0 tomcat and postgres 9.3
I installed 2 processes in bonita tomcat server .
1 inserts in my postgres db - ok
2 in this one i used a select db connector to get a value from my postgres db - doesnt work dont show the info
I used a process variable to store the connector result and i call it whith an api variable. It works in the studio bot not in produccion tomcat server
What could it be??
Thanks in advance

Permalink
Submitted by antoine.mottier on Tue, 07/16/2019 - 19:35

Can you share (using Google Drive, Dropbox...) your project exported as a .bos file?

Also note that I recommend to use the Business Data Model (BDM) feature to manage your process data. It's a lot easier to display and edit business variables managed by the BDM as this feature is well integrate in the Bonita solution. Getting data from an external database not managed by Bonita (and updating it) is a little bit more complex and requires usage of REST API extension and connector.

Permalink
Notifications