--- title: "Zuora Integration for Rig: Query Zuora Data in Plain English" description: "Connect Zuora to Rig and query your Zuora data in plain English, or ask it in Claude, ChatGPT and Cursor. Governed, validated answers from your warehouse." canonical: "https://rig.so/integrations/zuora" format: markdown --- Browse integrations ![Zuora logo](https://img.logo.dev/zuora.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=112&format=png&retina=true) 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](https://app.rig.so/signup)[Book a demo](https://rig.so/book-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](https://rig.so/guides/connect-zuora) ## 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. - [Claude](https://rig.so/integrations/claude) - [Claude Code](https://rig.so/integrations/claude-code) - [Cursor](https://rig.so/integrations/cursor) - [ChatGPT](https://rig.so/integrations/chatgpt) - [Codex](https://rig.so/integrations/codex) - [Gemini](https://rig.so/integrations/gemini) ## 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. ## Related integrations [![Agree logo](https://img.logo.dev/agree.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)AgreeContract, milestone and payment-schedule analytics from Agree.](https://rig.so/integrations/agree)[![FX rates (ECB) logo](https://img.logo.dev/ecb.europa.eu?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)FX rates (ECB)Daily USD exchange rates for converting multi-currency revenue and spend.](https://rig.so/integrations/fx-rates)[![Light logo](https://img.logo.dev/light.inc?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)LightGeneral ledger, payables, receivables and card spend from Light.](https://rig.so/integrations/light)[![Mercury logo](https://img.logo.dev/mercury.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)MercuryCash, spend and transaction analytics from your Mercury accounts.](https://rig.so/integrations/mercury)[![Microsoft Dynamics 365 Finance & Operations logo](https://img.logo.dev/dynamics.microsoft.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)Microsoft Dynamics 365 Finance & OperationsLedger, orders and invoices from your Dynamics 365 ERP.](https://rig.so/integrations/dynamics-365-finance-operations)[![NetSuite logo](https://img.logo.dev/netsuite.com?token=pk_AdkTbLWDS1iunmvTK2qm1g&size=72&format=png&retina=true)NetSuiteRevenue, GL and order analytics from your NetSuite ERP.](https://rig.so/integrations/netsuite) ## Connect Zuora data to AI tools like Claude Rig builds a governed context layer over your data so every team, and every AI tool, asks questions and gets answers they can trust. [Try Rig](https://app.rig.so/signup)[Book a demo](https://rig.so/book-demo) --- - [This page as HTML](https://rig.so/integrations/zuora) - [Site map for language models](https://rig.so/llms.txt) - [API and agent documentation](https://rig.so/developers)