Skip to main content

New

TROCCO

Automate data pipelines from Zendesk Support to BigQuery, Snowflake and more

No Ratings

Leave a review

Works with

Support

Developer

primeNumber Inc.

About this app

TROCCO is a cloud-based ETL and data integration service used by more than 2,500 companies and organizations.

About primeNumber

primeNumber Inc. builds and operates TROCCO, a managed data integration platform. TROCCO combines the capabilities needed to build and run an analytics data platform - data transfer (ETL), data transformation (ELT), workflow orchestration, and access control - in a single service. Because it is delivered as a cloud service, teams can start quickly without upfront investment or infrastructure to maintain.

What this integration does

This integration lets you extract data from Zendesk Support and load it into your own data warehouse on a schedule, without writing code.

  • Connect your Zendesk Support account to TROCCO using OAuth

  • Load tickets, users, organizations and related Zendesk Support objects into BigQuery, Snowflake, Amazon Redshift and other supported destinations

  • Configure transfers, scheduling, retries, parallelism and error notifications from a GUI

  • Combine Zendesk Support data with sales, marketing, product and HR data from 200+ other connectors to build a single analytics layer

  • Transform loaded data into analysis-ready tables using SQL-based data marts and dbt integration

  • Validate data quality with configurable data checks

Data handling

When you authorize the integration, TROCCO reads your Zendesk Support data through the Zendesk API using the scopes you grant, and writes it to the destination you configure. Data is processed by TROCCO only to perform the transfers you set up. Credentials are encrypted with AWS KMS and all communication uses TLS. primeNumber holds SOC 2 Type 2 and operates an information security management system conforming to ISO/IEC 27001. Role-based access control and SAML SSO are available.

Privacy policy: https://primenumber.com/privacy/

Pricing

The integration is available at no additional charge. Using it requires a TROCCO account; see https://primenumber.com/trocco/pricing for TROCCO plans.

Support

  • Documentation: https://documents.trocco.io/

  • Help center: https://help.trocco.io/hc/ja

  • Contact: trocco-support@primenumber.co.jp

App details

How to install

A TROCCO account is required to use this integration. TROCCO offers a free plan.

  1. Sign up for TROCCO at https://primenumber.com/services/trocco/free-plan/ and sign in.

  2. In the left-hand navigation, open Connections (接続情報) and select Create (新規作成).
  3. Choose Zendesk Support from the service list.

  4. Enter a name for the connection, then start the Zendesk Support authorization. You are redirected to Zendesk to grant access. Sign in with an account that has permission to read the data you want to transfer.

  5. After you are returned to TROCCO, save the connection.

  6. Open Data Transfer > Transfer Settings (データ転送 > 転送設定) and select Create (新規作成).
  7. Select Zendesk Support as the source and choose the connection you created. Select your data warehouse - for example BigQuery or Snowflake - as the destination.

  8. Configure the objects to transfer and the output settings, then run the job once to confirm it succeeds.

  9. Optionally attach a schedule and notification settings so the transfer runs automatically.

If you need help, contact trocco-support@primenumber.co.jp or see https://documents.trocco.io/.

Leave a review

Share your experience with the rest of the Zendesk community

.zendesk.com