To connect to the Database, we need to go to the database access information screen
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
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.
@Dibyajit.Roy can i get your email id, i have few queries related to bonitasoft, so can you help me ?
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.
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
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.