Overview

This section shows the available API objects and provides more information on executing SQL to Azure DevOps APIs. Note that this schema can only be accessed when Catalog is set to 'CData' and Schema is set to 'Information'.

Key Features

• The driver models Azure DevOps entities like users, agent pools, and projects as tables and views, allowing you to write SQL to query Azure DevOps data.
• Stored procedures allow you to execute operations to Azure DevOps
• Live connectivity to these objects means any changes to your Azure DevOps account are immediately reflected when using the driver.

Tables

Tables describes the available tables. The provider models the data in Azure DevOps into a list of tables that can be queried using standard SQL statements.

Views

Views describes the available views. Unlike tables, views are read-only.

Stored Procedures

Stored Procedures are SQL scripts that extend beyond standard CRUD operations. They allow you to execute operations to Azure DevOps, such as updating a user, cloning a test case, and creating a pull request.