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

[Charline_74]

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?

[nilendraFabric · Accepted solution]

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-pi...

https://community.fabric.microsoft.com/t5/Data-Pipeline/Dynamically-set-Copy-data-Destination-Connec...

If this us helps please accept the answer