Modification of the Data Pipeline Copy Activity connection during a deployment pipeline

Charline_74 — Thu, 20 Feb 2025 15:22:58 GMT

I use a data pipeline to retrieve data via a connection to an Oracle database.

However, when I deploy my data pipeline in PROD for example, I would like the connection to change automatically. Is there a way of doing this?

Re: Modification of the Data Pipeline Copy Activity connection during a deployment pipeline

nilendraFabric — Thu, 20 Feb 2025 16:24:06 GMT

Hello Charline_74

The current limitation in Microsoft Fabric is that data pipelines do not support deployment rules for connection references. In other words, when you deploy a data pipeline (such as a Copy data activity connecting to an Oracle database) from one workspace to another, the connection settings remain unchanged. This means that the connection ID or connection string from the source environment is copied over to the target environment without automatic adjustment

But as workaround try PowerShell Scripting , retrieve the pipeline JSON definition, perform find‐and‐replace operations on connection IDs, and update the definition before redeploying it in the target environment.

Please check this discussion

https://community.fabric.microsoft.com/t5/Data-Pipeline/Data-pipeline-deployment-using-Deployment-pipeline-issue-with/m-p/4327821

https://community.fabric.microsoft.com/t5/Data-Pipeline/Dynamically-set-Copy-data-Destination-Connection-or-Notebook/m-p/4058495

If this us helps please accept the answer

topic Re: Modification of the Data Pipeline Copy Activity connection during a deployment pipeline in Pipelines

Modification of the Data Pipeline Copy Activity connection during a deployment pipeline

Re: Modification of the Data Pipeline Copy Activity connection during a deployment pipeline