What Zuora data does Rig sync?

Accounts, contacts, subscriptions, rate plans and charges, orders, invoices, credit and debit memos, payments, refunds, the product catalogue, revenue schedules and revenue events, 43 objects in all, with every field included.

How does Rig read Zuora?

Through Zuora's Data Query, a read-only SQL export. Rig splits large tables into date windows so a query stays under Zuora's input and output limits.

What do I need to connect Zuora?

An OAuth client ID and secret from a Zuora user whose role has the Data Query permission, plus the Zuora environment your tenant runs in.

Do column names match other Zuora connectors?

Table names follow common naming such as credit_memo_item, while column names are Data Query's own: lowercase and joined, like updateddate.

Billing & finance Supported

Zuora integration for Rig

The easiest way to connect Zuora to Claude and other AI tools

Zuora is a subscription billing platform that manages accounts, subscriptions, rate plans, invoices, payments and revenue recognition for recurring-revenue businesses.

Try Rig Book a demo

What Rig syncs from Zuora

Once connected, Rig models these objects so questions resolve to the right tables and joins:

Accounts and contacts
Subscriptions, rate plans and charges
Orders and order actions
Invoices and invoice items
Credit and debit memos
Payments and refunds
Product catalogue
Revenue schedules and revenue events

How Zuora connects to Rig

Rig Ingest syncs 43 Zuora Billing objects into your warehouse on a schedule through Data Query, with one table per object and every field included, custom fields among them. You connect with an OAuth client ID and secret.

Read the step-by-step Zuora setup guide

Report recurring revenue from subscriptions and charges

Recurring revenue is the value of active subscription charges, normalised to a month or a year. Rig reads subscriptions, rate plans, rate plan charges and their tiers, so you can build MRR and ARR by product, plan or account and break movements into new, expansion and cancellation.

Ask Rig

What is MRR by product rate plan today?
Which subscriptions started or ended last month?
Show the number of active subscriptions by account over the last year

Follow invoices through to payment

Invoice-to-cash tracking connects what was billed to what was paid. Rig reads invoices and their items with payments, payment applications, credit and debit memos and refunds, so you can see open balances, how credits were applied and which invoices are overdue.

Ask Rig

Which invoices are unpaid and how old are they?
How much did we issue in credit memos last quarter, and against which invoices?
What is the refund total by month?

Reconcile billing with recognised revenue

Revenue reconciliation checks that what you billed matches what you recognised. Rig reads revenue schedule items and revenue events with their links to invoice and memo items, so finance can trace recognised revenue back to the billing document behind it.

Ask Rig

How much revenue was recognised each month this year?
Which invoice items have revenue schedule items still to be recognised?
Show recognised revenue by product charge

Understand orders and the product catalogue

Orders record what customers changed and when, and the catalogue records what you sell. Rig reads orders, order actions and items alongside products, rate plans and charge tiers, so you can see which products drive new business and how pricing tiers are used.

Ask Rig

Which products appear most in new orders this quarter?
List order actions by type for the last 90 days
Show the charge tiers on our top-selling rate plan

Ask your Zuora data in Claude, ChatGPT or Cursor

Rig serves your Zuora data to AI assistants over MCP. Once Zuora is synced into your warehouse, you can ask questions in plain English from the tool you already use, and every answer is backed by validated, governed SQL.

Frequently asked questions

What Zuora data does Rig sync?: Accounts, contacts, subscriptions, rate plans and charges, orders, invoices, credit and debit memos, payments, refunds, the product catalogue, revenue schedules and revenue events, 43 objects in all, with every field included.
How does Rig read Zuora?: Through Zuora's Data Query, a read-only SQL export. Rig splits large tables into date windows so a query stays under Zuora's input and output limits.
What do I need to connect Zuora?: An OAuth client ID and secret from a Zuora user whose role has the Data Query permission, plus the Zuora environment your tenant runs in.
Do column names match other Zuora connectors?: Table names follow common naming such as credit_memo_item, while column names are Data Query's own: lowercase and joined, like updateddate.