Skip to main content

Prepare for data collection in Billing - Revenue Integration environment

Zuora

Prepare for data collection in Billing - Revenue Integration environment

Introduces the required programs and configurations for Zuora Billing - Revenue integration before the Data Collection job can be started in Zuora Revenue

As explained in Billing - Revenue Integration infrastructure overview, data sync and data transformation are required for Zuora Billing data before they can be collected into Zuora Revenue for revenue processing.

To prepare the Billing - Revenue Integration environment and the Zuora Billing data for the Zuora Revenue data collection, there are two ways illustrated in the following diagram.
OTR-integration-workflow.pngConfigure field mapping Configure field mapping Configure transaction mapping templates Configure transaction mapping templates Sync Zuora Billing settings to Zuora_Revenue Run Revenue Sync jobs Run Data Sync jobs Run Data Transformation jobs Collect data for Zuora Revenue

At the beginning of the workflow, the RevPro3.0 Automate Datasync Setups Process needs to be started. This program reads the settings from Zuora Billing and configures some profiles in Zuora Revenue accordingly. For more information, see Sync Zuora Billing settings to Zuora Revenue.

  • Beginning from version 37.006.00.00, this integration workflow is simplified by eliminating the need to schedule any data sync jobs. After the one-off program completes and one-off configuration is done in the system, data can be synced automatically from Zuora Billing to Zuora Revenue.
  • Beginning from version 37.002.02.00 until 37.006.00.00, the Revenue Data Sync job is provided to replace both the Data Sync and Data Transformation jobs in previous versions. After field mapping and transaction templates are set up in Zuora Revenue, the Revenue Sync job can be started on-demand or on a regular basis. For more information, see Run Revenue Sync jobs.
  • Before version 37.002.02.00, you need to start the Data Sync and Data Transformation jobs sequentially. There are also some prerequisites for running these two jobs. For example, the RevPro3.0 Sync Object Mapping program is a prerequisite for the Data Sync job. Before the Data Transformation job is started, transaction templates must be created appropriately on the File Upload > Transactions/Cost page. For more information, see Run Data Sync jobs and Run Data Transformation jobs.

After Zuora Billing data is all in place in Zuora Revenue staging tables, it is time to start the Data Collection job, which triggers revenue processing. The Data Collection job is recommended to run on a daily basis so any upstream data issue can be captured early. For more information, see Collect data for Billing - Revenue Integration.