Connect to Xero Online Accounting through easy-to-use, bi-directional drivers.


Integrate with BI, Reporting, Analytics, ETL Tools, and Custom Solutions.

"Excellent stuff. I am finally getting the hang of this and it is brilliant may I add!"

- Mark Couvaras, General Manager, Databarracks




BI & Analytics



Our drivers offer the fastest and easiest way to connect real-time Xero data with BI, analytics, reporting and data visualization technologies. They provide unmatched query performance, comprehensive access to Xero data and metadata, and seamlessly integrate with your favorite analytics tools.

LEARN MORE: Connectivity for BI & Analytics

Popular BI & Analytics Integrations



Alteryx Designer: Prepare, Blend, and Analyze Xero in Alteryx Designer Amazon QuickSight: Build Interactive Dashboards from Xero in Amazon QuickSight Aqua Data Studio: Connect to Xero in Aqua Data Studio Birst: Build Visualizations of Xero in Birst BIRT: Design BIRT Reports on Xero Clear Analytics: Build Charts with Xero in Clear Analytics Microsoft Excel: Excel Spreadsheet Automation with the QUERY Formula DBxtra: Build Dashboards with Xero in DBxtra Domo: Create Datasets from Xero in Domo Workbench Dundas BI: Build Dashboards with Xero in Dundas BI FineReport: Feed Xero into FineReport Google Data Studio: Create Reports from Xero in Google Data Studio IBM Cognos BI: Create Data Visualizations in Cognos BI with Xero JasperServer: Create Xero Reports on JasperReports Server Jaspersoft BI Suite: Connect to Xero in Jaspersoft Studio JReport Designer: Integrate with Xero in JReport Designer KNIME: Enable the Xero JDBC Driver in KNIME LINQPad: Working with Xero in LINQPad Power BI Desktop: Author Power BI Reports on Real-Time Xero Power BI Online: Visualize Live Xero in the Power BI Service Microsoft SSAS: Build an OLAP Cube in SSAS from Xero MicroStrategy: Use the CData JDBC Driver for Xero in MicroStrategy OBIEE: Xero Reporting in OBIEE with the Xero JDBC Driver Pentaho Report Designer: Integrate Xero in the Pentaho Report Designer QlikView: Connect to and Query Xero in QlikView over ODBC R: Analyze Xero in R RapidMiner : Connect to Xero in RapidMiner SAP Business Objects: Create an SAP BusinessObjects Universe on the CData JDBC Driver for Xero SAP Crystal Reports: Publish Reports with Xero in Crystal Reports SAP Lumira: Consume Xero OData Feeds in SAP Lumira SAS: Use the CData ODBC Driver for Xero in SAS for Real-Time Reporting and Analytics Sisense: Visualize Live Xero in Sisense Spago BI: Connect to Xero in SpagoBI Tableau: Visualize Xero in Tableau Tableau Online: Build Xero Visualizations in Tableau Online Tableau Server: Publish and Share Xero Dashboards with Tableau Server TIBCO Spotfire: Visualize Xero in TIBCO Spotfire through ADO.NET TIBCO Spotfire Server: Operational Reporting on Xero from Spotfire Server Visio: Link Visio Shapes to Xero

ETL, Replication, & Warehousing



From drivers and adapters that extend your favorite ETL tools with Xero connectivity to ETL/ELT tools for replication — our Xero integration solutions provide robust, reliable, and secure data movement.

Connect your RDBMS or data warehouse with Xero to facilitate operational reporting, offload queries and increase performance, support data governance initiatives, archive data for disaster recovery, and more.

Popular Data Warehousing Integrations



Amazon Redshift: Automated Continuous Xero Replication to Amazon Redshift Amazon S3: Automated Continuous Xero Replication to Amazon S3 Apache Cassandra: Automated Continuous Xero Replication to Apache Cassandra AWS Glue: Connect to Xero in AWS Glue Jobs Using JDBC BIML: Use Biml to Build SSIS Tasks to Replicate Xero to SQL Server CloverDX: Connect to Xero in CloverDX (formerly CloverETL) CSV: Automated Continuous Xero Replication to Local Delimited Files IBM DB2: Automated Continuous Xero Replication to IBM DB2 FoxPro: Work with Xero in FoxPro Google BigQuery: Automated Continuous Xero Replication to Google BigQuery Google Cloud SQL: Automated Continuous Xero Replication to Google Cloud SQL Google Data Fusion: Pipe Xero in Google Data Fusion Heroku / Salesforce Connect: Replicate Xero for Use in Salesforce Connect Informatica Cloud: Integrate Xero in Your Informatica Cloud Instance Informatica PowerCenter: Create Informatica Mappings From/To a JDBC Data Source for Xero Jaspersoft ETL: Connect to Xero in Jaspersoft Studio Microsoft Access: Automated Continuous Xero Replication to Microsoft Access Microsoft Azure Tables: Automated Continuous Xero Replication to Azure SQL Microsoft Excel: Transfer Data from Excel to Xero MongoDB: Automated Continuous Xero Replication to MongoDB MySQL: Automated Continuous Xero Replication to MySQL Oracle Data Integrator: ETL Xero in Oracle Data Integrator Oracle Database: Automated Continuous Xero Replication to Oracle PostgreSQL: Automated Continuous Xero Replication to PostgreSQL Replicate to CSV: Replicate Xero to MySQL with PowerShell Snowflake: Automated Continuous Xero Replication to Snowflake SQL Server: Automated Continuous Xero Replication to SQL Server SQLite: Automated Continuous Xero Replication to SQLite Talend: Connect to Xero and Transfer Data in Talend UiPath Studio: Create an RPA Flow that Connects to Xero in UiPath Studio

Data Management



By supporting popular database protocols like ODBC, JDBC, and ADO.NET, as well as wire-protocol interfaces for SQL Server and MySQL, it is easy to connect to and manage Xero data from a wide range of database management applications.

Popular Data Management Tool Integrations




Developer Tools & Technologies



The easiest way to integrate with Xero from anywhere. Our Xero drivers offer a data-centric model for Xero that dramatically simplifies integration — allowing developers to build higher quality applications, faster than ever before. Learn more about the benefits for developers:



Popular Developer Integrations



.NET Charts: DataBind Charts to Xero .NET QueryBuilder: Rapidly Develop Xero-Driven Apps with Active Query Builder Angular JS: Using AngularJS to Build Dynamic Web Pages with Xero Apache Spark: Work with Xero in Apache Spark Using SQL Microsoft Azure Logic Apps: Trigger Xero IFTTT Flows in Azure App Service ColdFusion: Query Xero in ColdFusion DevExpress: DataBind Xero to the DevExpress Data Grid EF - Code First: Access Xero with Entity Framework 6 EF - LINQ: LINQ to Xero EF - MVC: Build MVC Applications with Connectivity to Xero Filemaker Pro: Bidirectional Access to Xero from FileMaker Pro Go: Write a Simple Go Application to work with Xero on Linux Google Apps Script: Connect to Xero in Google Apps Script Hibernate: Object-Relational Mapping (ORM) with Xero Entities in Java IntelliJ: Connect to Xero in IntelliJ JBoss: Connect to Xero from a Connection Pool in JBoss JDBI: Create a Data Access Object for Xero using JDBI JRuby: Connect to Xero in JRuby NodeJS: Query Xero from Node.js NodeJS: Query Xero as a MySQL Database in Node.js PHP: Access Xero in PHP through the Cloud Hub PHP: Natively Connect to Xero in PHP PowerShell: Pipe Xero to CSV in PowerShell PowerBuilder: Connect to Xero from PowerBuilder PyCharm: Using the CData ODBC Driver for Xero in PyCharm Python: Connect to Xero in Python on Linux/UNIX Ruby: Connect to Xero in Ruby SAP UI5: Integrate Real-Time Access to Xero in SAPUI5 MVC Apps Tomcat: Configure the CData JDBC Driver for Xero in a Connection Pool in Tomcat VCL App (RAD Studio): Build a Simple VCL Application for Xero WebLogic: Connect to Xero from a Connection Pool in WebLogic


When Only the Best Xero Drivers Will Do

See what customers have to say about our products and support.



Industry-Leading Support

Support is not just a part of our business, support is our business. Whenever you need help, please consult the resources below: