This page describes how to configure a Zendesk Talk data source. With Matillion Data Loader, you can replicate and load your source data into your target destination.
Schema Drift Support: No.
Return to any page of this wizard by clicking Previous.
Click X in the upper-right of the UI and then click Yes, discard to close the pipeline creation wizard.
- Please refer to the Whitelisted IP Addresses topic before you begin. You may not be able to connect to certain data sources without first whitelisting the Batch IP addresses. In these circumstances, connection tests will always fail and you will not be able to complete the pipeline.
- You need an active Zendesk account with the
This connector queries system tables to find metadata for your data sources, and might result in more API calls than expected. It's advised to keep the frequency of these jobs as low as possible. Contact your Zendesk administrator to gauge your API usage.
- In Matillion Data Loader, click Add pipeline.
- Choose Zendesk Talk from the grid of data sources.
- Choose Batch Loading.
Connect to Zendesk Talk
Configure the Zendesk Talk database connection settings, specifying the following:
|Username||A Zendesk username for the database server.|
|URL Prefix||Your Zendesk subdomain.|
|Password||A managed entry representing your Zendesk login password. Choose an existing password from the dropdown menu or click Manage and then click Add new password to configure a new managed password entry. Give the password a label, which is what you can see in the password dropdown menu, and then input the value of the password. Read Manage Passwords to learn more.|
|Advanced settings||Additional JDBC parameters or connection settings. Click Advanced settings and then choose a parameter from the dropdown menu and enter a value for the parameter. Click Add parameter for each extra parameter you want to add.|
Click Test and Continue to test your settings and move forward. You can't continue if the test fails for any reason.
Review your data set
Choose the columns from each table to include in the pipeline. By default, Matillion Data Loader selects all columns from a table.
Click Configure on a table to open Select columns. Use the arrow buttons to move columns out of the Columns to extract and load listbox. Order columns with click-and-drag. Select multiple columns using
Click Done to continue.
Click Continue once you have configured each table.
- Choose an existing destination or click Add a new destination.
- Select a destination from Snowflake, Amazon Redshift, or Google BigQuery.
|Pipeline name||A descriptive label for your pipeline. This is how the pipeline appears on the pipeline dashboard and how Matillion Data Loader refers to the pipeline.|
|Sync every||The frequency at which the pipeline should sync. Day values include 1—7. Hour values include 1—23. Minute values include 5—59. The input is also the length of delay before the first sync.|
Currently, you can't specify a start time.
Once you are happy with your pipeline configuration, click Create pipeline to complete the process and add the pipeline to your dashboard.