Azure DevOps

Azure DevOps can be connected using a System Line kind Web and the Query Handler Odata. You can connect to the Analytics data model for Azure DevOps and the respective entity sets.

System Line configuration for Azure DevOps

• Kind: Web (any kind of web source)

• Authentication: Enabled

• Short Name: As usual a descriptive and identifying name

System configuration for Azure DevOps

System data

• Short Name: A descriptive and identifying name

• Location: Assign the System to a Location (has to be created and enabled before)

• Authentication: Here several opportunities are available, it also depends it enabled on System Line level

  • Configure on System: All Functions based on this System are using the defined authentication procedure. The following are available:
    • Azure AD OAuth2: Use Azure ActiveDirectory OAuth2 SSO for all Virtual Datasets of this system.

Authentication Configuration

• Authentication:
  • In case of Azure AD OAuth2: https://analytics.dev.azure.com/user_impersonation

Do not forget to check the "Enabled" box and save it to make the System available.

Function configuration for Azure DevOps

Select the Technical Handler 'OData'.
For the Technical Parameters, please specify the following options. The options in BOLD are REQUIRED:

• PROPERTIES: List of properties to be returned by the query, separated by semicolons. Use '*' to return all properties.

• RESOURCE_PATH: Entity set, e. g. WorkItems

• SERVICE_ROOT_URL: https://analytics.dev.azure.com/{OrganizationName}/{ProjectName}/_odata/{version}, using e. g. version v4.0-preview.

note

More information on available Entity Sets can be found here.

Parameter

• PROPERTY_FILTER: Parameter to filter properties (fields) in the queried entity set.
  • Cardinality: all
  • Data Type: all, but Date or Time
  • Additional Properties:
    • PROPERTY_NAME: Name of the property (field) in the queried entity set.

note

The data types Date or Time are not available in Azure DevOps.