# One service with multiple databases
**URL:** https://community.dreamfactory.com/t/one-service-with-multiple-databases/5082
**Category:** Connecting to SQL
**Created:** [December 14, 2019, 4:47pm UTC](https://community.dreamfactory.com/t/one-service-with-multiple-databases/5082 "2019-12-14T16:47:00Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@Kryger](https://community.dreamfactory.com/u/Kryger)
#### Post date: [December 14, 2019, 4:47pm UTC](https://community.dreamfactory.com/t/one-service-with-multiple-databases/5082/1 "2019-12-14T16:47:00Z")
Hi all
Is it possible to have one service, which can connect to multiple SQL databases?
We have a SQL server with multiple databases, all with the same schemas, but right now we have to create a new service for each database and therefore also change or add roles. Since all users have the same rights across all databases it would be must easier for us with just one service.
Hope you can help 🙂
- Christian
---
### Author:  [@abhishek.pandey](https://community.dreamfactory.com/u/abhishek.pandey)
#### Post date: [March 20, 2020, 5:10am UTC](https://community.dreamfactory.com/t/one-service-with-multiple-databases/5082/2 "2020-03-20T05:10:59Z")
Hi Christian. Thank you for your question.
You are right. You will need to create a service each for the each of the SQL databases. That being said, a lot of DreamFactory customers use the Data Mesh feature wherein you can write your scripts in Node.js, V8js, or PHP, with more languages on the way. Server Side Scripting provides a simple way to modify the request or response of any API call. So one easy way to combine multiple data sources is to add some fields to a record when the data is returned. [Ref](https://www.dreamfactory.com/content/combining-multiple-data-sources-one-api-dreamfactory/)
To see a tutorial on Data Mesh in DreamFactory, check out this video - [https://youtu.be/6yOH1w2hjxM](https://youtu.be/6yOH1w2hjxM)
Please feel free to reach out if you have any more questions.
Abhishek