Azure DevOps Board ETL Source

See the Connector Marketplace topic. Please request your administrator to start a trial or subscribe to the Premium Azure DevOps Board connector.

Azure DevOps Board data source reads the objects from the Boards service of Azure DevOps.

Schema Type #

See the topic Provide Schema for ETL Source → to know how schema details can be provided for data sources.

After providing schema type details, the next step is to configure the data source.

Data Source Configuration #

Connection Name: Connections are the service identifiers. A connection name can be selected from the list if you have created and saved connection details for Azure DevOps Board earlier. Or create one as explained in the topic - Azure DevOps Board Source Connection →

WIQL Search Type: The options available in WIQL Search Type are:

Query: It can be selected to read the desired data from Azure DevOps by providing WIQL query.

Parameter: It can be selected to read data from specific projects, work item types, start date, end date and fields.

If the preferred option is Query, an additional field for providing query will be displayed.

Query: WIQL query to be executed in Azure DevOps.

Example:

select System.TeamProject,System.WorkItemType from workitems where System.TeamProject=‘test2’ AND System.WorkItemType=‘epic’

If the preferred option is Parameter, then proceed by updating the following fields.

Project Name: Project name(s) should be selected to read data from the available user projects. Select IN to include or NOT IN to exclude the selected project names.

Work Item Type: Work Item Type(s) should be selected to read data from the available user Work Item Types. Select IN to include or NOT IN to exclude the selected Work Item Types.

Expand String: The expand parameter for the Work Item attributes.

At present, only fields are supported.

Fields: Option to read data from the selected fields. The fields displayed in this parameter are specific to the projects selected above.

Detect Schema #

Check the populated schema details. For more details, see Schema Preview →

Incremental Read #

Optionally, you can enable incremental read. For more details, see Azure DevOps Board Incremental Configuration →

Pre Action #

To understand how to provide SQL queries or Stored Procedures that will be executed during pipeline run, see Pre-Actions →)

Notes #

Optionally, enter notes in the Notes → tab and save the configuration.