Zendesk Connector Overview
Zendesk is a customer service software and support ticketing system. The Datacoral Zendesk connector collects data from a Zendesk API and writes it to an AWS S3 bucket and an AWS Redshift data warehouse
Features & Capabilities
- Backfill: Full historical sync of your entire data
- Data Extraction Modes: snapshot, incremental with pagination
- Data Load Modes: replace, append and merge
- Tables and Columns selection: The ability to select individual schemas, tables and columns for replication in the Datacoral's UI.
- Data-layout: changing the data type of your columns
- Customizations: Update the configurations easily using the UI
- Scheduling: Highly flexible scheduling system
Supported load units
The Zendesk slice automatically collects the following loadunits from the Zendesk API and makes them available in your warehouse for analysis.
Loadunit | Description |
---|---|
activities | this loadunit fetches data for ticket activities |
agent_metrics | this loadunit fetches data for agent metrics |
calls | this loadunit fetches data for calls data |
chat_visitor | process data for individual chat visitors |
chat_visitors | this loadunit fetches data for chat visitors |
chat | this loadunit fetches data for specific chat |
chats | this loadunit fetches data for chats |
group_memberships | this loadunit fetches data for group memberships |
groups | this loadunit fetches data for groups |
legs | this loadunit fetches data for call legs data |
organization_fields | this loadunit fetches data for organization fields |
organization_memberships | this loadunit fetches data for organization memberships |
organizations | this loadunit fetches data for organizations |
phone_numbers | this loadunit fetches data for phone numbers |
satisfaction_ratings | this loadunit fetches data for satisfaction ratings |
sla_policies | this loadunit fetches data for SLA policies |
ticket_audits | this loadunit fetches data for ticket audits |
ticket_events_comments | this loadunit fetches comment_events sideload data for ticket_events |
ticket_events | this loadunit fetches data for ticket events |
ticket_fields | this loadunit fetches data for ticket fields |
ticket_metric_events | this loadunit fetches data for ticket metric events |
ticket_metrics | this loadunit fetches data for ticket metrics |
tickets | this loadunit fetches data for tickets |
users | this loadunit fetches data for users |
note
Loadunits chat_agent
, chat_history
, chat_webpath
, chat_visitors
and organization_organization_fields
are child loadunits
- Chat objects are :
agent
,agent_metrics
,chats
,chat
,chat_agent
,chat_history
,chat_visitors
,chat_visitor
andchat_webpath
- Talk API objects are:
calls
andlegs
- The rest of the loadunits are Support API objects
Connector output
Output of this connector is stored in S3 and Redshift.
AWS S3
Data stored in AWS S3 is partitioned by date and time
s3://customer_installation.datacoral/<slice-name>
Warehouse: The schema name will be same as a connector-name. Tables produced by the connector are:
Next Steps
- Create a Zendesk Connector through UI or CLI
- Schedule a Demo
Additional Information
Got a question?
Please contact Datacoral's Support Team, we'd be more than happy to answer any of your questions.