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

**URL:** <https://community.ofelia.com/t/to-connect-to-the-database-we-need-to-go-to-the-database-access-information-screen/9474>\
**Category:** Q&A\
**Created:** [22 February 2019 05:46 UTC](https://community.ofelia.com/t/to-connect-to-the-database-we-need-to-go-to-the-database-access-information-screen/9474 "2019-02-22T05:46:12Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![rajat.sehgal\_1392000](https://avatars.discourse-cdn.com/v4/letter/r/b19c9b/32.png) [@rajat.sehgal\_1392000](https://community.ofelia.com/u/rajat.sehgal_1392000)\
**Post date:** [22 February 2019 05:46 UTC](https://community.ofelia.com/t/to-connect-to-the-database-we-need-to-go-to-the-database-access-information-screen/9474/1 "2019-02-22T05:46:12Z")

</div>

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.&nbsp;

---

<div class="post-metadata">

**Author:** ![Dibyajit.Roy](https://avatars.discourse-cdn.com/v4/letter/d/7ea924/32.png) [@Dibyajit.Roy](https://community.ofelia.com/u/Dibyajit.Roy)\
**Post date:** [22 February 2019 13:32 UTC](https://community.ofelia.com/t/to-connect-to-the-database-we-need-to-go-to-the-database-access-information-screen/9474/2 "2019-02-22T13:32:42Z")

</div>

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&nbsp;  
hostname is localhost , username is Sa , there is no password and db name is business\_data.db  
  
hope this helps

&nbsp;

---

<div class="post-metadata">

**Author:** ![rajat.sehgal\_1392000](https://avatars.discourse-cdn.com/v4/letter/r/b19c9b/32.png) [@rajat.sehgal\_1392000](https://community.ofelia.com/u/rajat.sehgal_1392000)\
**Post date:** [25 February 2019 17:26 UTC](https://community.ofelia.com/t/to-connect-to-the-database-we-need-to-go-to-the-database-access-information-screen/9474/3 "2019-02-25T17:26:20Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![rajat.sehgal\_1392000](https://avatars.discourse-cdn.com/v4/letter/r/b19c9b/32.png) [@rajat.sehgal\_1392000](https://community.ofelia.com/u/rajat.sehgal_1392000)\
**Post date:** [25 February 2019 18:03 UTC](https://community.ofelia.com/t/to-connect-to-the-database-we-need-to-go-to-the-database-access-information-screen/9474/4 "2019-02-25T18:03:31Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Dibyajit.Roy](https://avatars.discourse-cdn.com/v4/letter/d/7ea924/32.png) [@Dibyajit.Roy](https://community.ofelia.com/u/Dibyajit.Roy)\
**Post date:** [25 February 2019 18:09 UTC](https://community.ofelia.com/t/to-connect-to-the-database-we-need-to-go-to-the-database-access-information-screen/9474/5 "2019-02-25T18:09:45Z")

</div>

dbyajitroy@gmail.com  
  
P.S -&nbsp; 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.

---

<div class="post-metadata">

**Author:** ![system](https://europe1.discourse-cdn.com/flex013/uploads/community_bonitasoft/original/2X/6/6b7b18c0478f2645369e82e009b65e3b97f2cc12.svg) [@system](https://community.ofelia.com/u/system)\
**Post date:** [26 February 2019 14:29 UTC](https://community.ofelia.com/t/to-connect-to-the-database-we-need-to-go-to-the-database-access-information-screen/9474/6 "2019-02-26T14:29:24Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![pinerodanie\_1404393](https://avatars.discourse-cdn.com/v4/letter/p/e95f7d/32.png) [@pinerodanie\_1404393](https://community.ofelia.com/u/pinerodanie_1404393)\
**Post date:** [10 July 2019 19:45 UTC](https://community.ofelia.com/t/to-connect-to-the-database-we-need-to-go-to-the-database-access-information-screen/9474/7 "2019-07-10T19:45:16Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![system](https://europe1.discourse-cdn.com/flex013/uploads/community_bonitasoft/original/2X/6/6b7b18c0478f2645369e82e009b65e3b97f2cc12.svg) [@system](https://community.ofelia.com/u/system)\
**Post date:** [16 July 2019 17:35 UTC](https://community.ofelia.com/t/to-connect-to-the-database-we-need-to-go-to-the-database-access-information-screen/9474/8 "2019-07-16T17:35:28Z")

</div>

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.
