Release Notes

April 2025

We now support Zuora Revenue reports. We have added a new field, Sync Mode, to the connection setup form. You can opt to use one of the following sync modes:

Sync Zuora Billing
Sync Zuora Revenue
Sync both Billing and Revenue

We are gradually rolling out this feature to all existing connections. For more information, see our setup guide.

We have updated the Quickstart packages for the following connectors:

Facebook Ads to version 0.9.0
Google Ads to version 0.12.0
HubSpot to version 0.23.0
LinkedIn Ad Analytics to version 0.11.0
Microsoft Advertising to version 0.11.1
NetSuite SuiteAnalytics to version 0.19.0
Pinterest to version 0.12.0
Recharge to version 0.3.1
Reddit Ads to version 0.4.0
Tiktok Ads to version 0.8.0
Twitter Ads to version 0.9.0
Xero to version 0.9.0
Zuora to version 0.4.0

February 2025

We have updated the Quickstart packages for the following connectors:

Ad Reporting data model connectors to version 0.5.0
Amplitude to version 0.6.0
Apple App Store to version 0.5.0
App reporting data model connectors to version 0.5.0
Asana to version 0.8.3
HubSpot to version 0.21.0
Sage Intacct to version 0.6.0
Shopify to version 0.17.0
Snapchat Ads to version 0.8.0
Stripe to version 0.16.1
Zuora to version 0.3.2

January 2025

We have updated the Quickstart packages for the following connectors:

Fivetran Platform Connector to version 1.11.0
Marketo to version 0.13.1
Mixpanel to version 0.11.0
Netsuite to version 0.17.1
Qualtrics to version 0.3.0
Quickbooks to version 0.17.1
Salesforce to version 1.2.0
Servicenow to version 0.4.0
Shopify to version 0.16.0
Stripe to version 0.16.0
Xero to version 0.7.0
Zendesk Support to version 0.19.3
Zuora to version 0.3.1

October 2024

The Zuora connector now supports the Hybrid Deployment model. For more information, see our setup instructions.

March 2024

We have implemented new weekly lookback windows to update the data and improve data integrity for the following:

tables with a 14-day lookback period:
- CREDIT_MEMO_APPLICATION_ITEM
- CREDIT_TAXATION_ITEM
- DEBIT_MEMO_ITEM
- DEBIT_TAXATION_ITEM
- INVOICE_ITEM
- INVOICE_ITEM_ADJUSTMENT
- PAYMENT_APPLICATION_ITEM
- REFUND_APPLICATION_ITEM
- REVENUE_EVENT_ITEM
- REVENUE_EVENT_ITEM_DEBIT_MEMO_ITEM
- REVENUE_EVENT_ITEM_INVOICE_ITEM
- REVENUE_EVENT_ITEM_INVOICE_ITEM_ADJUSTMENT
- TAXATION_ITEM
tables with a 90-day lookback period:
- CREDIT_MEMO_ITEM
- REVENUE_EVENT_ITEM_CREDIT_MEMO_ITEM

May 2023

We have released pre-built, dbt Core-compatible data models for Zuora. Find the models in Fivetran's dbt hub or data models documentation. Learn more about our dbt Core integration in our Transformations for dbt Core documentation*.

* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.

September 2022

We now sync the following Order Delta tables through the Data Query feature:

ORDER_DELTA_MRR
ORDER_DELTA_TCB
ORDER_DELTA_TCV

We are gradually rolling out this feature to all existing connectors.

February 2022

We have added the following new tables:

CALLOUT_HISTORY
CHARGE_METRICS_RUN
DISCOUNT_APPLY_DETAIL
DISCOUNT_CLASS
INVOICE_ADJUSTMENT
JOURNAL_ENTRY_DETAIL_CREDIT_BALANCE_ADJUSTMENT
JOURNAL_ENTRY_DETAIL_CREDIT_MEMO_APPLICATION_ITEM
JOURNAL_ENTRY_DETAIL_CREDIT_MEMO_ITEM
JOURNAL_ENTRY_DETAIL_CREDIT_TAXATION_ITEM
JOURNAL_ENTRY_DETAIL_DEBIT_MEMO_ITEM
JOURNAL_ENTRY_DETAIL_DEBIT_TAXATION_ITEM
JOURNAL_ENTRY_DETAIL_INVOICE_ADJUSTMENT
JOURNAL_ENTRY_DETAIL_INVOICE_ITEM
JOURNAL_ENTRY_DETAIL_INVOICE_ITEM_ADJUSTMENT
JOURNAL_ENTRY_DETAIL_INVOICE_PAYMENT
JOURNAL_ENTRY_DETAIL_PAYMENT_APPLICATION
JOURNAL_ENTRY_DETAIL_PAYMENT_APPLICATION_ITEM
JOURNAL_ENTRY_DETAIL_REFUND_APPLICATION
JOURNAL_ENTRY_DETAIL_REFUND_APPLICATION_ITEM
JOURNAL_ENTRY_DETAIL_REFUND_INVOICE_PAYMENT
JOURNAL_ENTRY_DETAIL_REVENUE_EVENT_ITEM
JOURNAL_ENTRY_DETAIL_TAXATION_ITEM

September 2021

The Zuora and Zuora Sandbox connectors now support syncing Custom Objects. We use Data Query to fetch custom object records.

August 2021

The Zuora Sandbox connector now supports the Central Sandbox environment. The environment supports both US and EU regions. See our setup instructions for more information.

July 2021

We have added a new table, USER which stores User details of a Zuora tenant.

December 2020

The Zuora Sandbox connector now supports the Production copy environment. See our setup instructions for more information.

The Zuora Sandbox connector now supports US Cloud Data Center's REST API Production (https://rest.na.zuora.com) and Sandbox (https://rest.sandbox.na.zuora.com/) environments.

We have upgraded our Zuora connector from Zuora API WSDL version 96.0 to 106.0 and have added two new columns, tax_message and tax_status, to the INVOICE table. We are gradually rolling out this new feature to all existing connectors. If you'd like to enable this feature on your connector, contact our support team.

November 2020

We can now sync the USER table using the Data Query feature. Only Zuora platform admin users can access the USER table. See Zuora's documentation for more information. If you'd like to enable the USER table on your connector, contact our support team.

April 2020

We now create empty tables and columns in the destination even if the source tables and columns are empty (contain only Null values).

We now add a _fivetran_synced column while syncing empty tables and columns from the source.

August 2019

We have upgraded our Zuora connector from Zuora API WSDL version 91.0 to 96.0. We have made the following changes as a result of the upgrade:

Added the sequence_set_id column to the ACCOUNT_FIELDS table.
Added the balance column to the INVOICE_ITEM table.
Added the following new columns to the REVENUE_EVENT, REVENUE_EVENT_INVOICE_ITEM, and REVENUE_EVENT_INVOICE_ITEM_ADJUSTMENT tables:
- amount
- currency
Added the following new columns to the TAXATION_ITEM table:
- balance
- credit_amount
- payment_amount
Removed support for the CUSTOMER table.

We now support the Zuora Performance Test environment. To connect, add the Zuora Sandbox connector in your Fivetran dashboard and select the Performance Test environment.

April 2019

We now capture deletes in V2 of our Zuora connector for the following tables:

ACCOUNT
ACCOUNTING_CODE
AMENDMENT
BILLING_RUN
CHARGE_METRICS
COMMUNICATION_PROFILE
CONTACT
CREDIT_BALANCE_ADJUSTMENT
EXPORT
FEATURE
IMPORT
INVOICE
INVOICE_ITEM
INVOICE_ITEM_ADJUSTMENT
INVOICE_PAYMENT
JOURNAL_ENTRY
JOURNAL_ENTRY_ITEM
JOURNAL_RUN
ORDER
ORDER_ACTION
ORDER_ELP
ORDER_ITEM
ORDER_MRR
ORDER_QUANTITY
ORDER_TCB
ORDER_TCV
PAYMENT
PAYMENT_METHOD
PAYMENT_RUN
PRODUCT
PRODUCT_FEATURE
PRODUCT_RATE_PLAN
PRODUCT_RATE_PLAN_CHARGE
PRODUCT_RATE_PLAN_CHARGE_TIER
RATE_PLAN
RATE_PLAN_CHARGE
RATE_PLAN_CHARGE_TIER
REFUND
REFUND_INVOICE_PAYMENT
REVENUE_CHARGE_SUMMARY
REVENUE_CHARGE_SUMMARY_ITEM
REVENUE_EVENT
REVENUE_EVENT_INVOICE_ITEM
REVENUE_EVENT_INVOICE_ITEM_ADJUSTMENT
REVENUE_EVENT_ITEM
REVENUE_EVENT_ITEM_CREDIT_MEMO_ITEM
REVENUE_EVENT_ITEM_DEBIT_MEMO_ITEM
REVENUE_EVENT_ITEM_INVOICE_ITEM
REVENUE_EVENT_ITEM_INVOICE_ITEM_ADJUSTMENT
REVENUE_EVENT_TYPE
REVENUE_SCHEDULE
REVENUE_SCHEDULE_CREDIT_MEMO_ITEM
REVENUE_SCHEDULE_DEBIT_MEMO_ITEM
REVENUE_SCHEDULE_INVOICE_ITEM
REVENUE_SCHEDULE_INVOICE_ITEM_ADJUSTMENT
REVENUE_SCHEDULE_ITEM
REVENUE_SCHEDULE_ITEM_CREDIT_MEMO_ITEM
REVENUE_SCHEDULE_ITEM_DEBIT_MEMO_ITEM
REVENUE_SCHEDULE_ITEM_INVOICE_ITEM
REVENUE_SCHEDULE_ITEM_INVOICE_ITEM_ADJUSTMENT
SUBSCRIPTION
SUBSCRIPTION_PRODUCT_FEATURE
TAXATION_ITEM
USAGE

January 2019

We have released a new version of the Zuora connector that uses the REST API, moving off of the AQuA API.

November 2018

You can now trigger re-syncs of individual tables from your Fivetran dashboard:

Customer triggered re-syncs!

The re-sync button appears when you hover your cursor over the row that contains the table name.

This feature is available for the following connectors:

Amazon DynamoDB
MongoDB
MySQL
NetSuite SuiteAnalytics
Oracle
PostgreSQL
Salesforce
SQL Server
Zuora