dynamic salesforce connection based on workspace

[ssap]

Hello All!

We are using the salesforce connector in a Copy Data activity in ms Fabric Data Pipelines.  We do not see a way to parameterize which Salesforce connection to use when promoting from DEV workspace.  Basically it seems like we have to manually change the connection information in the destination Wrokspace everytime we promot the data pipeline.  Has anyone else seen this and figured a solution or workaround?  

thank you!

[v-veshwara-msft]

Hi @ssap ,

Hope you are doing good,
Would you mind marking your workaround or any helpful reply as "Accepted Solution" to assist others with similar queries? This helps the community find the answer quickly.

Thanks for being part of the Fabric Community.
Regards,
Vinay.

[ssap]

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-msft]

Hi @ssap ,

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.

[v-veshwara-msft]

Hi @ssap ,
We haven't heard back from you since last response and wanted to check if any of the responses were helpful. If so, please consider marking the helpful replies as 'Accepted solution' to assist others with similar queries. If further assistance is needed, please reach out.

Thank you.

[v-veshwara-msft]

Hi @ssap ,
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.

[suparnababu8 · Accepted solution]

Hello @ssap 

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!

[ssap]

thanks for feedback.  we are unable to parameterize the connection name either. seems like it is only possible to do that for Lakhouse and Warehouse