topic Re: Dynamically Set Data Connection to Salesforce - Still not available? in Pipelines

Dynamically Set Data Connection to Salesforce - Still not available?

Anonymous — Tue, 14 Jan 2025 15:22:21 GMT

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.

Re: Dynamically Set Data Connection to Salesforce - Still not available?

Anonymous — Wed, 15 Jan 2025 01:27:41 GMT

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.

Re: Dynamically Set Data Connection to Salesforce - Still not available?

Anonymous — Wed, 15 Jan 2025 02:49:30 GMT

Thank you for #1 could you clarify if this would work for a Salesforce connection? When I read though it seems like it's only between Fabric workspaces?

I tried this option before but couldn't seem to give it the exact SF connection string details that were needed.