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!
Hi Anonymous ,
Thanks for using Microsoft Fabric Community,
Currently, Microsoft Fabric does not support parameterizing the connection name for all data sources. This feature is available for Lakehouse and Warehouse, but not for other connectors like Salesforce.
As a workaround, a switch condition on the workspace ID can be used to determine the correct connection, with separate activities created for each environment. While this is not an ideal long-term solution, it may help until parameterization options become available.
Solved: Dynamically set source connection in copy activity... - Microsoft Fabric Community
Please refer this for upcoming features:
What's new and planned for Data Factory in Microsoft Fabric - Microsoft Fabric | Microsoft Learn
For future improvements, consider upvoting or submitting a feature request in the Microsoft Fabric Ideas Forum.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and a kudos would be appreciated.
Thank you.