Unanswered

Set sql server connection Dynamically

(0) Share

Report

Posted on by 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?

Categories:

Using flows

I have the same question (0)

All responses (7)

Answers (0)

eric-cheng 5,171 on at

Like (0)

Report

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

Was this reply helpful? Yes No
HarshYadav 8 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
eric-cheng 5,171 on at

Like (0)

Report

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

Was this reply helpful? Yes No
HarshYadav 8 on at

Like (1)

Report

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

Was this reply helpful? Yes No
HarshYadav 8 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Casper 41 on at

Like (0)

Report

Has anyone figured out a way around this?

Was this reply helpful? Yes No
olivierSOFILEC 3 on at

Like (0)

Report

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).

Was this reply helpful? Yes No