Forum Discussion
Dynamically Set Data Connection to Salesforce - Still not available?
Hi everyone I'm told that data connection parameterization isn't available until May this year but wondering if anybody has figured out workarounds?
My situation is:
- Dev Workspace - Ingestion pipeline connected to Salesforce Sandbox environment
- UAT Workspace - Ingestion pipeline connected to Salesforce Sandbox environment
- Production Workspace - Ingestion pipeline connected to Salesforce Production environment
Currently what we are doing is that manually switching the data connection whenever we deploy to Production but it opens up a lot of opportunnity for manual errors. I've tried to set up the connection as a string that I can dynamically put into the pipeline but it seems like it is only available for Fabric items not for actual data connections.
2 Replies
Hi Anonymous ,
While full parameterization for data connections might not be available until May, there are a few workarounds you can consider:
1. You can use dynamic content to set parameters for certain types of connections. This involves creating a separate pipeline that holds environment-specific variables (like connection strings) and then passing these variables to your main pipeline.
You can look at this document: Solved: Re: Dynamically set Copy data Destination Connecti... - Microsoft Fabric Community
2. For some linked services that don't support dynamic content directly, you can manually modify the JSON configuration to include parameters. So you can use Azure Data Factory to try to solve your problems.
Here is the link I think you can have a look: Copy data from and to Salesforce - Azure Data Factory & Azure Synapse | Microsoft Learn
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.