Release Notes

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:

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