Zendesk

The Lyftron Provider for Zendesk offers the most natural way to access Zendesk data from Lyftron with ease and also enables to connect with BI, MDM & ML tools, Data warehouses, Databases and other SAAS based applications with zero code and zero infrastructure requirements. The provider wraps the complexity of accessing Zendesk data into easy-to-integrate relational fully managed ANSI Sql format. Make faster and better business decisions with Lyftron’s Zendesk data provider and automatically build your data migration pipelines in minutes, not months

The provider hides the complexity of accessing data and provides additional powerful security features, smart caching, batching, socket management, and more.

Key Features

• Comprehensive Delta load mechanism.
• Real-time access to Zendesk.
• Comprehensive full support of ANSI Sql to query data with ease.
• Collaborative query processing.

Prerequisites

The user must have credentials for Zendesk, Lyftron and your destination data warehouse, lake or database to perform the data pipeline operation with Lyftron

Establishing a Connection with Lyftron's Quickstart Steps

Create your Zendesk connection with Lyftron by following the 5 easy steps show below:

Step1. Add your connection

Click on Connect section on the left panel →  Click on Add Connection button

Step2. Select your connector

In the connector selection panel, search and click Zendesk for your connection 

Step3. Enter your connection details

In the Connection String section enter the values of the below parameters. The following connection string is required to establish Zendesk connection with Lyftron.

"URL=https://subdomain.zendesk.com;User=my@email.com;Password=test123;"

Key	Value	Field
Connection Name	Enter your connection details	Required
URL	Enter URL	Required
User	Enter User	Required
Password	Enter Password	Required
Logfile**	Use the logfile option to debug your job and provide your connection name to generate the log file.  [ConnectionConfigurationPath]\Connection_name_log.tx	Optional
Verbosity**	Choose verbosity 1-5 based on the severity of debugging	Optional

** For more information, check the Lyftron logging and debugging section.

If you want more detailed information about how to establish a connection with Lyftron, click on Lyftron Connection Quick Start guide.

Step4. Test your connection

Once you are done entering your connection details, simply click on the Test Connection button to test the connectivity. In case your connection fails, add Logfile and Verbosity parameters and check the Lyftron logging and debugging section, to debug the error.

 Step5. Save your connection

Hurray! Now you have successfully connected with the Lyftron Zendesk connector and can utilize the connector to Extract, Warehouse, Analyze, Visualize and Share your data.

Data Model

The Lyftron Provider for Zendesk models entities in the Zendesk API as tables, views, and stored procedures. These are defined in schema files, which are simple, text-based configuration files.

API limitations and requirements are documented in this section; you can use the SupportEnhancedSQL feature, set by default, to circumvent most of these limitations.

Tables

The Lyftron Provider for Zendesk models Item Listings in tables so that they can be easily queried, updated, and deleted. You can list items on your Zendesk store by calling the AddItem stored procedure.

Views

Views are tables that cannot be modified. Typically, read-only data are shown as views.

Name	Type	Description
AccountSettings	Tables	Query and update Account Settings in Zendesk.
Automations	Tables	Create, update, delete, and query Automations in Zendesk.
Brands	Tables	Create, delete, update, and query Brands in Zendesk.
GroupMemberships	Tables	Create, delete, and query Group Memberships in Zendesk.
Groups	Tables	Create, Update, delete, and query Groups in Zendesk.
Holidays	Tables	Create, update, delete, and query Schedules in Zendesk.
Macros	Tables	Create, update, delete, and query Macros in Zendesk.
OrganizationFields	Tables	Create, update, delete, and query Organization Fields in Zendesk.
OrganizationMemberships	Tables	Create, delete, and query Organization Memberships in Zendesk.
Organizations	Tables	Create, delete, update, and query Organizations in Zendesk.
OrganizationSubscriptions	Tables	Create, delete, and query Organization Subscriptions in Zendesk.
PostComments	Tables	Query, Insert, Update and Delete PostComments in Zendesk.
Posts	Tables	Query, Insert, Update and Delete Posts in Zendesk.
SatisfactionRatings	Tables	Create and query Requests in Zendesk.
Schedules	Tables	Create, update, delete and query Schedules in Zendesk.
Sessions	Tables	Query and delete Sessions in Zendesk.
SharingAgreements	Tables	Create, update, delete, and query SharingAgreements in Zendesk.
SupportAddresses	Tables	Create, update, delete, and query Support Addresses in Zendesk.
SuspendedTickets	Tables	Query and delete Suspended Tickets in Zendesk.
TicketFields	Tables	Create, update, delete, and query TicketFields in Zendesk.
TicketForms	Tables	Create, update, delete, and query Ticket Forms in Zendesk.
Tickets	Tables	Create, update, delete, and query Tickets.
Topics	Tables	Query, Insert, Update and Delete Topics in Zendesk.
Triggers	Tables	Create, update, delete, and query Triggers in Zendesk.
UserFields	Tables	Create, update, delete, and query User Fields.
UserIdentities	Tables	Create, update, delete, and query User Identities.
Users	Tables	Create, update, delete, and query Users in Zendesk.
Views	Tables	Query and delete Views in Zendesk.
ActivityStream	Views	Query ActivityStreams in Zendesk.
AppLocations	Views	Query AppLocations in Zendesk.
Attachments	Views	Show ticket attachments in Zendesk.
Collaborators	Views	Query Collaborators in Zendesk.
CustomAgentRoles	Views	Query CustomAgentRoles in Zendesk.
JobStatus	Views	A status record is created when somebody kicks off a job such as updating multiple tickets. You can access the job status data for an hour after a particular job is created, after which the data is no longer available.
Locales	Views	Query Locales in Zendesk.
MonitoredTwitterHandles	Views	Query Monitored Twitter handles in Zendesk.
Requests	Views	Query Requests in Zendesk.
SlaPolicies	Views	Query SlaPolicies in Zendesk.
TicketAudits	Views	Query TicketAudits in Zendesk.
TicketComments	Views	Query TicketComments belonging to a specified ticket in Zendesk.
TicketMetricEvents	Views	Query TicketMetricEvents in Zendesk.
TicketMetrics	Views	Query TicketMetrics in Zendesk.
UserRelatedInformation	Views	Query UserRelatedInformation in Zendesk.