Connect Azure DevOps to SQL-first tools with an ODBC DSN and query-based workflow.

Azure DevOps ODBC Driver enables read and write access to projects, teams, work items, and comments from SQL Server, Power BI, Excel, Python, and other ODBC clients. Configure OAuth user credentials, app credentials, or PAT, then drive operations through SQL and query builder endpoints.
Part of ZappySys ODBC PowerPack (30+ drivers).

Recommended starting point

View Setup Guide & Get Started →

See features, UI & examples →

Pro Tip: Use app credentials for unattended jobs and reserve delegated OAuth for interactive analyst sessions.

Compatibility: Windows ODBC (32/64-bit) | Works with SQL Server, Power BI, Excel, Python | Data Gateway for centralized shared access

⚡ Key Benefits

SQL-Driven Operations — Read and write Azure DevOps entities through familiar SQL statements
Flexible Authentication — Support OAuth, app credentials, certificate mode, and PAT
Endpoint Granularity — Access project, team, work item, and comment actions from one DSN
Performance Controls — Push filters via query builder parameters for server-side execution
Centralized Governance — Publish one connection through Data Gateway for multiple clients

Learn more about Data Gateway

📸 Visual Overview & Setup

1. Pick Azure DevOps Connector 🔍 View Full Size	2. Search Online if Not Listed Azure DevOps connector page	3. Build & Preview SQL Query 🔍 View Full Size
4. Load Azure DevOps Rows into Excel 🔍 View Full Size	5. Connect from Power BI 🔍 View Full Size	6. Share via Data Gateway Data Gateway overview

🔗 Seamless SQL Query Integration

Works with REST, OData, files, and databases

-- Create Project via SQL (Azure DevOps)
INSERT INTO Projects (Name, Abbreviation, Description, SourceControlType, Visibility)
VALUES
('My New Project', 'MNP',
'The system we use for implementing point-of-service walk-in payment systems.',
'Git', 'private')

✔ Query APIs like a database
✔ No ETL or custom scripts needed
✔ Works inside SQL Server, Power BI, Excel

🔧 Key Features

Read and Write Coverage

Query work items, projects, teams, and related metadata through table-like endpoints
Create and update entities such as projects, teams, work items, and comments
Use generic request endpoints for advanced Azure DevOps API scenarios

Authentication and Security

User Credentials OAuth with Entra registration and delegated scopes
App Credentials OAuth with client secret for unattended automation
Certificate-based app credentials for private key JWT signing flow

Operational Fit

Use query builder parameters to move filtering server-side for faster retrieval
Configure retry policy for throttling and transient API response handling
Share one connection across users using Data Gateway

💡 Common Use Cases

Work item analytics: Pull backlog and sprint data into SQL BI models.
Automated provisioning: Create projects or teams from upstream onboarding workflows.
Cross-tool reporting: Reuse one DSN across SQL Server, Power BI, and Excel.
Governed enterprise access: Use app credentials and gateway for centralized control.
Data quality loops: Update work items from validation outputs in ETL jobs.

🎯 Summary

Bring Azure DevOps into your ODBC ecosystem with SQL-driven access patterns.
Configure once and integrate from reporting, automation, and data engineering tools without custom API wrappers.

Trusted by Developers & IT Teams Worldwide

Built for ODBC Workloads: One integration model across SQL, BI, and code.
Expert Technical Support: Help with auth setup, query design, and troubleshooting.
Proven Enterprise Scale: Used globally for API and cloud data integration projects.

ODBC PowerPack

Includes Azure DevOps ODBC Driver