How to Setup Zendesk Integration

This integration will allow you to connect with Zendesk and start collecting your data. It is a matter of minutes to send your customer support data (like tickets, customer communication) to feed your BI, your data warehouse, or your custom analytics stack.

Here are the steps involved:

  1. Connecting Zendesk
  2. Set the Replication Frequency
  3. Load your Zendesk data into your data warehouse
  4. Zendesk expected Data Model and schema
  5. Zendesk Integration FAQ

Getting Started – Setup Zendesk integration at Blendo

To add this integration, go to Blendo dashboard. Click Add a Source.

Setup Zendesk integration to load your data into your data warehouse

Settings you need from Zendesk

We will need the: Subdomain of your Zendesk URL, your Zendesk Username, and your Zendesk API Token.

1. Login to your Zendesk dashboard from a new tab

2. On the URL of the browser window, you may find the Subdomain. It should be in the form: mysubdomain.zendesk.com. For Blendo we will need mysubdomain.

Import your zendesk data to your data warehouse

The Zendesk Subdomain should be in the form: mysubdomain.zendesk.com

3. Now let’s get the Token. Click on the gear icon at the bottom left.

Import your zendesk data to your data warehouse

Click on the gear icon

4. On the new window scroll down until you will see the API menu. Click on it.

Import your zendesk data to your data warehouse

Zendesk API Token

5. Add a new token

Import your zendesk data to your data warehouse

Add new token

6. In the new popup, type a Label to remember i.e. Blendo.

7. In the next (and last window) you will find your Zendesk Token. Select it and copy it. Then click on “OK, I’ve copied my token

Import your zendesk data to your data warehouse

Copy your Zendesk API Token

Add these Zendesk settings to Blendo

Let’s go back to our web browser tab with Blendo. Now that you have your:

  • Subdomain (step #2, above)
  • Zendesk username (the email you used to login to Zendesk)
  • Token (step #7, above)

you may fill the relevant boxes into Blendo. Click Validate & Save.

Import your zendesk data to your data warehouse

8. Then you will return back to the home dashboard. Click on your new Zendesk data source.

Set the Replication Frequency

This configuration controls how often Blendo will pull data from your Zendesk integration. Loading to your data warehouse could take a little bit longer.

9. If you want to change the replication schedule go to the Schedule section and click on Reschedule.

10. In the next pop-up select one of the options available and click Apply.

Load your Zendesk data into your data warehouse

Here is how to start loading your Zendesk data into your data warehouse:

Zendesk Data Model & Schema Information

Blendo will now connect to your Zendesk data source. It will sync your historical data and all the future updates into your destination data warehouse. You will get analytics ready tables and syncs that make sure you will get recent and consistent data.

Let’s see:

  1. How Blendo syncs Zendesk data
  2. The tables with Zendesk data that we create in your destination data warehouse

How Blendo syncs Zendesk data

Historical Data

When Blendo first connects to Zendesk Data source, will pull all your historical data.

Sync Schedule

Blendo syncs Zendesk data based on the schedule and frequency you choose. The default setting is every 1 hour but is configurable from inside the app.

Replication Process

The first time Blendo syncs your Zendesk data performs a full replication. Then your Zendesk data is replicated incrementally. Note that Blendo will only read your data.

After you finish the integration with Zendesk, you might see its status as Importing from sourceExporting to the destination, or Completed.

What Zendesk data do I have available?

Blendo creates analytics ready tables with recent and consistent data. Bellow is a diagram of the schema and you may also find a CSV with all the columns and fields in more detail.

Expected Zendesk Data Model & Schema Information >>

Questions? Contact us!

in Connecting SaaS Data Sources