Note: As of our v20.1.0.1561 release, our Xero toolkit has been deprecated in favor of our SSIS Productivity Pack. Consider upgrading to SSIS Productivity Pack as soon as possible to avoid possible service disruptions.

Perform high performance data integration between Xero accounting software and any other data source.

Read and write data from Xero with ease while maintaining full control with software built on the powerful SSIS ETL platform.


The SSIS Integration Toolkit for Xero

  • High performing and codeless data integration for Xero using SSIS.
  • Develop simple to complex integration jobs to suit unique business needs.
  • Take advantage of the flexibility and power of the SSIS ETL engine.
  • Intuitive user interface to manage different aspects of your integration development in a codeless, drag and drop environment.
  • Immersive development productivity thanks to the easy learning curve and familiar development experience using Microsoft Visual Studio.
  • Respects the API Throttle Rate to prevent the Xero server from declining request.
  • Powered by modern cryptography and authentication technologies for secure connections, such as TLS 1.2, OAuth2, SHA-256, etc.
  • Synchronize Xero data with virtually any external data source that SSIS can read/write to including Salesforce, HubSpot, Active Directory, SharePoint and any other components available in the Ultimate Edition.
Xero Data Integration

SSIS Integration Toolkit for Xero is now a part of the

SSIS Productivity Pack SSIS Productivity Pack

Codeless
Integration

You don't have to write a single line of code to make data integration happen so your development can be done in a matter of minutes.

Flexible and
Easy-to-use

We make the most flexible integration solution on the market. Our software offers intuitive user interfaces that are flexible and easy to use.

Cost
Effective

With a streamlined development experience, and an extremely simple licensing model, our solution offers the best value for your investment.

Unparalleled
Performance

Our software offers many specifically designed features that help you achieve the best possible performance without having to hijack your budget.

Unique Features

  • Built in retry on intermittent errors helps eliminate integration disruptions due to temporary service outages or disruptions.
  • Includes options to work with Child Objects.
  • Filter data using the Where Statement.
  • 3 different actions for writing to Xero: Create, Update, or Delete
  • Automatic field mapping based on a name-match.

Technical Requirements

  • Microsoft SQL Server Integration Services, either:
    • Azure-SSIS Integration Runtime,
    • Microsoft SQL Server 2019,
    • Microsoft SQL Server 2017,
    • Microsoft SQL Server 2016,
    • Microsoft SQL Server 2014,
    • Microsoft SQL Server 2012,
    • Microsoft SQL Server 2008 R2, or,
    • Microsoft SQL Server 2008.

Xero SSIS Components


The KingswaySoft tool’s UI is very intuitive and you cannot beat the support they provide.

D. Ng

Senior DBA

ASCO