Trigger in dev prod and qa

Question

Hi how trigger will get input to qa, dev from one pipeline instance when source is db and target also db.. Pls share screenshot

Answer 1

To implement a trigger in ADF that deploys to different environments like QA, DEV, and PROD, and runs a pipeline instance using a database as both the source and target, you can follow these steps:

Step 1: Create Environment-Specific Parameters

1. In your ADF pipeline, add parameters for each environment such as:
   • dbSourceConnectionString
   • dbTargetConnectionString

These parameters can store different connection strings for each environment (QA, DEV, PROD).

Step 2: Use Linked Services for Databases

1. Create separate linked services for the source and target databases for each environment (QA, DEV, PROD).
2. In your pipeline, use these linked services and reference the appropriate environment parameter for connection strings.

Step 3: Configure a Trigger for the Pipeline

1. Go to the Triggers tab in the ADF UI.
2. Create a new trigger (manual or schedule-based depending on your need).
3. In the pipeline trigger settings, select the pipeline and provide environment-specific parameters (like the connection strings you defined earlier).

Step 4: Parameterize the Linked Service or Pipeline Activities

• In your pipeline activities (e.g., Copy Data activity), parameterize the database connections by using the environment-specific parameters.

Step 5: Deploy to Multiple Environments

• Deploy the pipeline to each environment using Azure DevOps or any deployment method you prefer.
• Each environment (QA, DEV, PROD) should have its own linked services and parameter values set for its respective database connections.

Let me know if you need more specific details for Azure DevOps integration or deployment!

Answer 2

@Vineet S

Thankyou for posting your query on Microsoft Q&A platform .

As per my understanding , you want to set triggers for multiple pipelines in different environment without deploying.

First of all, Dev and QA are never supposed to be within same ADF instance. You need to create multiple instance for implementing the CICD process. You can checkout the official documentation for better understanding: Continuous integration and delivery in Azure Data Factory

Additionally , you can go through the following video resource for implementation: CICD in ADF

Hope it helps. Kindly accept the answer by clicking on Accept answer button. Thankyou