Read and write Azure DevOps projects, teams, and work items in SSIS with API Source + API Destination.

SSIS Azure DevOps Connector is built on the ZappySys API Connector framework so you can configure authentication, select endpoints, preview data, and push updates from one visual workflow. Use Entra-based OAuth app credentials, PAT, or certificate-backed auth based on your governance model.
Part of ZappySys SSIS PowerPack (100+ connectors & tasks).

Recommended starting point

View Setup Guide & Get Started →

See features, UI & examples →

Pro Tip: For production automation, prefer app credentials with a service principal rather than employee-scoped delegated tokens.

Compatibility: SQL Server 2012-2025+ (32/64-bit) | Azure Data Factory / Azure-SSIS IR Ready

⚡ Key Benefits

Bidirectional Integration — Read and write Azure DevOps data in one SSIS pipeline
Flexible Authentication — Use delegated OAuth, app credentials, or certificate-backed auth
Endpoint Coverage — Work with projects, teams, work items, comments, and query endpoints
Resilient API Calls — Configure retries for throttling and transient API responses
Low-Code Setup — Pick connector templates, map columns, and execute without custom REST coding

📸 Visual Overview & Setup

1. Drag API Source onto Data Flow 🔍 View Full Size	2. Drag API Destination onto Data Flow 🔍 View Full Size	3. Select Azure DevOps Connector 🔍 View Full Size
4. Map the Columns 🔍 View Full Size	5. Source — Select Endpoint & Preview 🔍 View Full Size	6. Destination Mapping & Execute 🔍 View Full Size

🔧 Key Features

Read and Write Endpoint Support

Query projects, teams, work items, and query definitions with API Source
Create and update projects, teams, work items, and comments with API Destination
Use generic REST endpoints for custom Azure DevOps actions

Authentication and Security

User Credentials OAuth for delegated access
Azure App Credentials OAuth for service principal automation
Certificate-based OAuth option for private-key JWT token acquisition

Operational Control

Configurable organization and project defaults for predictable endpoint behavior
Retry controls for 429 throttling and transient failures
Visual mapping and endpoint previews before package execution

💡 Common Use Cases

Work Item Warehouse Loads: Export work item history into SQL Server for reporting and analytics.
Project and Team Synchronization: Keep project metadata aligned between internal systems and Azure DevOps.
Automated Backlog Updates: Push status or field updates from ETL pipelines back to work items.
Cross-System Governance: Standardize auth with Entra app credentials for unattended jobs.
ADF SSIS Modernization: Run the same Azure DevOps SSIS packages on Azure-SSIS Integration Runtime.

🎯 Summary

Integrate Azure DevOps with SSIS using the same drag-and-drop patterns your ETL team already knows.
Use one connector framework for extraction, transformation flows, and write-back automation.

Trusted by Developers & IT Teams Worldwide

Built for SSIS Workflows: Designed for production ETL and integration operations.
Expert Technical Support: Guidance for connector setup, auth, and endpoint design.
Proven Enterprise Scale: Adopted by thousands of organizations across 90+ countries.

SSIS PowerPack

Includes SSIS Azure DevOps Connector