Knowledge Center

Knowledge Center > Reporting > Data Sources and Exports > Generate a Data Source Export

Generate a Data Source Export

You can create data source exports through the Zuora application and the Zuora API. This article describes how to create data source exports through the Zuora application. See Export ZOQL for how to data source exports through the Zuora API.

After creating a data source export, you can download the exported data from the Zuora application. Each exported file is available for download for 7 days.

Create a Data Source Export

  1. Navigate to Reporting > Data Sources.

  2. Select a data source in the Data Source drop-down.

    In each data source, the base object is only joined to objects that are its parent in the Zuora business object model. This means that if you want to export subscriptions with charges, you should select Rate Plan Charge as the data source.

    See Data Source Reference for a list of available data sources.

  3. Select the base object fields to export then select the related object fields to export.

  4. Specify any filters to apply.

  5. Specify the time frame.

  6. Select the format of the exported data.

    CSV ZIP produces a zipped CSV file.

  7. Click export.

For example:

Data_Source_Export.png

Zuora displays the status of the data source export. For example:

Data_Source_Export_Results.png

To update the status of the data source export, click Refresh. When the status is Completed, you can download the exported data by clicking the name of the file.

Exported files are available for download for 7 days. Data source exports older than 90 days are automatically deleted.

Save Frequently Used Data Source Exports

If you select Save As Default when creating a data source export, Zuora will save your fields and filters for the data source and will automatically apply those settings the next time you select that data source. This enables you to create custom data source export configurations for future use.

Data Source Saved as a Default

File Size Limitation

The maximum export file size is 2047MB. If you have large data requests that go over this limit, you will get the following 403 HTTP response code from Zuora:
  <security:max-object-size>2047MB</security:max-object-size>

Submit a request at Zuora Global Support if you require additional assistance.

We can work with you to determine if large file optimization is an option for you.

Encrypted Data Source Exports

You can export a secure version of encrypted data source fields. Using this option, you can view and export the AchAccountNumber field of any PaymentMethod or DefaultPaymentMethod data source objects.

This is a Controlled Release feature. Contact Zuora Global Support for information about using this feature. To use this feature, you must sign a security contract with >Zuora and store your public key in the Zuora System. Zuora decrypts the fields and exports them to a file. Zuora then encrypts the file using your public key, ensuring that the fields are never available in plain text format.

To use this feature:

  • In the Zuora user interface, select Encrypt Export before making an export.
  • Using the Zuora API, when creating an Export object, set the Encrypted field to true.

Zuora will create a file with the .gpg extension. You can then use your private key to decrypt the file.

If you exported encrypted fields without specifying the encryption option (Encrypt Export or setting Encrypted to true), the encrypted fields are masked (replaced with ******).

If you delete the record, the exported file will be removed, but the export record is kept to track all encrypted export history. In the Export history, a lock icon in the File type indicates an encrypted record.

If this feature is not enabled for your tenant, you can use the API to set Encrypted to true, but the API will return an error message.

The encrypted fields are never selectable in a Commerce API query() operation. If you attempt to select an encrypted field, you will receive an "invalid field" error.

Last modified
00:25, 9 Oct 2017

Tags

Classifications

(not set)