Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Charline_74
Resolver I
Resolver I

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

Charline_74_0-1740064442657.png

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?

1 ACCEPTED SOLUTION
nilendraFabric
Super User
Super User

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 

 

View solution in original post

1 REPLY 1
nilendraFabric
Super User
Super User

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 

 

Helpful resources

Announcements
Fabric July 2025 Monthly Update Carousel

Fabric Monthly Update - July 2025

Check out the July 2025 Fabric update to learn about new features.

July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors