# Integration of a second database

**URL:** <https://community.forestadmin.com/t/integration-of-a-second-database/4898>\
**Category:** Help me!\
**Tags:** howtos\
**Created:** [June 24, 2022, 2:37pm UTC](https://community.forestadmin.com/t/integration-of-a-second-database/4898 "2022-06-24T14:37:14Z")\
**Posts on this page:** 12\
**Page:** 2

<div class="post-metadata">

**Author:** ![jacques\_liao](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/jacques_liao/32/3723_2.png) [@jacques\_liao](https://community.forestadmin.com/u/jacques_liao)\
**Post date:** [July 6, 2022, 9:07am UTC](https://community.forestadmin.com/t/integration-of-a-second-database/4898/22 "2022-07-06T09:07:41Z")

</div>

so I separated in two folders one for my 1st database and the other for the 2nd.  
 ![image](https://europe1.discourse-cdn.com/flex013/uploads/forest/original/2X/0/0a4125c448b94c1df782f6b6de81198a9ef42320.png)

However when I go to forest admins I still don’t see my first database.

Is it necessary to modify something else so that they can see my 1st and 2nd database?  
Because when I launch `npm start`, in my `.forestadmin-schema.json` file I can’t find my first database

---

<div class="post-metadata">

**Author:** ![anon39940173](https://avatars.discourse-cdn.com/v4/letter/a/8c91f0/32.png) [@anon39940173](https://community.forestadmin.com/u/anon39940173)\
**Post date:** [July 6, 2022, 9:11am UTC](https://community.forestadmin.com/t/integration-of-a-second-database/4898/23 "2022-07-06T09:11:47Z")

</div>

can you show me the code in `config/databases.js` ?

You need to:

- Change the name of either database (both are called defaults, so the second one is probably overwriting the first one when sequelize loads)
- Update the `modelsDir` key

---

<div class="post-metadata">

**Author:** ![jacques\_liao](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/jacques_liao/32/3723_2.png) [@jacques\_liao](https://community.forestadmin.com/u/jacques_liao)\
**Post date:** [July 6, 2022, 9:18am UTC](https://community.forestadmin.com/t/integration-of-a-second-database/4898/24 "2022-07-06T09:18:21Z")

</div>

Here is the configuration in the `config/databases.js` file

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/forest/original/2X/5/500c206ffe24efbf366bd02bc6b22e4b9133301e.png)

for the name of the files are they correct.  
And I did not understand how to update the `modelsDir` key

---

<div class="post-metadata">

**Author:** ![anon39940173](https://avatars.discourse-cdn.com/v4/letter/a/8c91f0/32.png) [@anon39940173](https://community.forestadmin.com/u/anon39940173)\
**Post date:** [July 6, 2022, 9:22am UTC](https://community.forestadmin.com/t/integration-of-a-second-database/4898/25 "2022-07-06T09:22:57Z")

</div>

can you rename `name: 'default'` to `name: 'anythingelse'` on the second record?

---

<div class="post-metadata">

**Author:** ![jacques\_liao](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/jacques_liao/32/3723_2.png) [@jacques\_liao](https://community.forestadmin.com/u/jacques_liao)\
**Post date:** [July 6, 2022, 9:31am UTC](https://community.forestadmin.com/t/integration-of-a-second-database/4898/26 "2022-07-06T09:31:04Z")

</div>

Yes, that was the problem ! I changed the `default` by `anythingelse` in name and now I have the two bases visible on forest !  
Thank you @anon39940173 !

---

<div class="post-metadata">

**Author:** ![anon39940173](https://avatars.discourse-cdn.com/v4/letter/a/8c91f0/32.png) [@anon39940173](https://community.forestadmin.com/u/anon39940173)\
**Post date:** [July 6, 2022, 9:33am UTC](https://community.forestadmin.com/t/integration-of-a-second-database/4898/27 "2022-07-06T09:33:09Z")

</div>

Finally 🙂

Sorry again for the long delay on getting this sorted out

---

<div class="post-metadata">

**Author:** ![jacques\_liao](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/jacques_liao/32/3723_2.png) [@jacques\_liao](https://community.forestadmin.com/u/jacques_liao)\
**Post date:** [July 6, 2022, 10:03am UTC](https://community.forestadmin.com/t/integration-of-a-second-database/4898/28 "2022-07-06T10:03:36Z")

</div>

No problem ! 🙂  
I have a last question is it possible to separate the data of my different databases by putting them in a folder for each of them?

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/forest/original/2X/3/3518768c6fa78031215676d4d58095e9eb7638fe.png)

For example in the folder `routes` I have the routes of the two databases together.  
Is it possible to put folder like for the models?

---

<div class="post-metadata">

**Author:** ![anon39940173](https://avatars.discourse-cdn.com/v4/letter/a/8c91f0/32.png) [@anon39940173](https://community.forestadmin.com/u/anon39940173)\
**Post date:** [July 6, 2022, 10:22am UTC](https://community.forestadmin.com/t/integration-of-a-second-database/4898/29 "2022-07-06T10:22:54Z")

</div>

Sure thing.  
Just create the folders, it should work out of the box without changing any code.

If not, you can play with this piece of code in `/app.js`:  
 ![image](https://europe1.discourse-cdn.com/flex013/uploads/forest/original/2X/c/c6d04df79d5e78ea98ac2305714a609e2be2b682.png)

---

<div class="post-metadata">

**Author:** ![jacques\_liao](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/jacques_liao/32/3723_2.png) [@jacques\_liao](https://community.forestadmin.com/u/jacques_liao)\
**Post date:** [July 6, 2022, 1:11pm UTC](https://community.forestadmin.com/t/integration-of-a-second-database/4898/30 "2022-07-06T13:11:00Z")

</div>

Do you have a document explaining this part? 😅

---

<div class="post-metadata">

**Author:** ![anon39940173](https://avatars.discourse-cdn.com/v4/letter/a/8c91f0/32.png) [@anon39940173](https://community.forestadmin.com/u/anon39940173)\
**Post date:** [July 6, 2022, 1:19pm UTC](https://community.forestadmin.com/t/integration-of-a-second-database/4898/31 "2022-07-06T13:19:06Z")

</div>

I don’t think so 🤷‍♂️

The agent requires all routes under the `routes` folder recursively using [require-all](https://www.npmjs.com/package/require-all)

Creating folder there should just work out of the box.

Did you attempt it and had issues?

---

<div class="post-metadata">

**Author:** ![jacques\_liao](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/jacques_liao/32/3723_2.png) [@jacques\_liao](https://community.forestadmin.com/u/jacques_liao)\
**Post date:** [July 6, 2022, 1:31pm UTC](https://community.forestadmin.com/t/integration-of-a-second-database/4898/32 "2022-07-06T13:31:44Z")

</div>

yes I created a folder and moved one of my routes into the folder. It works if I comment

> const { assistance } = require(‘…/…/models’);

otherwise I get an error saying that it can’t access the models while the route is in `../../models`

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/forest/original/2X/1/12c9f0fb3b7ec794cf83b267712b47f990b50e6a.png)

---

<div class="post-metadata">

**Author:** ![jacques\_liao](https://dub1.discourse-cdn.com/flex013/user_avatar/community.forestadmin.com/jacques_liao/32/3723_2.png) [@jacques\_liao](https://community.forestadmin.com/u/jacques_liao)\
**Post date:** [July 6, 2022, 1:34pm UTC](https://community.forestadmin.com/t/integration-of-a-second-database/4898/33 "2022-07-06T13:34:28Z")

</div>

I think it’s ok actually I just need to change the path like this

> const assistance = require(‘…/…/models/np/assistance’);

So it works fine

[Previous page](https://community.forestadmin.com/t/integration-of-a-second-database/4898.md?page=1)
