One service with multiple databases

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 :slight_smile:

  • Christian

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

To see a tutorial on Data Mesh in DreamFactory, check out this video -

Please feel free to reach out if you have any more questions.