Why Do I See Zuora Revenue Tables in My Schema Tab?

Question

Why do I see tables for Revenue objects in the Schema tab when I only want to sync billing data?

Environment

Connector: Zuora

Answer

Zuora may expose revenue objects through the same data source we use for billing when your Zuora account has revenue recognition data linked to its billing account. When this happens, tables such as REVENUECONTRACT, REVENUEPERIODS, and REVENUESCHEDULE appear in the Schema tab.

To control which tables sync to your destination:

1. In Fivetran, go to your Zuora connection page.
2. Select the Settings tab.
3. Click Edit connection.
4. Under Sync Mode, select Sync Zuora Billing for billing data only or Sync both Billing and Revenue for both types of data.
5. If you've made any changes, click Save & Test.
6. Select the Schema tab.
7. Deselect the checkbox next to any revenue-related tables you don't want to sync.
8. Click Save changes.