Connectors

/

Zendesk Sunshine

Data replication

Sync Zendesk Sunshine data anywhere.

Taking the customer relationship management (CRM) platform up a notch, Zendesk Sunshine makes it possible for businesses to connect the dots to build the full picture of their customer from data anywhere. Offering much more than the old legacy CRM platform, Zendesk Sunshine takes a new and more modern approach, native to AWS, that provides the tools needed for developers and admins to create superior customer experiences.

  • Standard
  • Alpha
  • 6 streams
Sync Zendesk Sunshine dataRead the docs
Zendesk Sunshine

One connector

Everything Zendesk Sunshine can do in Airbyte

  • Sync to your warehouse

    Land 6 Zendesk Sunshine tables in 50+ destinations on a schedule you control.

  • One authorization

    Authenticate Zendesk Sunshine once and Airbyte keeps every scheduled sync running on it.

  • Cloud or self-hosted

    Run the Zendesk Sunshine connector on Cloud, Self-Managed Enterprise.

Specifications

What to know before you sync Zendesk Sunshine

  • Support levelStandard
  • Available onCloud, Self-Managed Enterprise
  • Connector version0.4.20
  • Release stageAlpha

Sync capabilities

  • Destinations50+ Airbyte connectors

Set up in 12 steps

  1. First, navigate to the Zendesk Sunshine source connector page on Airbyte.com.
  2. Click on the "Add Source" button to begin the process of adding your Zendesk Sunshine credentials.
  3. In the "Connection Configuration" section, enter your Zendesk Sunshine account subdomain and API token.
  4. To obtain your API token, log in to your Zendesk Sunshine account and navigate to the "Admin" settings. From there, click on "API" and generate a new token.
  5. Once you have entered your subdomain and API token, click on the "Test" button to ensure that the connection is successful.
  6. If the test is successful, click on the "Save & Continue" button to proceed to the next step.
  7. In the "Schema Selection" section, select the data that you want to replicate from your Zendesk Sunshine account.
  8. You can choose to replicate all data or select specific tables and columns.
  9. Once you have made your selections, click on the "Save & Continue" button to proceed to the final step.
  10. In the "Destination Configuration" section, select the destination where you want to replicate your Zendesk Sunshine data.
  11. You can choose from a variety of destinations, including databases, data warehouses, and cloud storage services.
  12. Once you have selected your destination, click on the "Create Connection" button to complete the process of connecting your Zendesk Sunshine source connector on Airbyte.com.

6 streams

Every table you can sync from Zendesk Sunshine

  • limits

  • object_types

  • object_records

  • object_type_policies

  • relationship_types

  • relationship_records

Authentication

Authenticate Zendesk Sunshine once

    • Recommended

    OAuth2.0

  • API Token

    • Recommended

    OAuth2.0 (Legacy)

Explore

Related connectors

Zendesk SupportSales & Support AnalyticsCertified Sources cloudself-managed-enterprise
Zendesk TalkSales & Support AnalyticsCertified Sources cloudself-managed-enterprise
ZenloopSales & Support AnalyticsStandard Sources cloudself-managed-enterprise
Zoho BiginSales & Support AnalyticsStandard Sources cloudself-managed-enterprise
Zoho DeskSales & Support AnalyticsStandard Sources cloudself-managed-enterprise
ZohoCRMSales & Support AnalyticsStandard Sources cloudself-managed-enterprise
All connectors

Common questions

Didn't find your answer?
Please don't hesitate to reach out.

Talk to sales

ETL, an acronym for Extract, Transform, Load, is a vital data integration process. It involves extracting data from diverse sources, transforming it into a usable format, and loading it into a database, data warehouse or data lake. This process enables meaningful data analysis, enhancing business intelligence.

Zendesk Sunshine's API provides access to a wide range of data categories, including:

1. Customer data: This includes information about customers such as their name, email address, phone number, and other contact details.
2. Ticket data: This includes information about customer support tickets, such as the status of the ticket, the customer's issue, and any notes or comments added by support agents.
3. Agent data: This includes information about support agents, such as their name, email address, and performance metrics.
4. Analytics data: This includes data about customer support performance, such as response times, ticket volume, and customer satisfaction ratings.
5. Integration data: This includes data about integrations with other systems, such as CRM or marketing automation platforms.
6. Custom data: This includes any custom data fields that have been added to the Zendesk platform, such as customer preferences or product information.

Overall, Zendesk Sunshine's API provides access to a wide range of data that can be used to improve customer support performance, gain insights into customer behavior, and integrate with other systems for a more seamless customer experience.

1. First, navigate to the Zendesk Sunshine source connector page on Airbyte.com.
2. Click on the "Add Source" button to begin the process of adding your Zendesk Sunshine credentials.
3. In the "Connection Configuration" section, enter your Zendesk Sunshine account subdomain and API token.
4. To obtain your API token, log in to your Zendesk Sunshine account and navigate to the "Admin" settings. From there, click on "API" and generate a new token.
5. Once you have entered your subdomain and API token, click on the "Test" button to ensure that the connection is successful.
6. If the test is successful, click on the "Save & Continue" button to proceed to the next step.
7. In the "Schema Selection" section, select the data that you want to replicate from your Zendesk Sunshine account.
8. You can choose to replicate all data or select specific tables and columns.
9. Once you have made your selections, click on the "Save & Continue" button to proceed to the final step.
10. In the "Destination Configuration" section, select the destination where you want to replicate your Zendesk Sunshine data.
11. You can choose from a variety of destinations, including databases, data warehouses, and cloud storage services.
12. Once you have selected your destination, click on the "Create Connection" button to complete the process of connecting your Zendesk Sunshine source connector on Airbyte.com.

The most prominent ETL tools to transfer data to include: Airbyte, Fivetran, StitchData, Matillion, Talend Data Integration. These tools help in extracting data from various sources (APIs, databases, and more), transforming it efficiently, and loading it into and other databases, data warehouses and data lakes, enhancing data management capabilities.

ELT, standing for Extract, Load, Transform, is a modern take on the traditional ETL data integration process. In ELT, data is first extracted from various sources, loaded directly into a data warehouse, and then transformed. This approach enhances data processing speed, analytical flexibility and autonomy.

ETL and ELT are critical data integration strategies with key differences. ETL (Extract, Transform, Load) transforms data before loading, ideal for structured data. In contrast, ELT (Extract, Load, Transform) loads data before transformation, perfect for processing large, diverse data sets in modern data warehouses. ELT is becoming the new standard as it offers a lot more flexibility and autonomy to data analysts.

Start moving Zendesk Sunshine data today

Free for 14 days on Airbyte Cloud. Set up the Zendesk Sunshine connector once and let Airbyte keep it in sync.

Try it freeTalk to sales