We're giving away 30 tickets for FREE! Share your story, your vision, or your hustle and tell us why YOU deserve a ticket.
Apply nowWin a FREE 3 Day Ticket to FabCon Vienna. Apply now
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?
Solved! Go to 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
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