The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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