Stitch Documentation
has moved!

Please update your bookmarks to https://www.stitchdata.com/docs

If you're not automatically redirected after 5 seconds, click here.

Connecting Zuora

To add a Zuora integration, you'll need to do the following:

  1. Verify your Zuora account type
  2. Create a Stitch Zuora user
  3. Enter the Stitch Zuora credentials into Stitch
  4. Define the Replication Frequency
  5. Select tables to sync

Verifying Your Zuora Account Type

At this time, Stitch can only connect to Production Zuora accounts. Sandboxes - as outlined here - aren't supported.

If you're interested in having us add support for this, please reach out to us with your use case.

Creating a Stitch Zuora User

To connect your Zuora account, we recommend that you create a user for Stitch. Note that you must have Administrator permissions in your Zuora account to create a new user.

Important!
If your company enforces Password Expiration rules, you may encounter future connection issues when the credentials used by Stitch expire. For a workaround, refer to this Zuora support article.

Additionally, if you have enabled the IP restriction for logins for User Roles, you will need to ensure that Stitch's IP addresses are whitelisted.

To read and replicate your Zuora data, we need a user that:

  1. Has Standard user permissions. Note that we will only ever read your data.
  2. Has two-factor authentication disabled. If this type of authentication is enabled for the Stitch user, you'll encounter connection and replication issues after the Zuora setup is complete.

    Need some help disabling this setting? Check out the Disable or Reset Two-Factor Authentication section in this Zuora support article.

When entering the user credentials in the next step, be sure to use the username and password associated with the user. Entering anything else, such as an API token or secret, will result in an unsuccessful connection.

Entering the Stitch Zuora Credentials into Stitch

After the user is created, you'll need to enter the credentials into Stitch to complete the connection.

  1. On the Stitch Dashboard page, click the Add an Integration button.
  2. Click the Zuora icon. This will open the Zuora credentials page.
  3. Enter a name for the integration. This is the name that will display on the Stitch dashboard for the integration; it’ll also be used to create the schema in your data warehouse.

    For example, the name “Stitch Zuora” would create a schema called stitch_zuora in the data warehouse.
  4. Enter the username and password of the Stitch user. Note that Stitch needs the username and password - entering a token and secret will result in an unsuccessful connection.

Defining the Replication Frequency

Before you save the connection, you'll need to set the replication frequency for the integration. This setting controls how often Stitch will attempt to replicate data from Zuora.

By default the Replication Frequency is set to 30 minutes, but you can change the interval at any time in the Integration Details page for the integration by clicking the Integration Settings button.

When you're finished, click the Save Integration button to wrap things up.

Selecting Tables to Sync

To finish setting up the integration, you'll need to select the tables you want to sync to your data warehouse. Check out the Expected Stitch Zuora data article to learn more about the data our integration pulls in from Zuora.

At this time, Stitch supports syncing Zuora data at the table level. You can sync and unsync tables at any time.

Related

Was this article helpful?
0 out of 0 found this helpful

Comments

Questions or suggestions? If something in our documentation is unclear, let us know in the comments!