fabric ci/cd release pipeline

[arkiboys2]

hello,

I am in the process of setting-up the releas epipeline from dev to test.

in the dev workspace which has data factory, etc.), the connections are to dev sql server.

how can I make sure in test the connections are pointing to test sql server?

thank you

[v-aatheeque]

Hi @arkiboys2 

If @nilendraFabric  @Srisakthi 's response helped you resolve your issue, please consider marking it as the accepted answer. If you found this information helpful, I would greatly appreciate your kudos. Thank you!

If you still encounter any issues, don’t hesitate to reach out for further assistance!

[nilendraFabric]

Hello @arkiboys2 ,

@Srisakthi pointed you to right direction, here is step by step guide to create rules:

1. Open your deployment pipeline in Fabric.
2. Click on the settings icon (gear) in the upper-right corner of the pipeline.
3. In the settings pane, select the "Rules" tab.
4. Click on "New rule" to create a rule.
5. Configure the rule:
   • Choose the item type (e.g., "SQL Server connection")
   • Select the specific items or "All items" of that type
   • Choose the action (e.g., "Update connection string")
   • For connection string updates:
     • In the "Find" field, enter the part of the connection string to be replaced
     • In the "Replace" field, enter the new value
     • In the "Find" field, enter the dev SQL Server details (e.g., Server=dev-sql-server.database.windows.net).
     • In the "Replace" field, enter the test SQL Server details (e.g., Server=test-sql-server.database.windows.net).
   • Select which stage to apply the rule to (e.g., "Apply to Test stage")
   • Name your rule
6. Click "Create" to save the rule.
7. The new rule will appear in the list of rules for the pipeline.

This process allows you to automatically update connection strings when deploying from dev to test, ensuring that your connections point to the correct SQL server in each environment.

[arkiboys2]

Hi,in your step number 3, I am unable to locate the rules tab in the settings.

I can access the create rules via the deployment screen with a little lightning icon at the bottom.

Question. I am unable to set rules for pipelines eventhough the pipelines use the copy activity and connect to sql server instance.

any suggestions why it does not allow rules ? thank you

[nilendraFabric]

Hello @arkiboys2 ,

Please check the screenshots

[arkiboys2]

Question. I am unable to set rules for pipelines eventhough the pipelines use the copy activity and connect to sql server instance.

any suggestions why it does not allow rules ? thank you

[nilendraFabric]

Please share the screenshot here , so that I can have a look what you are trying to do

[arkiboys2]

there is no option for each of these pipelines to change the sql server connection

[Srisakthi]

Hi @arkiboys2 ,

Currently deployment rules for data pipeline is not supported.

Regards,

Srisakthi

[arkiboys2]

Do you mean my data factory pipeline pointing to dev can not be updated to point to prod using the fabric ci/cd pipeline deployment rules?

Thanks

[nilendraFabric · Accepted solution]

Hi @arkiboys2 

Deployment rules in Fabric deployment pipelines do not currently support changing data source connections for data factory pipelines. This means that a pipeline pointing to a dev data source cannot be automatically updated to point to a prod data source during deployment.

[Srisakthi]

Hi @arkiboys2 ,

You can utilise Fabric deployment pipeline for deploying from one environment to another. There you have an option of pointing to target db by using deployment rules.

Reference : https://learn.microsoft.com/en-us/fabric/cicd/deployment-pipelines/create-rules?tabs=new-ui

Regards,

Srisakthi