CData Software - Knowledge Base



Recent Xero Articles

Query Xero in DataGrip

Create a Data Source for Xero in DataGrip and use SQL to query live Xero Accounting.

Xero Cloud Connectivity

Explore a compilation of guides and tutorials demonstrating how to establish connections to Xero Accounting through CData Connect Cloud using different applications and tools.

Connect to Xero as a Linked Server

Use the SQL Gateway and the ODBC Driver to set up a linked server for Xero Accounting.

Operational Reporting on Xero from Spotfire Server

Create and share Spotfire data visualizations with real-time connectivity to remote Xero Accounting.

Work with Live Xero in Power Query

Use CData Connect Cloud to connect to Xero Accounting and work with live Xero Accounting in Microsoft Power Query.

Use the CData Software JDBC Driver for Xero in MicroStrategy Web

Connect to Xero Accounting in MicroStrategy Web using the CData Software JDBC Driver for Xero.

How to Build an ETL App for Xero in Python with CData

Create ETL applications and real-time data pipelines for Xero Accounting in Python with petl.

Query Xero as a MySQL Database in Node.js

Execute MySQL queries against Xero Accounting from Node.js.

How to connect and process Xero from Azure Databricks

Use CData, Azure, and Databricks to perform data engineering and data science on live Xero

Feed Xero into FineReport

How to set Xero Accounting as a JDBC data source in FineReport.

Build Xero-Connected Dashboards Using Zoho Analytics

Use CData Connect Cloud to connect to Xero from Zoho Analytics and import live Xero Accounting.

Connect to and Visualize Live Xero in Tableau Prep

Use CData Tableau Connectors and Tableau Prep Builder to visualize live Xero Accounting.

Connect to Xero in Ruby

Connect to Xero Accounting in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

Create Data Visualizations Based On Xero in Mode

Use CData Connect Cloud to connect to Xero from Mode and build visualizations using live

Build Xero-Connected Apps in Choreo

Use CData Connect Cloud to connect to Xero from Choreo and build custom apps using live Xero Accounting.

LINQ to Xero

LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Xero Data Provider.

Connect to Xero as a SQL Server Linked Server

Use CData Connect Cloud to create a linked server for live Xero Accounting.

Create Xero-Connected Enterprise Applications in OutSystems

Use CData Connect Cloud to connect to Xero from OutSystems and build custom enterprise apps using live Xero Accounting.

Automated Continuous Xero Replication to MongoDB

Use CData Sync for automated, continuous, customizable Xero replication to MongoDB.

How to Create Power BI Visual Reports with Real-Time Xero

Use CData Power BI Connectors to visualize Xero Accounting in Power BI.

Visualize Xero in TIBCO Spotfire through ADO.NET

Integrate Xero Accounting into dashboards in TIBCO Spotfire.

Build Dashboards with Xero in Dundas BI

Create dynamic dashboards and perform analytics based on Xero Accounting in Dundas BI.

Viewing Xero in RAD Studio Data Explorer

How to view Xero Accounting in RAD Studio Data Explorer using the CData ODBC Driver for Xero.

Connect to Xero through External Services in Salesforce

Use CData Connect Cloud to securely provide OData feeds of Xero Accounting to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Xero objects that you can access from apps and the dashboard.

Automated Xero Replication to Teradata

Use CData Sync to Customize and automate Xero Accounting replication to Teradata.

Automated Continuous Xero Replication to MySQL

Use CData Sync for automated, continuous, customizable Xero replication to MySQL.

Use the CData ODBC Driver for Xero in Microsoft Power Query

You can use the CData Xero ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Xero Accounting into Microsoft Power Query.

Create a Private/Public Key Pair with Certificate Generator

Information on how to use the Certificate Generator application to create public and private keypairs.

Connect to Xero in Airbyte ELT Pipelines

Use CData Connect Cloud to build ELT pipelines for Xero Accounting in Airbyte.

Connect to Xero from a Connection Pool in JBoss

Integrate Xero Accounting into Java servlets: Use the Management Console in JBoss to install the Xero JDBC Driver.

Configure the CData JDBC Driver for Xero in a Connection Pool in Tomcat

Connect to Xero Accounting from a connection pool in Tomcat.

Automated Continuous Xero Replication to PostgreSQL

Use CData Sync for automated, continuous, customizable Xero replication to PostgreSQL.

PowerShell Scripting to Replicate Xero to MySQL

Write a simple PowerShell script to replicate Xero Accounting to a MySQL database.

Connect to Xero from HeidiSQL

Use CData Connect Cloud to connect to and query live Xero Accounting from HeidiSQL.

Establish a Live Connection with Xero using Tableau Bridge

The CData ODBC Driver for Xero enables you to integrate live Xero Accounting into Tableau Cloud dashboards using the Tableau Bridge.

Integrate Xero in Your Informatica Cloud Instance

Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Xero Accounting from Informatica Cloud.

How to Connect to & Open Xero in Microsoft Excel

This article uses the CData ODBC driver for Xero to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

Use the CData Software ODBC Driver for Xero in MicroStrategy

Connect to Xero Accounting in MicroStrategy Developer using the CData Software ODBC Driver for Xero.

Integrate Xero with External Services using SnapLogic

Use CData JDBC drivers in SnapLogic to integrate Xero with External Services.

Design BIRT Reports on Xero

Provide current Xero Accounting to your embedded analytics.

Create Xero Dashboards in Bold BI

Use CData Software Connect Server to create a virtual SQL Server Database for Xero Accounting to build custom dashboards in Bold BI.

Connect to Xero as an External Data Source using PolyBase

Use CData Connect Cloud and PolyBase to create an external data source in SQL Swerver with access to live Xero Accounting.

Connect to Xero from Filemaker Pro (Mac)

Use CData Connect Cloud to connect to and query live Xero Accounting from Filemaker Pro on Mac.

Use Biml to Build SSIS Tasks to Replicate Xero to SQL Server

Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Xero Accounting to SQL Server.

Connect to Xero in DBeaver

Use the CData ODBC Driver to connect to Xero Accounting in DBeaver.

Explore Geographical Relationships in Xero with Power Map

Create data visualizations with Xero Accounting in Power Map.

View Reports on Real-Time Xero in Power BI Report Server

Use the CData ODBC Driver for Xero to visualize Xero Accounting in Power BI Desktop and then publish them to Power BI Report Server.

Integrating Xero in Talend Cloud Data Management Platform

Connect Xero with Talend Cloud Data Management Platform using the [product_name].

How to publish and share Xero dashboards with Tableau Server

The CData ODBC driver for Xero enables you integrate Xero Accounting into Tableau dashboards.

How to integrate Metabase with Xero

Use CData Connect Cloud to connect to live Xero Accounting and create an interactive dashboard in Metabase from Xero Accounting.

Automated Continuous Xero Replication to SQLite

Use CData Sync for automated, continuous, customizable Xero replication to SQLite.

Create Xero-Connected Business Apps in AppSheet

Connect to Xero via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to Xero Accounting.

Visualize Xero in TIBCO Spotfire through ODBC

The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Xero Accounting into TIBCO Spotfire.

Build Xero-Connected ETL Processes in Google Data Fusion

Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Xero Accounting.

How to connect to Xero from IntelliJ

Integrate connectivity to Xero Accounting with wizards in IntelliJ.

Query Xero in MySQL Workbench

Create a virtual MySQL database for Xero Accounting in CData Software Connect (or Connect Server) and work with live Xero Accounting in MySQL Workbench.

Query Xero in ColdFusion

Write standard ColdFusion data access code to connect to Xero Accounting.

Automated Continuous Xero Replication to SQL Server

Use CData Sync for automated, continuous, customizable Xero replication to SQL Server.

Connect to Xero in as an External Source in Dremio

Use the CData JDBC Driver to connect to Xero as an External Source in Dremio.

Stream Xero into Apache Kafka Topics

Access and stream Xero Accounting in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

Use the CData SSIS Components to Insert New or Update Existing Xero Records from SQL Server

Easily push SQL Server data to Xero using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Xero or update existing records with data from a SQL Server database.

Connect to Xero in JRuby

Create a simple JRuby app with access to live Xero Accounting.

How to connect to Xero with Squirrel SQL client

Connect to Xero Accounting and execute queries in the Squirrel SQL Client.

Access Xero in Mule Applications Using the CData JDBC Driver

Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Xero Accounting.

Automated Continuous Xero Replication to Microsoft Access

Use CData Sync for automated, continuous, customizable Xero replication to Microsoft Access.

Access Xero from MySQL in PHP

Connect to Xero through the standard MySQL libraries in PHP.

Bidirectional Access to Xero from FileMaker Pro

Use the MySQL Remoting feature of the JDBC driver to integrate Xero Accounting in Filemaker Pro for Mac or Windows.

Create Informatica Mappings From/To an ODBC Data Source for Xero

Create an ODBC connection to Xero in Informatica and browse and transfer Xero Accounting.

Publish Crystal Reports on Xero

Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Xero Accounting.

A PostgreSQL Interface for Xero

Use the SQL Gateway and Xero ODBC Driver to create a PostgreSQL entry-point for data access.

How to Connect the Power BI Service to Xero: Complete Guide

Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.

Replicate Xero to Multiple Databases

Replicate Xero Accounting to disparate databases with a single configuration.

Build Xero-Connected Apps in Bubble

Use CData Connect Cloud to create an OData feed for Xero and create custom apps in Bubble.

How to Access Live Xero in Power Automate Desktop via ODBC

The CData ODBC Driver for Xero enables you to integrate Xero Accounting into workflows built using Microsoft Power Automate Desktop.

Export Data from SQL Server to Xero through SSIS

Easily push SQL Server data to Xero using the CData SSIS Tasks for Xero.

How to Connect to Xero in Using Python: 6 Steps

Create Python applications on Linux/UNIX machines with connectivity to Xero Accounting. Leverage the pyodbc module for ODBC in Python.

Create CRM Accounts from QuickBooks Customers

10 steps to automate the transfer your QuickBooks customers into Dynamics CRM accounts.

Load Xero to a Database Using Embulk

Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Xero Accounting to a database.

Create Xero-Connected Visualizations in Klipfolio

Use CData Connect Cloud to connect to Xero from Klipfolio and build custom visualizations using live Xero Accounting.

Create Informatica Mappings From/To a JDBC Data Source for Xero

Create Xero data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

Visualize Live Xero in Tableau

Use CData Tableau Connectors and Tableau Desktop to visualize live Xero Accounting.

Integrate Xero into Automated Tasks with Power Automate

Use CData Connect Cloud to connect to Xero Accounting and integrate live Xero Accounting into your Power Automate tasks.

Connect to Xero in NetBeans

Connect to Xero Accounting in NetBeans with the data source configuration wizard.

Analyze Xero in Cognos Analytics

Use CData Connect Cloud to connect to Xero from Cognos Analytics and analyze live Xero Accounting.

Enable the Xero JDBC Driver in KNIME

Use standard data access components in KNIME to create charts and reports with Xero Accounting.

Automate Xero Replication to Couchbase

Use CData Sync to Customize and automate Xero Accounting replication to Couchbase.

Analyze Xero in R

Use standard R functions and the development environment of your choice to analyze Xero Accounting with the CData JDBC Driver for Xero.

Analyze Xero in Infragistics Reveal

Use CData Connect Cloud to create on OData API on top of Xero Accounting and visualize live Xero Accounting in Infragistics Reveal.

How to Query Xero in MySQL Workbench

Execute MySQL queries against live Xero Accounting from MySQL Workbench.

Automated Continuous Xero Replication to Amazon S3

Use CData Sync for automated, continuous, customizable Xero replication to Amazon S3.

Create SSAS Tabular Models from Xero

How to build a SQL Server Analysis Service Tabular Model from Xero Accounting using CData drivers.

Object-Relational Mapping (ORM) with Xero Entities in Java

Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Xero Accounting into a Java-based ORM framework, Hibernate.

Use the CData Software ODBC Driver for Xero in SAS for Real-Time Reporting and Analytics

Connect to real-time Xero Accounting in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Xero.

Xero Reporting in OBIEE with the Xero JDBC Driver

Deploy the Xero JDBC driver on OBIEE to provide real-time reporting across the enterprise.

Connect to and Query Xero in QlikView over ODBC

Create data visualizations with Xero Accounting in QlikView.

Build Charts with Xero in Clear Analytics

Create dynamic charts and perform analytics based on Xero Accounting in Clear Analytics.

Back Up Xero Accounting to SQL Server through SSIS

Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Xero. In this article, we will employ an SSIS workflow to populate a database with Xero Accounting data.

How to use SQLAlchemy ORM to access Xero in Python

Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Xero Accounting.

Automate Xero Replication to SAP HANA

Use CData Sync to customize and automate Xero Accounting replication to SAP HANA.

Perform Batch Operations with Xero in Apache NiFi

Connect to Xero Accounting and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

Publish Xero-Connected Dashboards in Tableau Server

Use CData Tableau Connectors and Tableau Server to visualize live Xero Accounting.

Access Xero from MySQL in HeidiSQL

Use CData ODBC Driver and SQL Gateway to connect and query live Xero Accounting from HeidiSQL.

Use the CData Software ODBC Driver for Xero in MicroStrategy Web

Connect to Xero Accounting in MicroStrategy Web using the CData Software ODBC Driver for Xero.

How to create Visio diagrams from Xero

Automatically update Xero Accounting with the changes you make to Visio master shapes.

Automated Continuous Xero Replication to Google BigQuery

Use CData Sync for automated, continuous, customizable Xero replication to Google BigQuery.

Creating Xero-Connected Applications in Unqork

You can use CData Connect Cloud to feed Xero Accounting to Unqork and build custom business apps.

Connect to Xero in DigitalSuite Studio through RunMyProcess DSEC

Use Arkobi Digital

How to import Xero into Apache Solr

Use the CData Software JDBC Driver for Xero in Data Import Handler and create an automated import of Xero Accounting to Apache Solr Enterprise Search platform.

DataBind Controls to Xero in C++Builder

DataBind to Xero Accounting in C++Builder with standard components and controls.

Connect to Xero in Google Apps Script

Use CData Connect Cloud to access Xero Accounting in Google Apps Script.

Connect to Xero from Asprova with CData Software ODBC Driver for Xero

This article shows how to connect faster to Xero data from Asprova.

Connect to Xero from AWS Glue

Use CData Connect Cloud to gain access to live Xero Accounting from your AWS Glue jobs.

How to Import Xero into SQL Server using SSIS

Easily back up Xero Accounting to SQL Server using the SSIS components for Xero.

How to connect Amazon QuickSight to Xero

Create a connection to Xero Accounting in CData Connect Cloud and insert Xero Accounting into Amazon QuickSight SPICE to build interactive dashboards.

Create Apps from Xero in Qlik Sense Cloud

Use CData Connect Cloud to connect to Xero and build apps from live Xero Accounting in Qlik Sense Cloud.

How to connect to Xero from Spring Boot

Connect to Xero in a Spring Boot Application using CData JDBC Xero Driver

ETL Xero in Oracle Data Integrator

This article shows how to transfer Xero Accounting into a data warehouse using Oracle Data Integrator.

How to Visualize Xero Data in Python with pandas

Use pandas and other modules to analyze and visualize live Xero Accounting in Python.

Automated Continuous Xero Replication to IBM DB2

Use CData Sync for automated, continuous, customizable Xero replication to IBM DB2.

Automated Continuous Xero Replication to Vertica

Use CData Sync for automated, continuous, customizable Xero replication to Vertica.

Use the CData Software JDBC Driver for Xero in MicroStrategy Desktop

Connect to Xero Accounting in MicroStrategy Desktop using the CData Software JDBC Driver for Xero.

How to pipe Xero to CSV in PowerShell

Use standard PowerShell cmdlets to access Xero tables.

Access Live Xero in Excel 365 Online (Excel for the web)

Connect to Xero Accounting from Excel 365 Online (Excel for the web) with CData Connect Cloud.

Create Data Visualizations in Cognos BI with Xero

Access Xero Accounting as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

Integrate Live Xero into Amazon SageMaker Canvas with RDS

Use CData Connect Cloud to connect to Xero from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Xero Accounting.

Automated Continuous Xero Replication to Apache Cassandra

Use CData Sync for automated, continuous, customizable Xero replication to Apache Cassandra.

How to create Xero federated tables in MySQL

Use the SQL Gateway and the ODBC Driver to set up federated tables for Xero Accounting in MySQL .

Build an OLAP Cube in SSAS from Xero

Establish a connection to Xero Accounting data from SQL Server Analysis Services, and use the Xero Data Provider to build OLAP cubes for use in analytics and reporting.

Import Real-Time Xero in ColdFusion to Build Applications

Use CData JDBC drivers to import and use Xero Accounting in ColdFusion.

Connect to Xero from a Connection Pool in Jetty

The Xero JDBC Driver supports connection pooling: This article shows how to connect faster to Xero Accounting from Web apps in Jetty.

Build Xero-Connected Visualizations in datapine

Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Xero Accounting.

Replicate Xero from PowerShell

Write a quick PowerShell script to query Xero Accounting. Use connectivity to the live data to replicate Xero Accounting to SQL Server.

How to update Xero from Excel

This article explains how to transfer data from Excel to Xero using the Excel Add-In for Xero.

Build Xero Visualizations in Tableau Cloud

Use CData Connect Cloud to connect to live Xero Accounting and build visualizations in Tableau Cloud.

Import Real-Time Xero in ColdFusion to Build Applications

Use CData ODBC drivers to import and use Xero Accounting in ColdFusion.

Prepare, Blend, and Analyze Xero in Alteryx Designer

Build workflows to access live Xero Accounting for self-service data analytics.

How to connect to Xero from MS Excel on Mac OS X

Create a Data Source Name in iODBC with the CData ODBC Driver for Xero and work with Xero Accounting in Microsoft Excel on Mac OS X.

Access Xero as a Remote Oracle Database

Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Xero Accounting from your Oracle system.

Visualize Xero in TIBCO Spotfire through OData

Integrate Xero Accounting into dashboards in TIBCO Spotfire.

Connect to Xero from a Connection Pool in WebLogic

Use the CData JDBC Driver for Xero to connect to Xero Accounting from Web applications running on WebLogic.

Connect to Xero in SpagoBI

Create reports featuring live Xero Accounting in SpagoBI Studio. Host Xero reports on SpagoBI Server.

Query, Visualize, and Share live Xero in Redash

Use CData Connect Cloud to connect to live Xero Accounting in Redash for querying, visualizing, and sharing.

Automated Continuous Xero Replication to Oracle

Use CData Sync for automated, continuous, customizable Xero replication to Oracle.

Connect to Xero in Google Apps Script

Use the ODBC Driver for Xero and the SQL Gateway to access Xero Accounting from Google Apps Script.

Visualize Live Xero in the Power BI Service

Use CData Connect Cloud to connect to live Xero Accounting and create custom reports in the Power BI Service through the On-Premises Gateway.

Analyze Xero in SAP Analytics Cloud

Use CData Connect Cloud to create an OData API on top of Xero Accounting and visualize Xero Accounting in SAP Analytics Cloud.

Xero Reporting and Star Schemas in OBIEE

Create a star schema that shows perspectives on Xero facts in real time.

Use the CData Software ODBC Driver for Xero in MicroStrategy Desktop

Connect to Xero Accounting in MicroStrategy Desktop using the CData Software ODBC Driver for Xero.

Create Xero Dataflows on PowerBI.com

Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.

Visualize Xero in Tableau Desktop (through CData Connect)

Create a virtual SQL Server database for Xero Accounting in CData Software Connect (or Connect Server) and build visualizations from live Xero Accounting in Tableau Desktop.

How to Work with Xero in ETL Validator JDBC

Connect to Xero from ETL Validator jobs using the CData Software JDBC Driver.

How to Build Dynamic React Apps with Xero

Use the CData Connect and React to Build Dynamic Web Apps with Live Xero .

Use Dash to Build to Web Apps on Xero

Create Python applications that use pandas and Dash to build Xero-connected web apps.

Replicate Xero for Use in Salesforce Connect

Replicate Xero Accounting to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

Manage Xero in DBArtisan as a JDBC Source

Use wizards in DBArtisan to create a JDBC data source for Xero.

Use JayDeBeApi to access Xero in Python

Use standard Python scripting and the development environment of your choice to access live Xero Accounting.

How to Use a Microsoft Access Database to Update Xero in Real Time

Update Xero data by creating a linked table in Microsoft Access with the CData Xero ODBC Driver.

Automate Xero Integration Tasks from PowerShell

Are you in search of a quick and easy way to access Xero Accounting from PowerShell? This article demonstrates how to utilize the Xero Cmdlets for tasks like connecting to Xero Accounting, automating operations, downloading data, and more.

Create Dynamic Xero Grids Using the Infragistics XamDataGrid

Learn how you can connect Xero to Infragistics XamDataGrid to build dynamic grids.

Use CData Connect Cloud to Access Xero in Microsoft Power Pivot

Use CData Connect Cloud to connect to live Xero Accounting in the Power Pivot business intelligence tool.

Connect to Xero in the Denodo Platform

Use CData driver technologies to create a virtual data source for Xero Accounting in the Denodo Virtual DataPort Administrator.

Connect to Xero in Jaspersoft Studio

Execute SQL to remote Xero Accounting in Jaspersoft Studio.

Bridge Xero Connectivity with Apache NiFi

Access and process Xero Accounting in Apache NiFi using the CData JDBC Driver.

Access Live Xero in TIBCO Data Virtualization

Use the CData Software TIBCO DV Adapter for Xero to create a Xero Accounting source in TIBCO Data Virtualization Studio and gain access to live Xero Accounting from your TDV Server.

Access Live Xero in AWS Lambda (with IntelliJ IDEA)

Connect to live Xero Accounting in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

Visualize Xero in Tableau

The CData ODBC driver for Xero enables you integrate Xero Accounting into Tableau dashboards.

Build Pipelines with Live Xero in Google Cloud Data Fusion (via CData Connect Cloud)

Use CData Connect Cloud to connect to Xero from Google Cloud Data Fusion, enabling the integration of live Xero Accounting into the building and management of effective data pipelines.

Automated Continuous Xero Replication to Azure SQL

Use CData Sync for automated, continuous, customizable Xero replication to Azure SQL.

How to Work with Xero in AWS Glue Jobs Using JDBC

Connect to Xero from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

Build Semantic Layer Views for Xero in APOS Live Data Gateway

Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for Xero Accounting.

Replicate Xero to Multiple Databases

Replicate Xero Accounting to disparate databases with a point-and-click configuration.

Connect to Live Xero in MicroStrategy through CData Connect Cloud

Create a live connection to Xero in CData Connect Cloud and connect to your Xero Accounting from MicroStrategy.

Create an SAP BusinessObjects Universe on the CData JDBC Driver for Xero

Provide connectivity to Xero Accounting through an SAP BusinessObjects universe.

Build Semantic Layer Views for Xero in APOS Live Data Gateway

Use the CData Connector for Xero in APOS Live Data Gateway to build Semantic Layer Views for Xero Accounting.

Publish Reports with Xero in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date Xero Accounting.

Connect to Xero in RapidMiner

Integrate Xero Accounting with standard components and data source configuration wizards in RapidMiner Studio.

Build Xero-Connected Web Apps in Servoy

Use Servoy Developer to easily connect to Xero Accounting and build web apps with connectivity to live Xero Accounting.

Create a Data Access Object for Xero using JDBI

A brief overview of creating a SQL Object API for Xero Accounting in JDBI.

Connect to Xero from Crystal Reports

Use CData Connect Cloud to connect to and report on live Xero Accounting from Crystal Reports.

DataBind Xero to the DevExpress Data Grid

Use the CData Software ADO.NET Provider for Xero with the DevExpress Windows Forms and Web controls to provide Xero Accounting to a chart.

How to work with Xero in Apache Spark using SQL

Access and process Xero in Apache Spark using the CData Software JDBC Driver.

How to integrate Xero with Apache Airflow

Access and process Xero Accounting in Apache Airflow using the CData JDBC Driver.

Connect to Live Xero in PostGresSQL Interface through CData Connect Cloud

Create a live connection to Xero in CData Connect Cloud and connect to your Xero Accounting from PostgreSQL.

Natively Connect to Xero in PHP

The CData ODBC driver for Xero enables you to create PHP applications with connectivity to Xero Accounting. Leverage the native support for ODBC in PHP.

Connect to Xero from PowerBuilder

This article demonstrates how to access Xero Accounting from PowerBuilder using the Xero JDBC Driver.

DataBind Charts to Xero

Use the standard ADO.NET procedures for databinding to provide bidirectional access to Xero Accounting from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.

Analyze Xero in R

Create data visualizations and use high-performance statistical functions to analyze Xero Accounting in Microsoft R Open.

Access Live Xero in Google Sheets

Use CData Connect Cloud to gain access to live Xero Accounting from your Google Sheets.

Integrate Live Xero into Custom Business Apps Built in Power Apps

Use CData Connect Cloud to connect to Xero Accounting and integrate live Xero Accounting into apps built in Microsoft Power Apps.

Connect to Xero in CloverDX (formerly CloverETL)

Transfer Xero Accounting using the visual workflow in the CloverDX data integration tool.

Automated Continuous Xero Replication to SingleStore

Use CData Sync for automated, continuous, customizable Xero replication to SingleStore.

Xero: HTTP 503 Rate Limit Exceeded.

What does this mean?

Integrate with Xero using Apache Camel2

Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Xero Accounting to a JSON file on disk.

Build MVC Applications with Connectivity to Xero

This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Xero from an ASP.NET MVC application.

Model Xero Using Azure Analysis Services

Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and Xero, enabling the direct import of real-time Xero Accounting.

Automated Continuous Xero Replication to Google Cloud SQL

Use CData Sync for automated, continuous, customizable Xero replication to Google Cloud SQL.

Connect to Xero in RazorSQL

Connect to Xero from wizards and query Xero Accounting from the GUI in the RazorSQL database management tool.

Integrate Xero into Power Automate Desktop using CData Connect

CData Connect for Xero enables you to integrate Xero Accounting into workflows built using Microsoft Power Automate Desktop.

Create Reports with Xero in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date Xero Accounting.

Query Xero through ODBC in Node.js

Use node-odbc to execute SQL queries against Xero Accounting from Node.js.

Access Live Xero in AWS Lambda

Connect to live Xero Accounting in AWS Lambda using the CData JDBC Driver.

Natively Connect to Xero in PHP

Create PHP applications on Linux/UNIX machines with connectivity to Xero Accounting. Leverage the native support for ODBC in PHP.

Author and Share Power BI Reports on Real-Time Xero

Use the CData ODBC Driver for Xero to visualize Xero Accounting in Power BI Desktop and then upload to the Power BI service.

Connect to Xero in RunMyProcess through Connect Cloud

Use CData Connect Cloud to create on OData API for Xero and connect to Xero Accounting in Akorbi Digital RunMyProcess.

Working with Xero in LINQPad

Execute LINQ queries to Xero Accounting in LINQPad.

Visualize Live Xero in Power BI (via CData Connect Cloud)

Use the CData Power BI Connector and CData Connect Cloud to integrate live Xero Accounting into custom reports in Power BI.

Access Xero from MySQL in Amazon QuickSight

Connect to Xero and build visualizations of Xero Accounting using a MySQL Connection in Amazon QuickSight.

Connect to Xero in HULFT Integrate

Connect to Xero as a JDBC data source in HULFT Integrate

Using the CData Software ODBC Driver for Xero in PyCharm

Connect to Xero as an ODBC data source in PyCharm using the CData Software ODBC Driver for Xero.

Excel Spreadsheet Automation with the QUERY Formula

Pull data, automate spreadsheets, and more with the QUERY formula.

Connect to Xero in DBArtisan

Use wizards in DBArtisan to configure Xero Accounting as a data source.

Automated Continuous Xero Replication to Amazon Redshift

Use CData Sync for automated, continuous, customizable Xero replication to Amazon Redshift.

Build a Simple VCL Application for Xero

How to build a simple VCL Application to view Xero Accounting in RAD Studio using the CData ODBC Driver for Xero.

Validate Xero with QuerySurge

Access and validate Xero Accounting in QuerySurge using the CData JDBC Driver.

Replicate Multiple Xero Accounts

Replicate multiple Xero accounts to one or many databases.

Process & Analyze Xero in Databricks (AWS)

Use CData, AWS, and Databricks to perform data engineering and data science on live Xero .

Work with Xero in FoxPro

Load Xero Accounting into a FoxPro database. This article includes full code and a walk-through of the process.

Analyze Xero with Power Pivot

This article walks you through the process of using the CData ODBC Driver for Xero from Power Pivot. You will use the Table Import Wizard to load Xero Accounting. You can visually build the import query or use any SQL supported by the driver.

A PostgreSQL Interface for Xero

Use the Remoting features of the Xero ODBC Driver to create a PostgreSQL entry-point for data access.

Import Xero into the Power BI Service for Visualizations

Use CData Connect Cloud to connect to Xero and provide access to live Xero Accounting for custom reports in the Power BI Service.

DataBind Controls to Xero in Delphi

DataBind to Xero Accounting in Delphi with standard data access components and controls.

Visualize Xero in Sisense

Create an ElastiCube in Sisense app with access to Xero Accounting.

Automated Continuous Xero Replication to AlloyDB

Use CData Sync for automated, continuous, customizable Xero replication to AlloyDB.

Write a Simple Go Application to work with Xero on Linux

Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Xero Accounting.

How to Connect DBeaver to Xero via a JDBC Driver

Manage Xero Accounting with visual tools in DBeaver like the query browser.

Prepare, Blend, and Analyze Xero in Alteryx Designer

Build workflows to access live Xero Accounting for self-service data analytics.

Automate Xero Replication to Azure Synapse

Use CData Sync to customize and automate Xero Accounting replication to Azure Synapse.

Query Xero as a SQL Server Database in Node.js

Execute SQL Server queries against Xero Accounting from Node.js.

Integrate with Live Xero in MuleSoft (via CData Connect Cloud)

Use CData Connect Cloud to connect to Xero from the MuleSoft Anypoint Platform to integrate live Xero Accounting into custom reports and dashboards.

Using AngularJS to Build Dynamic Web Pages with Xero

Use the CData Connect Server to create Xero OData feeds and build single-page applications with live Xero Accounting.

Create Datasets from Xero in Domo Workbench and Build Visualizations of Xero in Domo

Use the CData Software ODBC Driver for Xero to create datasets from Xero Accounting in Domo Workbench and then build visualizations in the Domo service.

Create Xero Reports on JasperReports Server

Deploy the CData JDBC Driver on JasperReports Server to provide real-time Xero data access from reports, embedded analytics, and more.

Automated Continuous Xero Replication to Databricks

Use CData Sync for automated, continuous, customizable Xero replication to Databricks.

Visualize Xero from Tableau

Use the Tableau Desktop business intelligence tool to connect to Xero Accounting.

Create an SAP BusinessObjects Universe on the CData ODBC Driver for Xero

Provide connectivity to Xero Accounting through an SAP BusinessObjects universe.

Connect to Xero in Aqua Data Studio

Access Xero Accounting from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

How to connect to Xero in DBVisualizer

Integrate Xero Accounting with visual data analysis tools and data connection wizards in DBVisualizer

Edit and Search External Xero Objects in Salesforce Connect

Use CData Connect Cloud to securely provide OData feeds of Xero Accounting to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Xero objects that you can access from apps and the dashboard.

Import and Visualize Xero in Power View

Create data visualizations based on Xero Accounting in Excel.

Build Visualizations of Xero in Birst

Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Xero Accounting in Birst.

Build Dashboards with Xero in DBxtra

Create dynamic dashboards and perform analytics based on Xero Accounting in DBxtra.

Import Xero Using Azure Data Factory

Use CData Connect Cloud to connect to Xero from Azure Data Factory and import live Xero Accounting.

Rapidly Develop Xero-Driven Apps with Active Query Builder

Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.

Create Xero-Connected Nintex Workflows

Use CData Connect Cloud to connect to Xero from Nintex Workflow Cloud and build custom workflows using live Xero Accounting.

Replicate Multiple Xero Accounts

Replicate multiple Xero accounts to one or many databases.

Integrate with live Xero in Jitterbit

Use CData Connect Cloud to connect to and integrate live Xero Accounting in Jitterbit.

Automate Xero Replication to Azure Data Lake

Use CData Sync to customize and automate Xero Accounting replication to Azure Data Lake.

Use the CData ODBC Driver for Xero from SharePoint Excel Services

This article demonstrates how to use the CData ODBC Driver for Xero to connect to Xero Accounting from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Xero Accounting in Excel.

Add Xero to Informatica Enterprise Data Catalog

Use the CData Software JDBC Driver for Xero with the Informatica Enterprise Data Catalog to classify and organize data.

How to create an RPA flow for Xero in UiPath Studio

Use the Xero ODBC Driver to create workflows that access real-time Xero Accounting without any coding.

Connect to Xero from PowerBuilder

This article demonstrates how to use the CData ODBC Driver for Xero to connect to Xero Accounting and execute queries in PowerBuilder.

Use the CData ODBC Driver for Xero in SAS JMP

You can use the CData ODBC Driver to integrate Xero Accounting into the statistical analysis tools available in SAS JMP. This article shows how to use Xero Accounting in the Graph Builder and Query Builder.

Visualize Live Xero of Power BI Report Builder in Power BI Service

Use CData Power BI Connectors to connect to live Xero Accounting using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

Integrate Xero in the Pentaho Report Designer

Publish reports based on Xero Accounting in the Pentaho BI tool.

Use the CData Software JDBC Driver for Xero in MicroStrategy

Connect to Xero Accounting in MicroStrategy Developer using the CData Software JDBC Driver for Xero.

Publish Xero-Connected Dashboards in Tableau Server

Use CData JDBC drivers and Tableau Server to visualize live Xero Accounting.

Connect to Xero from PowerBuilder

This article demonstrates how to access Xero Accounting from Appeon PowerBuilder using the CData ADO.NET Provider for Xero.

DataBind Wijmo Grid to Xero

Provide real-time Xero Accounting to interactive controls.

Deploy the ADO.NET Provider for Xero on an SSRS Report Server

Connect to Xero Accounting from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

Import Xero into FileMaker Pro

Create reports that integrate Xero Accounting in Filemaker Pro.

Create Reports from Xero in Looker Studio

Use CData Connect Cloud to gain access to live Xero Accounting and create custom reports in Looker Studio.

Automated Continuous Xero Replication to Local Delimited Files

Use CData Sync for automated, continuous, customizable Xero replication to delimited files (CSV/TSV).

Integrate with Xero in SnapLogic

Use CData Connect Cloud to connect to and integrate with live Xero Accounting in SnapLogic.

Access Live Xero in Coginiti Pro

Connect to and query live Xero Accounting from the GUI in the Coginiti Pro: SQL Analytics Tool.

Analyze Live Xero in SAS Viya

Use CData Connect Cloud to connect to Xero Accounting from SAS Viya and deploy self-service analytics using live Xero Accounting.

Access Live Xero in Excel (Desktop)

Use CData Connect Cloud to gain access to live Xero Accounting from your Excel spreadsheets.

Analyze Xero in Looker

Use CData Connect Cloud to connect to Xero from Looker and build custom apps using live Xero Accounting.

Access Xero in PHP through Connect Server

Connect to Xero through the standard SQL Server libraries in PHP.

Build Xero-Connected Apps in Mendix

Use CData Connect Cloud to create an OData feed for Xero and create custom apps in Mendix.

Extract, Transform, and Load Xero in Informatica PowerCenter

Create a simple Workflow for Xero Accounting in Informatica PowerCenter.

Integrate with Xero in JReport Designer

Create charts and reports based on Xero Accounting in JReport Designer.

How to connect PolyBase to Xero

Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Xero Accounting.

Automated Continuous Xero Replication to Apache Kafka

Use CData Sync for automated, continuous, customizable Xero replication to Apache Kafka.

Automated Continuous Xero Replication to Snowflake

Use CData Sync for automated, continuous, customizable Xero replication to Snowflake.

Provide OData Services of Xero from a WCF Application

In this article, we will demonstrate the process of generating an OData feed for Xero Accounting by developing a WCF Service Application.

A PostgreSQL Interface for Xero

Use the Remoting features of the Xero JDBC Driver to create a PostgreSQL entry-point for data access.

How to Access Xero Using Entity Framework

This article shows how to access Xero Accounting using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

Query Xero in DataGrip

Create a Data Source for Xero in DataGrip and use SQL to query live Xero Accounting.

Xero Cloud Connectivity

Explore a compilation of guides and tutorials demonstrating how to establish connections to Xero Accounting through CData Connect Cloud using different applications and tools.

Connect to Xero as a Linked Server

Use the SQL Gateway and the ODBC Driver to set up a linked server for Xero Accounting.

Operational Reporting on Xero from Spotfire Server

Create and share Spotfire data visualizations with real-time connectivity to remote Xero Accounting.

Work with Live Xero in Power Query

Use CData Connect Cloud to connect to Xero Accounting and work with live Xero Accounting in Microsoft Power Query.

Use the CData Software JDBC Driver for Xero in MicroStrategy Web

Connect to Xero Accounting in MicroStrategy Web using the CData Software JDBC Driver for Xero.

How to Build an ETL App for Xero in Python with CData

Create ETL applications and real-time data pipelines for Xero Accounting in Python with petl.

Query Xero as a MySQL Database in Node.js

Execute MySQL queries against Xero Accounting from Node.js.

How to connect and process Xero from Azure Databricks

Use CData, Azure, and Databricks to perform data engineering and data science on live Xero

Feed Xero into FineReport

How to set Xero Accounting as a JDBC data source in FineReport.

Build Xero-Connected Dashboards Using Zoho Analytics

Use CData Connect Cloud to connect to Xero from Zoho Analytics and import live Xero Accounting.

Connect to and Visualize Live Xero in Tableau Prep

Use CData Tableau Connectors and Tableau Prep Builder to visualize live Xero Accounting.

Connect to Xero in Ruby

Connect to Xero Accounting in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

Create Data Visualizations Based On Xero in Mode

Use CData Connect Cloud to connect to Xero from Mode and build visualizations using live

Build Xero-Connected Apps in Choreo

Use CData Connect Cloud to connect to Xero from Choreo and build custom apps using live Xero Accounting.

LINQ to Xero

LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Xero Data Provider.

Connect to Xero as a SQL Server Linked Server

Use CData Connect Cloud to create a linked server for live Xero Accounting.

Create Xero-Connected Enterprise Applications in OutSystems

Use CData Connect Cloud to connect to Xero from OutSystems and build custom enterprise apps using live Xero Accounting.

Automated Continuous Xero Replication to MongoDB

Use CData Sync for automated, continuous, customizable Xero replication to MongoDB.

How to Create Power BI Visual Reports with Real-Time Xero

Use CData Power BI Connectors to visualize Xero Accounting in Power BI.

Visualize Xero in TIBCO Spotfire through ADO.NET

Integrate Xero Accounting into dashboards in TIBCO Spotfire.

Build Dashboards with Xero in Dundas BI

Create dynamic dashboards and perform analytics based on Xero Accounting in Dundas BI.

Viewing Xero in RAD Studio Data Explorer

How to view Xero Accounting in RAD Studio Data Explorer using the CData ODBC Driver for Xero.

Connect to Xero through External Services in Salesforce

Use CData Connect Cloud to securely provide OData feeds of Xero Accounting to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Xero objects that you can access from apps and the dashboard.

Automated Xero Replication to Teradata

Use CData Sync to Customize and automate Xero Accounting replication to Teradata.

Automated Continuous Xero Replication to MySQL

Use CData Sync for automated, continuous, customizable Xero replication to MySQL.

Use the CData ODBC Driver for Xero in Microsoft Power Query

You can use the CData Xero ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Xero Accounting into Microsoft Power Query.

Create a Private/Public Key Pair with Certificate Generator

Information on how to use the Certificate Generator application to create public and private keypairs.

Connect to Xero in Airbyte ELT Pipelines

Use CData Connect Cloud to build ELT pipelines for Xero Accounting in Airbyte.

Connect to Xero from a Connection Pool in JBoss

Integrate Xero Accounting into Java servlets: Use the Management Console in JBoss to install the Xero JDBC Driver.

Configure the CData JDBC Driver for Xero in a Connection Pool in Tomcat

Connect to Xero Accounting from a connection pool in Tomcat.

Automated Continuous Xero Replication to PostgreSQL

Use CData Sync for automated, continuous, customizable Xero replication to PostgreSQL.

PowerShell Scripting to Replicate Xero to MySQL

Write a simple PowerShell script to replicate Xero Accounting to a MySQL database.

Connect to Xero from HeidiSQL

Use CData Connect Cloud to connect to and query live Xero Accounting from HeidiSQL.

Establish a Live Connection with Xero using Tableau Bridge

The CData ODBC Driver for Xero enables you to integrate live Xero Accounting into Tableau Cloud dashboards using the Tableau Bridge.

Integrate Xero in Your Informatica Cloud Instance

Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Xero Accounting from Informatica Cloud.

How to Connect to & Open Xero in Microsoft Excel

This article uses the CData ODBC driver for Xero to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

Use the CData Software ODBC Driver for Xero in MicroStrategy

Connect to Xero Accounting in MicroStrategy Developer using the CData Software ODBC Driver for Xero.

Integrate Xero with External Services using SnapLogic

Use CData JDBC drivers in SnapLogic to integrate Xero with External Services.

Design BIRT Reports on Xero

Provide current Xero Accounting to your embedded analytics.

Create Xero Dashboards in Bold BI

Use CData Software Connect Server to create a virtual SQL Server Database for Xero Accounting to build custom dashboards in Bold BI.

Connect to Xero as an External Data Source using PolyBase

Use CData Connect Cloud and PolyBase to create an external data source in SQL Swerver with access to live Xero Accounting.

Connect to Xero from Filemaker Pro (Mac)

Use CData Connect Cloud to connect to and query live Xero Accounting from Filemaker Pro on Mac.

Use Biml to Build SSIS Tasks to Replicate Xero to SQL Server

Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Xero Accounting to SQL Server.

Connect to Xero in DBeaver

Use the CData ODBC Driver to connect to Xero Accounting in DBeaver.

Explore Geographical Relationships in Xero with Power Map

Create data visualizations with Xero Accounting in Power Map.

View Reports on Real-Time Xero in Power BI Report Server

Use the CData ODBC Driver for Xero to visualize Xero Accounting in Power BI Desktop and then publish them to Power BI Report Server.

Integrating Xero in Talend Cloud Data Management Platform

Connect Xero with Talend Cloud Data Management Platform using the [product_name].

How to publish and share Xero dashboards with Tableau Server

The CData ODBC driver for Xero enables you integrate Xero Accounting into Tableau dashboards.

How to integrate Metabase with Xero

Use CData Connect Cloud to connect to live Xero Accounting and create an interactive dashboard in Metabase from Xero Accounting.

Automated Continuous Xero Replication to SQLite

Use CData Sync for automated, continuous, customizable Xero replication to SQLite.

Create Xero-Connected Business Apps in AppSheet

Connect to Xero via CData Connect Cloud in Google AppSheet and create custom business applications with real-time access to Xero Accounting.

Visualize Xero in TIBCO Spotfire through ODBC

The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Xero Accounting into TIBCO Spotfire.

Build Xero-Connected ETL Processes in Google Data Fusion

Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Xero Accounting.

How to connect to Xero from IntelliJ

Integrate connectivity to Xero Accounting with wizards in IntelliJ.

Query Xero in MySQL Workbench

Create a virtual MySQL database for Xero Accounting in CData Software Connect (or Connect Server) and work with live Xero Accounting in MySQL Workbench.

Query Xero in ColdFusion

Write standard ColdFusion data access code to connect to Xero Accounting.

Automated Continuous Xero Replication to SQL Server

Use CData Sync for automated, continuous, customizable Xero replication to SQL Server.

Connect to Xero in as an External Source in Dremio

Use the CData JDBC Driver to connect to Xero as an External Source in Dremio.

Stream Xero into Apache Kafka Topics

Access and stream Xero Accounting in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.

Use the CData SSIS Components to Insert New or Update Existing Xero Records from SQL Server

Easily push SQL Server data to Xero using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Xero or update existing records with data from a SQL Server database.

Connect to Xero in JRuby

Create a simple JRuby app with access to live Xero Accounting.

How to connect to Xero with Squirrel SQL client

Connect to Xero Accounting and execute queries in the Squirrel SQL Client.

Access Xero in Mule Applications Using the CData JDBC Driver

Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Xero Accounting.

Automated Continuous Xero Replication to Microsoft Access

Use CData Sync for automated, continuous, customizable Xero replication to Microsoft Access.

Access Xero from MySQL in PHP

Connect to Xero through the standard MySQL libraries in PHP.

Bidirectional Access to Xero from FileMaker Pro

Use the MySQL Remoting feature of the JDBC driver to integrate Xero Accounting in Filemaker Pro for Mac or Windows.

Create Informatica Mappings From/To an ODBC Data Source for Xero

Create an ODBC connection to Xero in Informatica and browse and transfer Xero Accounting.

Publish Crystal Reports on Xero

Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Xero Accounting.

A PostgreSQL Interface for Xero

Use the SQL Gateway and Xero ODBC Driver to create a PostgreSQL entry-point for data access.

How to Connect the Power BI Service to Xero: Complete Guide

Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.

Replicate Xero to Multiple Databases

Replicate Xero Accounting to disparate databases with a single configuration.

Build Xero-Connected Apps in Bubble

Use CData Connect Cloud to create an OData feed for Xero and create custom apps in Bubble.

How to Access Live Xero in Power Automate Desktop via ODBC

The CData ODBC Driver for Xero enables you to integrate Xero Accounting into workflows built using Microsoft Power Automate Desktop.

Export Data from SQL Server to Xero through SSIS

Easily push SQL Server data to Xero using the CData SSIS Tasks for Xero.

How to Connect to Xero in Using Python: 6 Steps

Create Python applications on Linux/UNIX machines with connectivity to Xero Accounting. Leverage the pyodbc module for ODBC in Python.

Create CRM Accounts from QuickBooks Customers

10 steps to automate the transfer your QuickBooks customers into Dynamics CRM accounts.

Load Xero to a Database Using Embulk

Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Xero Accounting to a database.

Create Xero-Connected Visualizations in Klipfolio

Use CData Connect Cloud to connect to Xero from Klipfolio and build custom visualizations using live Xero Accounting.

Create Informatica Mappings From/To a JDBC Data Source for Xero

Create Xero data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

Visualize Live Xero in Tableau

Use CData Tableau Connectors and Tableau Desktop to visualize live Xero Accounting.

Integrate Xero into Automated Tasks with Power Automate

Use CData Connect Cloud to connect to Xero Accounting and integrate live Xero Accounting into your Power Automate tasks.

Connect to Xero in NetBeans

Connect to Xero Accounting in NetBeans with the data source configuration wizard.

Analyze Xero in Cognos Analytics

Use CData Connect Cloud to connect to Xero from Cognos Analytics and analyze live Xero Accounting.

Enable the Xero JDBC Driver in KNIME

Use standard data access components in KNIME to create charts and reports with Xero Accounting.

Automate Xero Replication to Couchbase

Use CData Sync to Customize and automate Xero Accounting replication to Couchbase.

Analyze Xero in R

Use standard R functions and the development environment of your choice to analyze Xero Accounting with the CData JDBC Driver for Xero.

Analyze Xero in Infragistics Reveal

Use CData Connect Cloud to create on OData API on top of Xero Accounting and visualize live Xero Accounting in Infragistics Reveal.

How to Query Xero in MySQL Workbench

Execute MySQL queries against live Xero Accounting from MySQL Workbench.

Automated Continuous Xero Replication to Amazon S3

Use CData Sync for automated, continuous, customizable Xero replication to Amazon S3.

Create SSAS Tabular Models from Xero

How to build a SQL Server Analysis Service Tabular Model from Xero Accounting using CData drivers.

Object-Relational Mapping (ORM) with Xero Entities in Java

Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Xero Accounting into a Java-based ORM framework, Hibernate.

Use the CData Software ODBC Driver for Xero in SAS for Real-Time Reporting and Analytics

Connect to real-time Xero Accounting in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Xero.

Xero Reporting in OBIEE with the Xero JDBC Driver

Deploy the Xero JDBC driver on OBIEE to provide real-time reporting across the enterprise.

Connect to and Query Xero in QlikView over ODBC

Create data visualizations with Xero Accounting in QlikView.

Build Charts with Xero in Clear Analytics

Create dynamic charts and perform analytics based on Xero Accounting in Clear Analytics.

Back Up Xero Accounting to SQL Server through SSIS

Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Xero. In this article, we will employ an SSIS workflow to populate a database with Xero Accounting data.

How to use SQLAlchemy ORM to access Xero in Python

Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Xero Accounting.

Automate Xero Replication to SAP HANA

Use CData Sync to customize and automate Xero Accounting replication to SAP HANA.

Perform Batch Operations with Xero in Apache NiFi

Connect to Xero Accounting and perform batch operations in Apache NiFi using the CData Software JDBC Driver.

Publish Xero-Connected Dashboards in Tableau Server

Use CData Tableau Connectors and Tableau Server to visualize live Xero Accounting.

Access Xero from MySQL in HeidiSQL

Use CData ODBC Driver and SQL Gateway to connect and query live Xero Accounting from HeidiSQL.

Use the CData Software ODBC Driver for Xero in MicroStrategy Web

Connect to Xero Accounting in MicroStrategy Web using the CData Software ODBC Driver for Xero.

How to create Visio diagrams from Xero

Automatically update Xero Accounting with the changes you make to Visio master shapes.

Automated Continuous Xero Replication to Google BigQuery

Use CData Sync for automated, continuous, customizable Xero replication to Google BigQuery.

Creating Xero-Connected Applications in Unqork

You can use CData Connect Cloud to feed Xero Accounting to Unqork and build custom business apps.

Connect to Xero in DigitalSuite Studio through RunMyProcess DSEC

Use Arkobi Digital

How to import Xero into Apache Solr

Use the CData Software JDBC Driver for Xero in Data Import Handler and create an automated import of Xero Accounting to Apache Solr Enterprise Search platform.

DataBind Controls to Xero in C++Builder

DataBind to Xero Accounting in C++Builder with standard components and controls.

Connect to Xero in Google Apps Script

Use CData Connect Cloud to access Xero Accounting in Google Apps Script.

Connect to Xero from Asprova with CData Software ODBC Driver for Xero

This article shows how to connect faster to Xero data from Asprova.

Connect to Xero from AWS Glue

Use CData Connect Cloud to gain access to live Xero Accounting from your AWS Glue jobs.

How to Import Xero into SQL Server using SSIS

Easily back up Xero Accounting to SQL Server using the SSIS components for Xero.

How to connect Amazon QuickSight to Xero

Create a connection to Xero Accounting in CData Connect Cloud and insert Xero Accounting into Amazon QuickSight SPICE to build interactive dashboards.

Create Apps from Xero in Qlik Sense Cloud

Use CData Connect Cloud to connect to Xero and build apps from live Xero Accounting in Qlik Sense Cloud.

How to connect to Xero from Spring Boot

Connect to Xero in a Spring Boot Application using CData JDBC Xero Driver

ETL Xero in Oracle Data Integrator

This article shows how to transfer Xero Accounting into a data warehouse using Oracle Data Integrator.

How to Visualize Xero Data in Python with pandas

Use pandas and other modules to analyze and visualize live Xero Accounting in Python.

Automated Continuous Xero Replication to IBM DB2

Use CData Sync for automated, continuous, customizable Xero replication to IBM DB2.

Automated Continuous Xero Replication to Vertica

Use CData Sync for automated, continuous, customizable Xero replication to Vertica.

Use the CData Software JDBC Driver for Xero in MicroStrategy Desktop

Connect to Xero Accounting in MicroStrategy Desktop using the CData Software JDBC Driver for Xero.

How to pipe Xero to CSV in PowerShell

Use standard PowerShell cmdlets to access Xero tables.

Access Live Xero in Excel 365 Online (Excel for the web)

Connect to Xero Accounting from Excel 365 Online (Excel for the web) with CData Connect Cloud.

Create Data Visualizations in Cognos BI with Xero

Access Xero Accounting as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

Integrate Live Xero into Amazon SageMaker Canvas with RDS

Use CData Connect Cloud to connect to Xero from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Xero Accounting.

Automated Continuous Xero Replication to Apache Cassandra

Use CData Sync for automated, continuous, customizable Xero replication to Apache Cassandra.

How to create Xero federated tables in MySQL

Use the SQL Gateway and the ODBC Driver to set up federated tables for Xero Accounting in MySQL .

Build an OLAP Cube in SSAS from Xero

Establish a connection to Xero Accounting data from SQL Server Analysis Services, and use the Xero Data Provider to build OLAP cubes for use in analytics and reporting.

Import Real-Time Xero in ColdFusion to Build Applications

Use CData JDBC drivers to import and use Xero Accounting in ColdFusion.

Connect to Xero from a Connection Pool in Jetty

The Xero JDBC Driver supports connection pooling: This article shows how to connect faster to Xero Accounting from Web apps in Jetty.

Build Xero-Connected Visualizations in datapine

Use CData Connect Cloud and datapine to build visualizations and dashboards with access to live Xero Accounting.

Replicate Xero from PowerShell

Write a quick PowerShell script to query Xero Accounting. Use connectivity to the live data to replicate Xero Accounting to SQL Server.

How to update Xero from Excel

This article explains how to transfer data from Excel to Xero using the Excel Add-In for Xero.

Build Xero Visualizations in Tableau Cloud

Use CData Connect Cloud to connect to live Xero Accounting and build visualizations in Tableau Cloud.

Import Real-Time Xero in ColdFusion to Build Applications

Use CData ODBC drivers to import and use Xero Accounting in ColdFusion.

Prepare, Blend, and Analyze Xero in Alteryx Designer

Build workflows to access live Xero Accounting for self-service data analytics.

How to connect to Xero from MS Excel on Mac OS X

Create a Data Source Name in iODBC with the CData ODBC Driver for Xero and work with Xero Accounting in Microsoft Excel on Mac OS X.

Access Xero as a Remote Oracle Database

Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Xero Accounting from your Oracle system.

Visualize Xero in TIBCO Spotfire through OData

Integrate Xero Accounting into dashboards in TIBCO Spotfire.

Connect to Xero from a Connection Pool in WebLogic

Use the CData JDBC Driver for Xero to connect to Xero Accounting from Web applications running on WebLogic.

Connect to Xero in SpagoBI

Create reports featuring live Xero Accounting in SpagoBI Studio. Host Xero reports on SpagoBI Server.

Query, Visualize, and Share live Xero in Redash

Use CData Connect Cloud to connect to live Xero Accounting in Redash for querying, visualizing, and sharing.

Automated Continuous Xero Replication to Oracle

Use CData Sync for automated, continuous, customizable Xero replication to Oracle.

Connect to Xero in Google Apps Script

Use the ODBC Driver for Xero and the SQL Gateway to access Xero Accounting from Google Apps Script.

Visualize Live Xero in the Power BI Service

Use CData Connect Cloud to connect to live Xero Accounting and create custom reports in the Power BI Service through the On-Premises Gateway.

Analyze Xero in SAP Analytics Cloud

Use CData Connect Cloud to create an OData API on top of Xero Accounting and visualize Xero Accounting in SAP Analytics Cloud.

Xero Reporting and Star Schemas in OBIEE

Create a star schema that shows perspectives on Xero facts in real time.

Use the CData Software ODBC Driver for Xero in MicroStrategy Desktop

Connect to Xero Accounting in MicroStrategy Desktop using the CData Software ODBC Driver for Xero.

Create Xero Dataflows on PowerBI.com

Connect to the CData Power BI Connectors from PowerBI.com to create Power BI Dataflows with real-time data.

Visualize Xero in Tableau Desktop (through CData Connect)

Create a virtual SQL Server database for Xero Accounting in CData Software Connect (or Connect Server) and build visualizations from live Xero Accounting in Tableau Desktop.

How to Work with Xero in ETL Validator JDBC

Connect to Xero from ETL Validator jobs using the CData Software JDBC Driver.

How to Build Dynamic React Apps with Xero

Use the CData Connect and React to Build Dynamic Web Apps with Live Xero .

Use Dash to Build to Web Apps on Xero

Create Python applications that use pandas and Dash to build Xero-connected web apps.

Replicate Xero for Use in Salesforce Connect

Replicate Xero Accounting to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.

Manage Xero in DBArtisan as a JDBC Source

Use wizards in DBArtisan to create a JDBC data source for Xero.

Use JayDeBeApi to access Xero in Python

Use standard Python scripting and the development environment of your choice to access live Xero Accounting.

How to Use a Microsoft Access Database to Update Xero in Real Time

Update Xero data by creating a linked table in Microsoft Access with the CData Xero ODBC Driver.

Automate Xero Integration Tasks from PowerShell

Are you in search of a quick and easy way to access Xero Accounting from PowerShell? This article demonstrates how to utilize the Xero Cmdlets for tasks like connecting to Xero Accounting, automating operations, downloading data, and more.

Create Dynamic Xero Grids Using the Infragistics XamDataGrid

Learn how you can connect Xero to Infragistics XamDataGrid to build dynamic grids.

Use CData Connect Cloud to Access Xero in Microsoft Power Pivot

Use CData Connect Cloud to connect to live Xero Accounting in the Power Pivot business intelligence tool.

Connect to Xero in the Denodo Platform

Use CData driver technologies to create a virtual data source for Xero Accounting in the Denodo Virtual DataPort Administrator.

Connect to Xero in Jaspersoft Studio

Execute SQL to remote Xero Accounting in Jaspersoft Studio.

Bridge Xero Connectivity with Apache NiFi

Access and process Xero Accounting in Apache NiFi using the CData JDBC Driver.

Access Live Xero in TIBCO Data Virtualization

Use the CData Software TIBCO DV Adapter for Xero to create a Xero Accounting source in TIBCO Data Virtualization Studio and gain access to live Xero Accounting from your TDV Server.

Access Live Xero in AWS Lambda (with IntelliJ IDEA)

Connect to live Xero Accounting in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.

Visualize Xero in Tableau

The CData ODBC driver for Xero enables you integrate Xero Accounting into Tableau dashboards.

Build Pipelines with Live Xero in Google Cloud Data Fusion (via CData Connect Cloud)

Use CData Connect Cloud to connect to Xero from Google Cloud Data Fusion, enabling the integration of live Xero Accounting into the building and management of effective data pipelines.

Automated Continuous Xero Replication to Azure SQL

Use CData Sync for automated, continuous, customizable Xero replication to Azure SQL.

How to Work with Xero in AWS Glue Jobs Using JDBC

Connect to Xero from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.

Build Semantic Layer Views for Xero in APOS Live Data Gateway

Use the CData Connect Cloud and APOS Live Data Gateway to build Semantic Layer Views for Xero Accounting.

Replicate Xero to Multiple Databases

Replicate Xero Accounting to disparate databases with a point-and-click configuration.

Connect to Live Xero in MicroStrategy through CData Connect Cloud

Create a live connection to Xero in CData Connect Cloud and connect to your Xero Accounting from MicroStrategy.

Create an SAP BusinessObjects Universe on the CData JDBC Driver for Xero

Provide connectivity to Xero Accounting through an SAP BusinessObjects universe.

Build Semantic Layer Views for Xero in APOS Live Data Gateway

Use the CData Connector for Xero in APOS Live Data Gateway to build Semantic Layer Views for Xero Accounting.

Publish Reports with Xero in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date Xero Accounting.

Connect to Xero in RapidMiner

Integrate Xero Accounting with standard components and data source configuration wizards in RapidMiner Studio.

Build Xero-Connected Web Apps in Servoy

Use Servoy Developer to easily connect to Xero Accounting and build web apps with connectivity to live Xero Accounting.

Create a Data Access Object for Xero using JDBI

A brief overview of creating a SQL Object API for Xero Accounting in JDBI.

Connect to Xero from Crystal Reports

Use CData Connect Cloud to connect to and report on live Xero Accounting from Crystal Reports.

DataBind Xero to the DevExpress Data Grid

Use the CData Software ADO.NET Provider for Xero with the DevExpress Windows Forms and Web controls to provide Xero Accounting to a chart.

How to work with Xero in Apache Spark using SQL

Access and process Xero in Apache Spark using the CData Software JDBC Driver.

How to integrate Xero with Apache Airflow

Access and process Xero Accounting in Apache Airflow using the CData JDBC Driver.

Connect to Live Xero in PostGresSQL Interface through CData Connect Cloud

Create a live connection to Xero in CData Connect Cloud and connect to your Xero Accounting from PostgreSQL.

Natively Connect to Xero in PHP

The CData ODBC driver for Xero enables you to create PHP applications with connectivity to Xero Accounting. Leverage the native support for ODBC in PHP.

Connect to Xero from PowerBuilder

This article demonstrates how to access Xero Accounting from PowerBuilder using the Xero JDBC Driver.

DataBind Charts to Xero

Use the standard ADO.NET procedures for databinding to provide bidirectional access to Xero Accounting from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.

Analyze Xero in R

Create data visualizations and use high-performance statistical functions to analyze Xero Accounting in Microsoft R Open.

Access Live Xero in Google Sheets

Use CData Connect Cloud to gain access to live Xero Accounting from your Google Sheets.

Integrate Live Xero into Custom Business Apps Built in Power Apps

Use CData Connect Cloud to connect to Xero Accounting and integrate live Xero Accounting into apps built in Microsoft Power Apps.

Connect to Xero in CloverDX (formerly CloverETL)

Transfer Xero Accounting using the visual workflow in the CloverDX data integration tool.

Automated Continuous Xero Replication to SingleStore

Use CData Sync for automated, continuous, customizable Xero replication to SingleStore.

Xero: HTTP 503 Rate Limit Exceeded.

What does this mean?

Integrate with Xero using Apache Camel2

Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Xero Accounting to a JSON file on disk.

Build MVC Applications with Connectivity to Xero

This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Xero from an ASP.NET MVC application.

Model Xero Using Azure Analysis Services

Leverage CData Connect Cloud to establish a connection between Azure Analysis Services and Xero, enabling the direct import of real-time Xero Accounting.

Automated Continuous Xero Replication to Google Cloud SQL

Use CData Sync for automated, continuous, customizable Xero replication to Google Cloud SQL.

Connect to Xero in RazorSQL

Connect to Xero from wizards and query Xero Accounting from the GUI in the RazorSQL database management tool.

Integrate Xero into Power Automate Desktop using CData Connect

CData Connect for Xero enables you to integrate Xero Accounting into workflows built using Microsoft Power Automate Desktop.

Create Reports with Xero in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date Xero Accounting.

Query Xero through ODBC in Node.js

Use node-odbc to execute SQL queries against Xero Accounting from Node.js.

Access Live Xero in AWS Lambda

Connect to live Xero Accounting in AWS Lambda using the CData JDBC Driver.

Natively Connect to Xero in PHP

Create PHP applications on Linux/UNIX machines with connectivity to Xero Accounting. Leverage the native support for ODBC in PHP.

Author and Share Power BI Reports on Real-Time Xero

Use the CData ODBC Driver for Xero to visualize Xero Accounting in Power BI Desktop and then upload to the Power BI service.

Connect to Xero in RunMyProcess through Connect Cloud

Use CData Connect Cloud to create on OData API for Xero and connect to Xero Accounting in Akorbi Digital RunMyProcess.

Working with Xero in LINQPad

Execute LINQ queries to Xero Accounting in LINQPad.

Visualize Live Xero in Power BI (via CData Connect Cloud)

Use the CData Power BI Connector and CData Connect Cloud to integrate live Xero Accounting into custom reports in Power BI.

Access Xero from MySQL in Amazon QuickSight

Connect to Xero and build visualizations of Xero Accounting using a MySQL Connection in Amazon QuickSight.

Connect to Xero in HULFT Integrate

Connect to Xero as a JDBC data source in HULFT Integrate

Using the CData Software ODBC Driver for Xero in PyCharm

Connect to Xero as an ODBC data source in PyCharm using the CData Software ODBC Driver for Xero.

Excel Spreadsheet Automation with the QUERY Formula

Pull data, automate spreadsheets, and more with the QUERY formula.

Connect to Xero in DBArtisan

Use wizards in DBArtisan to configure Xero Accounting as a data source.

Automated Continuous Xero Replication to Amazon Redshift

Use CData Sync for automated, continuous, customizable Xero replication to Amazon Redshift.

Build a Simple VCL Application for Xero

How to build a simple VCL Application to view Xero Accounting in RAD Studio using the CData ODBC Driver for Xero.

Validate Xero with QuerySurge

Access and validate Xero Accounting in QuerySurge using the CData JDBC Driver.

Replicate Multiple Xero Accounts

Replicate multiple Xero accounts to one or many databases.

Process & Analyze Xero in Databricks (AWS)

Use CData, AWS, and Databricks to perform data engineering and data science on live Xero .

Work with Xero in FoxPro

Load Xero Accounting into a FoxPro database. This article includes full code and a walk-through of the process.

Analyze Xero with Power Pivot

This article walks you through the process of using the CData ODBC Driver for Xero from Power Pivot. You will use the Table Import Wizard to load Xero Accounting. You can visually build the import query or use any SQL supported by the driver.

A PostgreSQL Interface for Xero

Use the Remoting features of the Xero ODBC Driver to create a PostgreSQL entry-point for data access.

Import Xero into the Power BI Service for Visualizations

Use CData Connect Cloud to connect to Xero and provide access to live Xero Accounting for custom reports in the Power BI Service.

DataBind Controls to Xero in Delphi

DataBind to Xero Accounting in Delphi with standard data access components and controls.

Visualize Xero in Sisense

Create an ElastiCube in Sisense app with access to Xero Accounting.

Automated Continuous Xero Replication to AlloyDB

Use CData Sync for automated, continuous, customizable Xero replication to AlloyDB.

Write a Simple Go Application to work with Xero on Linux

Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Xero Accounting.

How to Connect DBeaver to Xero via a JDBC Driver

Manage Xero Accounting with visual tools in DBeaver like the query browser.

Prepare, Blend, and Analyze Xero in Alteryx Designer

Build workflows to access live Xero Accounting for self-service data analytics.

Automate Xero Replication to Azure Synapse

Use CData Sync to customize and automate Xero Accounting replication to Azure Synapse.

Query Xero as a SQL Server Database in Node.js

Execute SQL Server queries against Xero Accounting from Node.js.

Integrate with Live Xero in MuleSoft (via CData Connect Cloud)

Use CData Connect Cloud to connect to Xero from the MuleSoft Anypoint Platform to integrate live Xero Accounting into custom reports and dashboards.

Using AngularJS to Build Dynamic Web Pages with Xero

Use the CData Connect Server to create Xero OData feeds and build single-page applications with live Xero Accounting.

Create Datasets from Xero in Domo Workbench and Build Visualizations of Xero in Domo

Use the CData Software ODBC Driver for Xero to create datasets from Xero Accounting in Domo Workbench and then build visualizations in the Domo service.

Create Xero Reports on JasperReports Server

Deploy the CData JDBC Driver on JasperReports Server to provide real-time Xero data access from reports, embedded analytics, and more.

Automated Continuous Xero Replication to Databricks

Use CData Sync for automated, continuous, customizable Xero replication to Databricks.

Visualize Xero from Tableau

Use the Tableau Desktop business intelligence tool to connect to Xero Accounting.

Create an SAP BusinessObjects Universe on the CData ODBC Driver for Xero

Provide connectivity to Xero Accounting through an SAP BusinessObjects universe.

Connect to Xero in Aqua Data Studio

Access Xero Accounting from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

How to connect to Xero in DBVisualizer

Integrate Xero Accounting with visual data analysis tools and data connection wizards in DBVisualizer

Edit and Search External Xero Objects in Salesforce Connect

Use CData Connect Cloud to securely provide OData feeds of Xero Accounting to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Xero objects that you can access from apps and the dashboard.

Import and Visualize Xero in Power View

Create data visualizations based on Xero Accounting in Excel.

Build Visualizations of Xero in Birst

Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Xero Accounting in Birst.

Build Dashboards with Xero in DBxtra

Create dynamic dashboards and perform analytics based on Xero Accounting in DBxtra.

Import Xero Using Azure Data Factory

Use CData Connect Cloud to connect to Xero from Azure Data Factory and import live Xero Accounting.

Rapidly Develop Xero-Driven Apps with Active Query Builder

Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.

Create Xero-Connected Nintex Workflows

Use CData Connect Cloud to connect to Xero from Nintex Workflow Cloud and build custom workflows using live Xero Accounting.

Replicate Multiple Xero Accounts

Replicate multiple Xero accounts to one or many databases.

Integrate with live Xero in Jitterbit

Use CData Connect Cloud to connect to and integrate live Xero Accounting in Jitterbit.

Automate Xero Replication to Azure Data Lake

Use CData Sync to customize and automate Xero Accounting replication to Azure Data Lake.

Use the CData ODBC Driver for Xero from SharePoint Excel Services

This article demonstrates how to use the CData ODBC Driver for Xero to connect to Xero Accounting from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Xero Accounting in Excel.

Add Xero to Informatica Enterprise Data Catalog

Use the CData Software JDBC Driver for Xero with the Informatica Enterprise Data Catalog to classify and organize data.

How to create an RPA flow for Xero in UiPath Studio

Use the Xero ODBC Driver to create workflows that access real-time Xero Accounting without any coding.

Connect to Xero from PowerBuilder

This article demonstrates how to use the CData ODBC Driver for Xero to connect to Xero Accounting and execute queries in PowerBuilder.

Use the CData ODBC Driver for Xero in SAS JMP

You can use the CData ODBC Driver to integrate Xero Accounting into the statistical analysis tools available in SAS JMP. This article shows how to use Xero Accounting in the Graph Builder and Query Builder.

Visualize Live Xero of Power BI Report Builder in Power BI Service

Use CData Power BI Connectors to connect to live Xero Accounting using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.

Integrate Xero in the Pentaho Report Designer

Publish reports based on Xero Accounting in the Pentaho BI tool.

Use the CData Software JDBC Driver for Xero in MicroStrategy

Connect to Xero Accounting in MicroStrategy Developer using the CData Software JDBC Driver for Xero.

Publish Xero-Connected Dashboards in Tableau Server

Use CData JDBC drivers and Tableau Server to visualize live Xero Accounting.

Connect to Xero from PowerBuilder

This article demonstrates how to access Xero Accounting from Appeon PowerBuilder using the CData ADO.NET Provider for Xero.

DataBind Wijmo Grid to Xero

Provide real-time Xero Accounting to interactive controls.

Deploy the ADO.NET Provider for Xero on an SSRS Report Server

Connect to Xero Accounting from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

Import Xero into FileMaker Pro

Create reports that integrate Xero Accounting in Filemaker Pro.

Create Reports from Xero in Looker Studio

Use CData Connect Cloud to gain access to live Xero Accounting and create custom reports in Looker Studio.

Automated Continuous Xero Replication to Local Delimited Files

Use CData Sync for automated, continuous, customizable Xero replication to delimited files (CSV/TSV).

Integrate with Xero in SnapLogic

Use CData Connect Cloud to connect to and integrate with live Xero Accounting in SnapLogic.

Access Live Xero in Coginiti Pro

Connect to and query live Xero Accounting from the GUI in the Coginiti Pro: SQL Analytics Tool.

Analyze Live Xero in SAS Viya

Use CData Connect Cloud to connect to Xero Accounting from SAS Viya and deploy self-service analytics using live Xero Accounting.

Access Live Xero in Excel (Desktop)

Use CData Connect Cloud to gain access to live Xero Accounting from your Excel spreadsheets.

Analyze Xero in Looker

Use CData Connect Cloud to connect to Xero from Looker and build custom apps using live Xero Accounting.

Access Xero in PHP through Connect Server

Connect to Xero through the standard SQL Server libraries in PHP.

Build Xero-Connected Apps in Mendix

Use CData Connect Cloud to create an OData feed for Xero and create custom apps in Mendix.

Extract, Transform, and Load Xero in Informatica PowerCenter

Create a simple Workflow for Xero Accounting in Informatica PowerCenter.

Integrate with Xero in JReport Designer

Create charts and reports based on Xero Accounting in JReport Designer.

How to connect PolyBase to Xero

Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Xero Accounting.

Automated Continuous Xero Replication to Apache Kafka

Use CData Sync for automated, continuous, customizable Xero replication to Apache Kafka.