Azure DevOps Integration Guides and Tutorials



A list of guides and tutorials for connecting to and working with live Azure DevOps data.

CData Software's connectivity tools enable users to connect directly to live Azure DevOps data data from widely-used BI, analytics, ETL, and custom applications, ensuring that our customers can access their data wherever they desire. Below, you'll find a collection of guides and tutorials on integrating with live Azure DevOps data.

Integration Use-Cases

Click below to jump to articles related to specific integration use-case.

Business Intelligence & Analytics


ProductTechnologyArticle Title
Alteryx DesignerODBCPrepare, Blend, and Analyze Azure DevOps in Alteryx Designer (ODBC)
Alteryx DesignerConnect CloudWork with Live Azure DevOps Data in Alteryx Designer (Connect Cloud)
Amazon QuickSightConnect CloudBuild Interactive Dashboards from Azure DevOps Data in Amazon QuickSight
Amazon SageMakerConnect CloudIntegrate Live Azure DevOps data into Amazon SageMaker Canvas
Aqua Data StudioJDBCConnect to Azure DevOps in Aqua Data Studio
AWS DatabricksJDBCProcess & Analyze Azure DevOps Data in Databricks (AWS)
Azure Analysis ServicesConnect CloudModel Azure DevOps Data Using Azure Analysis Services
BirstJDBCBuild Visualizations of Azure DevOps in Birst
BIRTJDBCDesign BIRT Reports on Azure DevOps
Clear AnalyticsODBCBuild Charts with Azure DevOps in Clear Analytics
Cognos Analytics (On-Prem)Connect CloudAnalyze Azure DevOps Data in Cognos Analytics
DBxtraODBCBuild Dashboards with Azure DevOps in DBxtra
DomoODBCCreate Datasets from Azure DevOps in Domo Workbench
Dundas BIODBCBuild Dashboards with Azure DevOps in Dundas BI
Excel (on Mac OS)ODBCWork with Azure DevOps Data in MS Excel on Mac OS X
FineReportJDBCFeed Azure DevOps into FineReport
Google SheetsConnect CloudAccess Live Azure DevOps Data in Google Sheets
IBM Cognos BIODBCCreate Data Visualizations in Cognos BI with Azure DevOps
Infragistics RevealConnect CloudAnalyze Azure DevOps Data in Infragistics Reval
JasperServerJDBCCreate Azure DevOps Reports on JasperReports Server
Jaspersoft BI SuiteJDBCConnect to Azure DevOps in Jaspersoft Studio
JReport DesignerJDBCIntegrate with Azure DevOps in JReport Designer
KlipfolioConnect CloudCreate Azure DevOps-Connected Visualizations in Klipfolio
KNIMEJDBCEnable the Azure DevOps JDBC Driver in KNIME
LINQPadADO.NETWorking with Azure DevOps in LINQPad
LookerConnect CloudAnalyze Azure DevOps Data in Looker
Looker StudioConnect CloudCreate Reports from Azure DevOps Data in Looker Studio
MetabaseConnect CloudCreate Interactive Azure DevOps-Connected Metabase Dashboards
Microsoft ExcelConnect CloudAccess Live Azure DevOps Data in Excel Desktop
Microsoft Excel for the WebConnect CloudAccess Live Azure DevOps Data in Excel for the Web
Microsoft SSASADO.NETBuild an OLAP Cube in SSAS from Azure DevOps
MicroStrategyConnect CloudConnect to Live Azure DevOps Data in MicroStrategy through Connect Cloud
MicroStrategyJDBCUse the CData JDBC Driver for Azure DevOps in MicroStrategy
Microstrategy DesktopJDBCUse the CData JDBC Driver for Azure DevOps in MicroStrategy Desktop
Microstrategy WebJDBCUse the CData JDBC Driver for Azure DevOps in MicroStrategy Web
Mode AnalyticsConnect CloudCreate Azure DevOps-Connected Visualizations in Mode
OBIEEJDBCAzure DevOps Reporting in OBIEE with the Azure DevOps JDBC Driver
pandasPythonUse pandas to Visualize Azure DevOps in Python
Pentaho Report DesignerJDBCIntegrate Azure DevOps in the Pentaho Report Designer
Power BI DesktopPower BIAuthor Power BI Reports on Real-Time Azure DevOps
Power BI ServiceConnect CloudVisualize Live Azure DevOps Data in the Power BI Service
Power PivotConnect CloudAccess Azure DevOps Data in Microsoft Power Pivot
Power QueryConnect CloudAccess Azure DevOps Data in Microsoft Power Query
Qlik CloudConnect CloudCreate Apps from Azure DevOps Data in Qlik Sense Cloud
QlikViewODBCConnect to and Query Azure DevOps in QlikView over ODBC
RJDBCAnalyze Azure DevOps in R (JDBC)
RODBCAnalyze Azure DevOps in R (ODBC)
RapidMinerJDBCConnect to Azure DevOps in RapidMiner
RedashConnect CloudQuery, Visualize, and Share live Azure DevOps Data in Redash
SAP Analytics CloudConnect CloudAnalyze Azure DevOps Data in SAP Analytics Cloud
SAP Business ObjectsJDBCCreate an SAP BusinessObjects Universe on the CData JDBC Driver for Azure DevOps
SAP Crystal ReportsJDBCPublish Reports with Azure DevOps in Crystal Reports (JDBC)
SAP Crystal ReportsConnect CloudPublish Reports with Azure DevOps in Crystal Reports (Connect Cloud)
SASODBCUse the CData ODBC Driver for Azure DevOps in SAS for Real-Time Reporting and Analytics
SAS JMPODBCUse the CData ODBC Driver for Azure DevOps in SAS JMP
SAS ViyaConnect CloudAnalyze Live Azure DevOps Data in SAS Viya
SisenseJDBCVisualize Live Azure DevOps in Sisense
Spago BIJDBCConnect to Azure DevOps in SpagoBI
TableauTableauVisualize Azure DevOps in Tableau Desktop
Tableau CloudConnect CloudBuild Azure DevOps Visualizations in Tableau Cloud
Tableau ServerTableauPublish Azure DevOps-Connected Dashboards in Tableau Server
TIBCO SpotfireADO.NETVisualize Azure DevOps in TIBCO Spotfire through ADO.NET
TIBCO SpotfireConnect ServerVisualize Azure DevOps Data in TIBCO Spotfire
TIBCO Spotfire ServerJDBCOperational Reporting on Azure DevOps from Spotfire Server
Zoho AnalyticsConnect CloudCreate Azure DevOps-Connected Dashboards in Zoho Analytics

Back to top

ETL & Replication


ProductTechnologyArticle Title
AirbyteConnect CloudConnect to Azure DevOps Data in Airbyte ELT Pipelines
Amazon RedshiftCData SyncAutomated Continuous Azure DevOps Replication to Amazon Redshift
Amazon S3CData SyncAutomated Continuous Azure DevOps Replication to Amazon S3
Apache AirflowJDBCBridge Azure DevOps Connectivity with Apache Airflow
Apache CamelJDBCIntegrate with Azure DevOps using Apache Camel
Apache CassandraCData SyncAutomated Continuous Azure DevOps Replication to Apache Cassandra
Apache KafkaCData SyncAutomated Continuous Azure DevOps Replication to Apache Kafka
Apache NiFiJDBCBridge Azure DevOps Connectivity with Apache NiFi
AWS GlueConnect CloudBuild ETL Jobs with Azure DevOps Data in AWS Glue Jobs
Azure Data FactoryConnect CloudImport Azure DevOps Data Using Azure Data Factory
Azure Data LakeCData SyncAutomated Continuous Azure DevOps Replication to Azure Data Lake
Azure SynapseCData SyncAutomated Continuous Azure DevOps Replication to Azure Synapse
BIMLSSISUse Biml to Build SSIS Tasks to Replicate Azure DevOps to SQL Server
CloverDXJDBCConnect to Azure DevOps in CloverDX (formerly CloverETL)
CouchbaseCData SyncAutomated Continuous Azure DevOps Replication to Couchbase
CSVCData SyncAutomated Continuous Azure DevOps Replication to Local Delimited Files
DatabricksCData SyncAutomated Continuous Azure DevOps Replication to Databricks
ETL ValidatorJDBCHow to Work with Azure DevOps in ETL Validator
FoxProODBCWork with Azure DevOps in FoxPro
Google AlloyDBCData SyncAutomated Continuous Azure DevOps Replication to Google AlloyDB
Google BigQueryCData SyncAutomated Continuous Azure DevOps Replication to Google BigQuery
Google Cloud SQLCData SyncAutomated Continuous Azure DevOps Replication to Google Cloud SQL
Google Data FusionJDBCBuild Azure DevOps-Connected ETL Processes in Google Data Fusion
Google Data FusionJDBCBuild Pipelines with Live Azure DevOps Data in Google Cloud Data Fusion (CData Connect Cloud)
Heroku / Salesforce ConnectCData SyncReplicate Azure DevOps for Use in Salesforce Connect
HULFT IntegrateJDBCConnect to Azure DevOps in HULFT Integrate
IBM DB2CData SyncAutomated Continuous Azure DevOps Replication to IBM DB2
Informatica CloudJDBCIntegrate Azure DevOps in Your Informatica Cloud Instance
Informatica PowerCenterJDBCCreate Informatica Mappings From/To a JDBC Data Source for Azure DevOps
Jaspersoft ETLJDBCConnect to Azure DevOps in Jaspersoft Studio
Microsoft AccessCData SyncAutomated Continuous Azure DevOps Replication to Microsoft Access
Microsoft Azure TablesCData SyncAutomated Continuous Azure DevOps Replication to Azure SQL
Microsoft Power AutomateConnect CloudBuild Azure DevOps-Connected Automated Tasks with Power Automate (Desktop)
MongoDBCData SyncAutomated Continuous Azure DevOps Replication to MongoDB
MySQLCData SyncAutomated Continuous Azure DevOps Replication to MySQL
Oracle Data IntegratorJDBCETL Azure DevOps in Oracle Data Integrator
Oracle DatabaseCData SyncAutomated Continuous Azure DevOps Replication to Oracle
petlPythonExtract, Transform, and Load Azure DevOps in Python
PostgreSQLCData SyncAutomated Continuous Azure DevOps Replication to PostgreSQL
Replicate to MySQLPowerShellReplicate Azure DevOps to MySQL with PowerShell
SAP HANACData SyncAutomated Continuous Azure DevOps Replication to SAP HANA
SingleStoreCData SyncAutomated Continuous Azure DevOps Replication to SingleStore
SnapLogicJDBCIntegrate Azure DevOps with External Services using SnapLogic (JDBC)
SnapLogicConnect CloudIntegration with Azure DevOps Data in SnapLogic (Connect Cloud)
SnowflakeCData SyncAutomated Continuous Azure DevOps Replication to Snowflake
SQL ServerCData SyncAutomated Continuous Azure DevOps Replication to SQL Server
SQL Server Linked ServerConnect CloudConnect to Azure DevOps Data as a SQL Server Linked Server
SQLiteCData SyncAutomated Continuous Azure DevOps Replication to SQLite
TalendJDBCConnect to Azure DevOps and Transfer Data in Talend
UiPath StudioODBCCreate an RPA Flow that Connects to Azure DevOps in UiPath Studio
VerticaCData SyncAutomated Continuous Azure DevOps Replication to a Vertica Database

Back to top

Data Virtualization



Back to top

Software Development


ProductTechnologyArticle Title
AWS LambdaJDBCAccess Live Azure DevOps Data in AWS Lambda
.NET ChartsADO.NETDataBind Charts to Azure DevOps
.NET QueryBuilderODBCRapidly Develop Azure DevOps-Driven Apps with Active Query Builder
Angular JSConnect ServerUsing AngularJS to Build Dynamic Web Pages with Azure DevOps
Apache SparkJDBCWork with Azure DevOps in Apache Spark Using SQL
AppSheetConnect CloudCreate Azure DevOps-Connected Business Apps in AppSheet
Bubble.ioConnect CloudBuild Azure DevOps-Connected Apps in Bubble
C++BuilderODBCDataBind Controls to Azure DevOps Data in C++Builder
ChoreoConnect CloudBuild Custom Apps on Azure DevOps Data in Choreo
ColdFusionJDBCQuery Azure DevOps in ColdFusion Using JDBC
ColdFusionODBCQuery Azure DevOps in ColdFusion Using ODBC
DashPythonUse Dash & Python to Build Web Apps on Azure DevOps
DelphiODBCDataBind Controls to Azure DevOps Data in Delphi
DevExpressADO.NETDataBind Azure DevOps to the DevExpress Data Grid
EF - Code FirstADO.NETAccess Azure DevOps with Entity Framework 6
EF - LINQADO.NETLINQ to Azure DevOps
EF - MVCADO.NETBuild MVC Applications with Connectivity to Azure DevOps
Filemaker ProODBCBidirectional Access to Azure DevOps from FileMaker Pro
Filemaker Pro (on Mac)JDBCBidirectional Access to Azure DevOps from FileMaker Pro (on Mac)
GoODBCWrite a Simple Go Application to work with Azure DevOps on Linux
Google Apps ScriptConnect CloudConnect to Azure DevOps Data in Google Apps Script
HibernateJDBCObject-Relational Mapping (ORM) with Azure DevOps Entities in Java
IntelliJJDBCConnect to Azure DevOps in IntelliJ
JBossJDBCConnect to Azure DevOps from a Connection Pool in JBoss
JDBIJDBCCreate a Data Access Object for Azure DevOps using JDBI
JitterbitConnect CloudIntegrate with Live Azure DevOps Data in Jitterbit
JRubyJDBCConnect to Azure DevOps in JRuby
MendixConnect CloudBuild Azure DevOps-Connected Apps in Mendix
Microsoft Power AppsConnect CloudIntegrate Live Azure DevOps Data into Custom Business Apps Built in Power Apps
NodeJSConnect CloudQuery Azure DevOps Data in Node.js (via Connect Cloud)
NodeJSODBCQuery Azure DevOps through ODBC in Node.js
OutSystemsConnect CloudCreate Azure DevOps-Connected Enterprise Applications in OutSystems
PHPConnect ServerAccess Azure DevOps in PHP through Connect Server
PHPODBCNatively Connect to Azure DevOps in PHP
PowerBuilderADO.NETConnect to Azure DevOps from PowerBuilder
PowerShellPowerShellPipe Azure DevOps to CSV in PowerShell
PyCharmODBCUsing the CData ODBC Driver for Azure DevOps in PyCharm
PythonODBCConnect to Azure DevOps in Python on Linux/UNIX
ReactConnect ServerBuild Dynamic React Apps with Azure DevOps Data
RubyODBCConnect to Azure DevOps in Ruby
RunMyProcessConnect CloudConnect to Azure DevOps Data in RunMyProcess
RunMyProcess DSECJDBCConnect to Azure DevOps in DigitalSuite Studio through RunMyProcess DSEC
SAP UI5Connect ServerIntegrate Real-Time Access to Azure DevOps in SAPUI5 MVC Apps
ServoyJDBCBuild Azure DevOps-Connected Apps in Servoy
Spring BootJDBCAccess Live Azure DevOps Data in Spring Boot Apps
SQLAlchemyPythonUse SQLAlchemy ORMs to Access Azure DevOps in Python
TomcatJDBCConfigure the CData JDBC Driver for Azure DevOps in a Connection Pool in Tomcat
UnqorkConnect CloudCreate Azure DevOps-Connected Applications in Unqork
VCL App (RAD Studio)ODBCBuild a Simple VCL Application for Azure DevOps
WebLogicJDBCConnect to Azure DevOps from a Connection Pool in WebLogic

Back to top

Data Management



Back to top

Workflow Automation



Back to top

Ready to get started?

Learn more:

Azure DevOps Connectivity Solutions