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_visitorand chat_webpath
• Talk API objects are: calls and legs
• 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:

- schema.activities

- schema.agent_metrics

- schema.agents

- schema.calls

- schema.chat

- schema.chat_agent

- schema.chat_agents

- schema.chat_history

- schema.chat_visitor

- schema.chat_webpath

- schema.chats

- schema.group_memberships

- schema.groups

- schema.legs

- schema.organization_fields

- schema.organization_memberships

- schema.organization_organization_fields

- schema.organizations

- schema.phone_numbers

- schema.satisfaction_ratings

- schema.sla_policies

- schema.ticket_audit_events

- schema.ticket_audits

- schema.ticket_custom_fields

- schema.ticket_event_child_events

- schema.ticket_events

- schema.ticket_fields

- schema.ticket_metric_events

- schema.ticket_metrics

- schema.tickets

- schema.user_fields

- schema.users

Next Steps

• Create a Zendesk Connector through UI or CLI
• Schedule a Demo

Additional Information

• Datacoral's Infrastructure

Got a question?

Please contact Datacoral's Support Team, we'd be more than happy to answer any of your questions.