Skip to main content

Notifications

Power Automate - AI Builder
Answered

SQL Server Connection References

Like (2) ShareShare
ReportReport
Posted on 6 Sep 2024 20:03:04 by 6
Hi All,
 
I have a Power Platform Solution that has Power Automate flows using connection references that are pointing to on-prem sql servers.
 
My requirement is to move data from an on prem SQL Server (The source) and push that to 4 separate on premise SQL servers. These 4 separate servers have databases that are identical.
 
I created 2 connection references, 'source' and 'target'. I was thinking that I would be able to configure/update the target connection reference to point to the next server. When I make this change, it seems to corrupt all of the flows. Our only way forward seems to be, create all new flows. Am I misunderstanding how the connection references work? Does anyone have advice on how I can parameterize the target database connections?
 
Any advice appreciated,
 
Thanks,
 
Philip
 
Categories:
  • Verified answer
    FLMike Profile Picture
    FLMike 27,286 on 07 Sep 2024 at 03:47:40
    SQL Server Connection References
    Hi
     
    A connection reference uses a Connection as its base, essentially its a pointer to a pointer.
     
    You have to have 5 connections and 5 connection references.
     
    because you have 5 servers, you need those 5 connections, and in your flow you use them all so 5 connection references, 1 per connection.
     
    Not 2. Think of it this way.
     
    A Connection has tons of details/memory/configuration etc.
    the references simply make it so that in your flows and in your solutions you aren't constantly creating new connections, but instead references can be made to that Connection from anywhere and you still only need 1 connection.
     
    Cheers,
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

End of Year Newsletter…

End of Year Community Newsletter…

Tuesday Tip #12 Start your Super User…

Welcome to a brand new series, Tuesday Tips…

Tuesday Tip #11 New Opportunities…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 144,696

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,456

Leaderboard
Loading complete