Xero Integration Guides and Tutorials

Ready to get started?

Learn more:

Xero Connectivity Solutions

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

CData Software connectivity tools provide access to live Xero data from popular BI, analytics, ETL, and custom applications, offering our customers access to their data wherever they want. Below you will find a list of guides and tutorials for integrating with live Xero 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 Xero in Alteryx Designer
Amazon QuickSightConnect CloudBuild Interactive Dashboards from Xero in Amazon QuickSight
Aqua Data StudioJDBCConnect to Xero in Aqua Data Studio
AWS DatabricksJDBCProcess & Analyze Xero Data in Databricks (AWS)
Azure Analysis ServicesConnect CloudModel Xero Data Using Azure Analysis Services
BirstJDBCBuild Visualizations of Xero in Birst
BIRTJDBCDesign BIRT Reports on Xero
Clear AnalyticsODBCBuild Charts with Xero in Clear Analytics
Cognos Analytics (On-Prem)Connect CloudAnalyze Xero Data in Cognos Analytics
DBxtraODBCBuild Dashboards with Xero in DBxtra
DomoODBCCreate Datasets from Xero in Domo Workbench
Dundas BIODBCBuild Dashboards with Xero in Dundas BI
Excel (on Mac OS)ODBCWork with Xero Data in MS Excel on Mac OS X
FineReportJDBCFeed Xero into FineReport
Google SheetsConnect CloudAccess Live Xero in Google Sheets
IBM Cognos BIODBCCreate Data Visualizations in Cognos BI with Xero
Infragistics RevealConnect CloudAnalyze Xero Data in Infragistics Reval
JasperServerJDBCCreate Xero Reports on JasperReports Server
Jaspersoft BI SuiteJDBCConnect to Xero in Jaspersoft Studio
JReport DesignerJDBCIntegrate with Xero in JReport Designer
KlipfolioConnect CloudCreate Xero-Connected Visualizations in Klipfolio
KNIMEJDBCEnable the Xero JDBC Driver in KNIME
LINQPadADO.NETWorking with Xero in LINQPad
LookerConnect CloudAnalyze Xero in Looker
Looker StudioConnect CloudCreate Reports from Xero in Looker Studio
MetabaseConnect CloudCreate Interactive Xero-Connected Metabase Dashboards
Microsoft ExcelExcelExcel Spreadsheet Automation with the QUERY Formula
Microsoft Excel 365Connect CloudAccess Live Xero Data in Excel 365
Microsoft SSASADO.NETBuild an OLAP Cube in SSAS from Xero
MicroStrategyConnect CloudConnect to Live Xero in MicroStrategy through Connect Cloud
MicroStrategyJDBCUse the CData JDBC Driver for Xero in MicroStrategy
Microstrategy DesktopJDBCUse the CData JDBC Driver for Xero in MicroStrategy Desktop
Microstrategy WebJDBCUse the CData JDBC Driver for Xero in MicroStrategy Web
Mode AnalyticsConnect CloudCreate Xero-Connected Visualizations in Mode
OBIEEJDBCXero Reporting in OBIEE with the Xero JDBC Driver
pandasPythonUse pandas to Visualize Xero in Python
Pentaho Report DesignerJDBCIntegrate Xero in the Pentaho Report Designer
Power BI DesktopPower BIAuthor Power BI Reports on Real-Time Xero
Power BI ServiceConnect CloudVisualize Live Xero in the Power BI Service
Qlik CloudConnect CloudCreate Apps from Xero in Qlik Sense Cloud
QlikViewODBCConnect to and Query Xero in QlikView over ODBC
RJDBCAnalyze Xero in R (JDBC)
RODBCAnalyze Xero in R (ODBC)
RapidMinerJDBCConnect to Xero in RapidMiner
SAP Analytics CloudConnect CloudAnalyze Xero in SAP Analytics Cloud
SAP Business ObjectsJDBCCreate an SAP BusinessObjects Universe on the CData JDBC Driver for Xero
SAP Crystal ReportsJDBCPublish Reports with Xero in Crystal Reports
SASODBCUse the CData ODBC Driver for Xero in SAS for Real-Time Reporting and Analytics
SAS JMPODBCUse the CData ODBC Driver for Xero in SAS JMP
SisenseJDBCVisualize Live Xero in Sisense
Spago BIJDBCConnect to Xero in SpagoBI
TableauTableauVisualize Xero in Tableau Desktop
Tableau CloudConnect CloudBuild Xero Visualizations in Tableau Cloud
Tableau ServerTableauPublish Xero-Connected Dashboards in Tableau Server
TIBCO SpotfireADO.NETVisualize Xero in TIBCO Spotfire through ADO.NET
TIBCO Spotfire ServerJDBCOperational Reporting on Xero from Spotfire Server
VisioODBCLink Visio Shapes to Xero
Zoho AnalyticsConnect CloudCreate Xero-Connect Dashboards in Zoho Analytics

Back to top

ETL & Replication

ProductTechnologyArticle Title
Amazon RedshiftCData SyncAutomated Continuous Xero Replication to Amazon Redshift
Amazon S3CData SyncAutomated Continuous Xero Replication to Amazon S3
Apache AirflowJDBCBridge Xero Connectivity with Apache Airflow
Apache CamelJDBCIntegrate with Xero using Apache Camel
Apache NiFiJDBCBridge Xero Connectivity with Apache NiFi
Apache NiFi Batch OperationsJDBCPerform Batch Operations with Xero Data in Apache NiFi
AWS GlueConnect CloudConnect to Xero in AWS Glue Jobs
Azure Data FactoryConnect CloudImport Xero Data Using Azure Data Factory
Azure Data LakeCData SyncAutomated Continuous Xero Replication to Azure Data Lake
Azure SynapseCData SyncAutomated Continuous Xero Replication to Azure Synapse
BIMLSSISUse Biml to Build SSIS Tasks to Replicate Xero to SQL Server
CloverDXJDBCConnect to Xero in CloverDX (formerly CloverETL)
DatabricksCData SyncAutomated Continuous Xero Replication to Databricks
FoxProODBCWork with Xero in FoxPro
Google AlloyDBCData SyncAutomated Continuous Xero Replication to Google AlloyDB
Google BigQueryCData SyncAutomated Continuous Xero Replication to Google BigQuery
Google Cloud SQLCData SyncAutomated Continuous Xero Replication to Google Cloud SQL
Google Data FusionJDBCBuild Xero-Connected ETL Processes in Google Data Fusion
HULFT IntegrateJDBCConnect to Xero in HULFT Integrate
Informatica CloudJDBCIntegrate Xero in Your Informatica Cloud Instance
Informatica PowerCenterJDBCCreate Informatica Mappings From/To a JDBC Data Source for Xero
Jaspersoft ETLJDBCConnect to Xero in Jaspersoft Studio
Microsoft ExcelExcelTransfer Data from Excel to Xero
Microsoft Power AutomateConnect CloudBuild Xero-Connected Automated Tasks with Power Automate (Desktop)
Oracle Data IntegratorJDBCETL Xero in Oracle Data Integrator
petlPythonExtract, Transform, and Load Xero in Python
Replicate to CSVPowerShellReplicate Xero to MySQL with PowerShell
SAP HANACData SyncAutomated Continuous Xero Replication to SAP HANA
SingleStoreCData SyncAutomated Continuous Xero Replication to SingleStore
SnapLogicJDBCIntegrate Xero with External Services using SnapLogic
SnowflakeCData SyncAutomated Continuous Xero Replication to Snowflake
SQL Server Linked ServerConnect CloudConnect to Xero as a SQL Server Linked Server
TalendJDBCConnect to Xero and Transfer Data in Talend
UiPath StudioODBCCreate an RPA Flow that Connects to Xero in UiPath Studio
VerticaCData SyncAutomated Continuous Xero Replication to a Vertica Database

Back to top

Data Virtualization

Back to top

Software Development

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

Back to top

Data Management

Back to top

Workflow Automation

Back to top