Set sql server connection Dynamically

[HarshYadav]

In the power automate flow, I need to establish multiple connection with the sql database Dynamically(on the Run time). Is there any way to establish connection in power automate flow on the run time?

[eric-cheng]

Hi @HarshYadav ,

Can you elaborate what you are trying to achieve?  Do you need to connect to different SQL servers at runtime?

You can create multiple connections and use that within the same flow.  Similarly, you should be able to use multiple SQL actions to connect to different SQL servers within the same flow.

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

[HarshYadav]

Hello Eric,

Thanks for your reply.

As we have a multi tenant environment and we have multiple database for respective customer. So we need to establish the connection to multiple database on the same power automate flow. But the case is, its not pre decided that when the power automate will run for which customer(Database). So the requirement is to create the database connection dynamically. Is there anyway to Achieve that?

[eric-cheng]

Hi @HarshYadav ,

When you say multiple databases, I am assuming you mean multiple databases across multiple SQL servers right?

I don't really know if there is a feasible option to achieve what you want to do that can remain both scalable and maintainable.

Assuming you don't want to write any APIs using code, one approach which I haven't tested and honestly don't know if it will work would be to create linked servers and then use Power Automate to execute stored procedures against linked servers.  You would need to pass in parameters to act as the linked server name etc.  Again, no idea if it will work in the context of Power Automate.

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

[HarshYadav]

@eric-cheng, Multiple database on the single sql server.

[HarshYadav]

Yes, I don't want to write API using code.

[Decsus]

Has anyone figured out a way around this?

[olivierSOFILEC]

Do you know a way to create a connection on a SQL server that can use the differents bases of this server?
And, in a flow, change dynamicly the data base (not the serveur, juste data base).