Dynamically Set Data Connection to Salesforce - Still not available?

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.