HI Team, if you can guide me with below
Scenario:
Resource group A in east US.
ADF v2 with a Dual Standby SSIS IR.
SSISDB in Azure SQL Database. The SQL server is configured with a failover group, replicating SSISDB to a SQL Server in West US.
Azure DevOps Git Enabled.
Resource group B in West US.
ADFv2 created.
Secondary azure SQL database, part of failover group of SQL Server in East US.
Azure DevOps Integration:
An azure pipeline created to update the configuration in West US when East US ADF configuration are updated.
in Azure Pipeline in Overwrite parameter section, the Azure SQL database in West US is updated as the catalog database of IR.
Result:
1. A new pipeline created in ADF in east US gets updated in West US ADF.
Support required:
The SSIS IR created as part of the pipeline is in East US. Is there a way to overwrite the location of IR.