Azure DevOps
Azure DevOps provides interactive and customizable tools to manage software projects.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | |
| History mode | ||
| Custom data | ||
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | ||
| Fivetran data models | ||
| Private networking | ||
| Authorization via API | check |
Sync overview
To capture new records, we incrementally sync the COMMIT, COMMIT_PARENTS, and USERS tables. We re-import the USERS table once a week. All other tables are re-imported during each sync.
Setup guide
Follow our step-by-step Azure DevOps setup guide to connect Azure DevOps with your destination using Fivetran connectors.
Schema information
This schema applies to all Azure DevOps connectors.
To zoom, open the ERD in a new window.Limitations
Once work_item_id is marked as Closed or Done in Azure DevOps, we stop updating it in the BACKLOG_WORK_ITEM table and its child table, WORK_ITEM. For more information, see Microsoft Developer Community.