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 |
Supported deployment models
We support the SaaS and Hybrid deployment models for the connector.
NOTE: You must have an Enterprise or Business Critical plan to use the Hybrid Deployment model.
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.
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.