Connect Xero to MySQL

Authorize Xero through OAuth 2, select the Xero tenant you want to use, save your MySQL connection details, and pair both systems in a Catchr datastream.

Choose from 20 metrics and 112 dimensions covering contacts, invoices, invoice lines, and payments, including invoice total, amount paid, amount due, total tax, contact balances, account codes, and payment account names.

A MySQL job can start with an available historical Xero fetch and continue on a recurring schedule. The available history and frequency depend on the Xero API and your Catchr plan.

Catchr normalizes Xero timestamps to ISO-8601 UTC values. When configuring the job, select an available valid date field so Catchr can delete and rewrite the scheduled window, helping limit duplicates across overlapping loads.

Agencies and freelancers can query invoice totals, taxes, paid and due amounts, and outstanding or overdue contact balances in MySQL, then organize reusable views for finance and client reporting.

Yes. Connect an existing MySQL database first. The Catchr job creates and populates the destination table you configure inside that database.

Yes. Create a separate datastream and job for each source, write each export to its own table, then combine the data downstream with SQL, views, or your BI tool.