Forum Discussion
dynamic salesforce connection based on workspace
Hello Anonymous
Currently, Fabric doesn't allow you to dynamically chnage the connections details, like server names directly.The only thing that can be parameterized is the connection name within the source/sink but not the connection aspect details like server name. Fabric lacks dyanmic aspects of connections details and Key vault linkage as of today.
Pls go through below urls. it might helps you.
Solved: Dynamic connection to sources in Fabric - Microsoft Fabric Community
Parameters - Microsoft Fabric | Microsoft Learn
Thank you!!!
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
I was able to workaround this by creating a salesforce connection for each of the environments it was needed, and adding some configurations to keep track of the connectionid per env. then when we promote to next environemt a notebook runs that updates the pipeline itself , finding the Copy Data event and updating the connection id of the source. I know if we used rest api we could dynamically set the connetions info but the salesforce connectors performance has been unmatched.
v-veshwara-msftCommunity Support
Hi Anonymous ,
Thanks for taking the time to share this workaround. It’s great to hear that updating the pipeline dynamically through a notebook has worked for your scenario. Managing connection IDs per environment is a practical approach, especially when performance is a key factor.
Additionally, Microsoft Fabric recently announced parameterized connections for Data Pipelines in the March 2025 Feature Summary. This enhancement might help streamline connection management across environments without the need for manual updates. It could be worth exploring as this feature becomes available.
Let us know if you have any further insights or questions.
Please consider accepting the helpful reply as "Accepted Solution" to help others find it easily.
Thank you.