Use-case: Syncing OpenText Application Quality Management and Azure DevOps

The following use-case provides an example of how to set up a connection between OpenText Application Quality Management and Azure DevOps.

In this topic:

Workflow

This section provides an end-to-end flow of setting up a synchronization. Although your actual environment may require different configuration steps, we recommend that you review this use-case to understand the end-to-end workflow.

In this example, the Quality team works with OpenText Application Quality Management, and the Development team works in Azure DevOps with a Scrum workflow project.

The example creates epics and features in Azure DevOps, and synchronizes them with OpenText Application Quality Management requirements. Connect is configured to originate in either of the endpoint systems.

Back to top

Environment configuration

This use-case has the following configuration:

• An Azure DevOps Scrum Workflow Project called AOS Scrum. Note that the default Basic process type does not contain the relationships required for synchronization.

• An Azure DevOps account email address, and a related API token with full Read/Write access to the Azure DevOps instance and project. This token is required for Cloud Azure DevOps instance access only.

• An OpenText Application Quality Management account (non-SSO) with full Read/Write access to the domain and projects.

• An OpenText Application Quality Management project called AOS.

Back to top

Step 1: Define the OpenText Application Quality Management data source

First define an OpenText Application Quality Management data source.

1. In the Data Sources area, click the + Data Source button, and specify a data source name and product (for example, Azure DevOps).

   Note: Be careful to use names that reasonably describe your connection. Avoid using blank spaces or special characters in names. If needed, data source and connection names can be changed using the Rename script. For details, see Batch utility scripts.

2. Type the OpenText Application Quality Management server name, username, and password. Confirm the port as well, and click Next.

3. Select a space, and click Next.

4. Select the correct domain, and click Next.

5. Select a project that has types, fields, and values similar to the data that you want to sync, and click Next.

   After setting up the connection you can synchronize with multiple projects in the selected space.

6. Click Save. A system check verifies that the values you have entered are valid.

   On the Types tab, you can see the entities that the project identified as available for synchronization. On the Relationships tab, you can see the available relationships.

Back to top

Step 2: Define the Azure DevOps data source

You now repeat the above steps to define the Azure DevOps data source.

1. Click the + Data Source button, and specify the Azure DevOps data source name and product (for example My Azure DevOps, and Azure DevOps).

2. Type the Azure DevOps server URL, such as https://dev.azure.com/<nameofyourorganization>. Enter your user name. In the password field, enter your Personal Access Token. Click Next.

3. From the Sample Project dropdown list, select your project and click Save.

   Note: If you have multiple projects in Azure DevOps that you intend to sync, and all these projects have the same workflows, you can use a common data source and a single connection (or connections) stemming from that data source.

   However, if you have multiple projects with different workflows, such that the entity types and relationships are different, you must describe each such project on a different data source and corresponding connections.

   This is true of the majority of products that are synchronized using Connect.

4. We recommend that you leave the remaining fields as set by default, and click Save. A system check verifies that the values you entered are valid.

   The Types tab shows the entities identified in the Azure DevOps project that are available for synchronization. If you have custom types that you want to add, click + Types and select the type you want to add.

   On the Relationships tab, you can see the available relationships.

Back to top

Step 3: Create Connection Wizard > Data Sources tab

You now create a connection between the two data sources using the Create Connection Wizard. First you specify the data sources:

1. In the Connections tab, click the + Connection button.

2. In the Data Source tab, name your connection. In this example, the connection is Nimbus ALM Azure DevOps.

3. Leave the settings as set by default, and click Next.

Back to top

Step 4: Create Connection Wizard > Types and Fields tab

Connect creates an initial auto-mapping of fields. You enhance the mappings in the Types and Fields tab.

1. Click Add Type Mapping.

2. Select Feature on the left and Requirement on the right side. Change the direction of the type mapping to be To Master. This means that features originate in Azure DevOps and sync to OpenText Application Quality Management.

3. Add additional fields to sync for these types by clicking + Field Mapping, as shown in the next image. When done, click OK.

   

4. After adding the four fields, click the small blue icon to the right of the Priority field mapping. This is where you map the priority value options between the two systems. In this example, Azure DevOps has four values and OpenText Application Quality Management has five. Therefore, priority number 4 in Azure DevOps should be mapped to both Very High and High.

   Note: The bolded font on 5-Very High indicates the value to be set on the other side when syncing the priority from Azure DevOps. Follow the same process for any enumerated list value fields that you sync.

   

5. Add another type to map, and this time choose Feature on the left and Requirement on the right. Ensure the arrow at the type level is again set to To Master.

   Note: Type level direction indicates which system the items can originate from. Field level direction indicates which system the fields can be updated from. This example sets the type and field level directions to match, but it is common to have type level direction to be unidirectional and some fields to be bi-directional.

   Parent -> parent-id is an example of mapping relationships. In this example, Parent is a relationship field on Azure DevOps features used to create the hierarchy in the requirement tree. If you leave out this field mapping, then epics and features will sync into the tree as a flat list.

   

6. Add type mapping from Epic on the left to Requirement on the right. Ensure the arrow at the type level is again set to To Master.

   

7. Add type mapping from Bug to Defect. For this type, set the type level direction to bi-directional, as well as the fields for updates.

   

8. Set the value maps for the Severity, Priority, and Status fields, as follows.

   Click the blue icon to the right of the Severity field mapping, set these value maps and click OK.

   

9. Click the icon to the right of the Priority field mapping, set these value maps and click OK.

   

10. Click the icon to the right of the State/Status field mapping, set these value maps and click OK.

    

Back to top

Step 5: Create Connection Wizard > Projects and Rules tab

In the Projects and Rules tab, define which projects to sync.

1. Click Collapse All at the top right. Under Common Projects, click + Project Mapping. Select AOS Scrum under Azure DevOps Project on the left, and select AOS under the project on the right.

   

2. Collapse the Common Projects section and expand the Feature/Requirement type set.

   Note: If you are syncing multiple projects in a connection, you need to decide whether using Common Projects is sufficient. In most cases, it is not.

   If you map many Azure projects to a single OpenText Application Quality Management project in a given connection, or vice versa, you need to set sync criteria for the specific mapped types that fan the artifacts out to the individual projects. In this case, you cannot use Common Projects. The entire Common Projects block must be empty.

   You need to create separate sync sets joining the types and projects being synchronized with the relevant sync criteria guiding the artifacts picked for each such sync set. It is very rare that you would use Common Projects to contain multiple projects, spanning multiple type sync sets.

3. Click the Edit connection type rule button to edit the calculated values. In the Edit dialog box, you indicate the requirement type when new items are created in OpenText Application Quality Management from Azure DevOps.

   

4. Select the Calculated Value (Master) tab, then click + Calculated Value.

5. Click the Add Child Criteria button . The Add Term dialog box opens.

6. Select Is New from the operator list and click OK.

   This tells Connect to calculate and set this value when a new requirement is created in OpenText Application Quality Management.

   

7. In the Set field list, choose Requirement Type. In the To value list, select the requirement type that you want features to become when they are created. Click OK.

   

   When you select a type, OpenText Application Quality Management converts it to an integer, that represents the type in the database.

   

8. Repeat this process for Feature/Requirement sync, but choose a different requirement type.

   This use-case chooses requirement types that do not have additional required fields.

   

9. Repeat the above steps for an Azure DevOps Epic to a Requirement, and choose another requirement type.

10. Save the connection.

11. Go to Azure DevOps and ensure you have at least one Epic and one Feature. In OpenText Application Quality Management, create at least one Defect.

Back to top

Step 6: Run one sync iteration in the Connections tab

In this step you synchronize the fields, to make sure that everything is set up properly.

1. Click the Modify Connection button to the left of the connection name , and choose Run One Iteration. This runs a single synchronization iteration, to validate the setup.

2. As the iteration runs, click the Connection Messages tab in the lower pane. and click your connection name in the top pane. This shows you the status of your iteration.

   

3. In the Audit tab in the lower pane, click Run. This generates an audit of items that were added, updated, and failed. In the example below, you can see that several requirements were updated that had already synched.

   

   Below is the result in OpenText Application Quality Management. The hierarchy is built to match the parent-child relationships you have in Azure DevOps.

   

Back to top

Step 7: Map relationship links

After everything has synched as expected, edit your connection to add more types and fields.

1. Add a new type mapping for Azure DevOps iterations with OpenText Application Quality Management release cycles. For this example, set the direction to From Master with the following fields.

   

2. Edit the bug-defect mapping. Choose + Field Mapping, and add Iteration Path <-> target-rcyc if not already mapped. Click OK.

   When users set an iteration or target release cycle in one system, the bug or defect will be updated for the related bug or defect in the other system.

   

3. Choose + Field Mapping and add Iteration Path -> target-rcyc. Click OK and save changes.

   When Azure DevOps users set a planned iteration on a feature, that information shows on the related requirement as the target release cycle.

   

4. In OpenText Application Quality Management, create a single release called Azure DevOps Iterations. Create 3 release cycles inside it called ALM Iteration 1, ALM Iteration 2, and ALM Iteration 3.

   These sync to Azure DevOps as available iterations. Azure DevOps users will set the target iterations in features and bugs to indicate the relevant iteration or release cycle.

   Note: Although it is possible to sync iterations from Azure DevOps, this is not covered in our example.

   

5. This example instructs Connect to look at the default release for cycles.

   To set the default release, go to the Data Source tab. Select your OpenText Application Quality Management data source in the left pane. In the Properties tab, select your new release from the Cycle Parent ID drop down list.

   Click Save .

   

Back to top

Step 8: Run synchronization

1. On the Connections tab, click the gear icon to the left of the connection name, and choose Run One Iteration to test the latest changes.

2. In Azure DevOps, confirm that ALM Iterations 1-3 are visible in the Iteration field.

   

3. When available, open a feature in Azure DevOps, and set the Iteration field to one of the iterations that just came from OpenText Application Quality Management as shown above.

4. Run one iteration. Refresh your requirements view and confirm that your feature has a target release and target iteration now set.

   

Back to top