Xero2SQL Sync Utility

Xero2SQL Sync Utility

£99.00

Xero2SQL Sync Utility Xero2SQL Sync Utility is a standalone command-line tool that synchronises Xero Contacts, Accounts, and Transactions (including Payments) into SQL Server. It imports only the changes since the last run and can create the required tables automatically. It works entirely inside your infrastructure, does not store data in transit, and uses the official Xero APIs. Advanced users can map the sync to existing SQL tables if needed. One licence is required per installation. The product includes limited email support, with optional paid support available. A free 30-day trial is provided.

SKU: *XERO_IMPORTER
Category:

Description

Xero2SQL Sync Utility

Xero2SQL Sync Utility is a standalone command-line tool that synchronises your Xero data into Microsoft SQL Server, giving you fast, direct access to your accounting information for reporting, integration, and analysis.

It connects securely to your Xero organisation and automatically imports and updates:

  • Contacts
  • Accounts
  • Transactions (including Payments)

Key Features

  • Automatic incremental sync
    Only changes since the last successful synchronisation are imported, keeping your SQL Server database up to date without unnecessary processing.
  • Automatic table creation
    Out of the box, the utility creates three SQL Server tables for you:

    • Contacts
    • Accounts
    • BankTransactionLineItems

    This means you can be up and running quickly without manual database setup.

  • Advanced table mapping (optional)
    For more complex environments, the tool can be configured to map Xero data into your own existing tables. This requires advanced configuration but allows seamless integration with your current schema.
  • Command-line operation
    Designed as a command prompt utility, it is easy to schedule using Windows Task Scheduler or your preferred automation tools.

Security and Deployment

  • Runs entirely in your infrastructure
    The utility is installed and executed within your own environment, so you retain full control over connectivity, access, and security.
  • No data stored in transit
    The tool does not store your data in transit. It reads from Xero and writes directly to your SQL Server tables.
  • Xero API integration
    Requires Xero APIs to be enabled for your organisation. Once connected, the utility uses the official Xero APIs to retrieve your data.

Licensing and Support

  • Licensing
    One licence is required per installation of the Xero2SQL Sync Utility.
  • Support
    The product includes limited email support. We do not guarantee immediate or priority responses under the standard licence.
    Optional enhanced support packages can be purchased separately if you require guaranteed response times or extended assistance.
  • Free 30-day trial
    A fully functional 30-day trial is available so you can evaluate the utility in your own environment before purchasing.

Xero2SQL Sync Utility is ideal for organisations that want reliable, secure, and controlled access to their Xero data in SQL Server, without relying on third-party hosted services.

Configuration

All configuration settings for the Xero2SQL Sync Utility are stored in the appconfig.json file located in the installation folder. This file can be opened and edited with any simple text editor. All entries must follow valid JSON syntax to ensure the utility runs correctly. Adjusting this file allows you to set connection details, authentication parameters, and optional mapping rules according to your environment.

Related products