SSIS Data Flow Components for Zendesk: Read and Write Zendesk Tickets in SSIS
Devart SSIS Data Flow Components for Zendesk add a Zendesk Source, Destination, Lookup and Connection Manager to SQL Server Integration Services on Windows, for $149.95 a year (Developer license) or $299.95 perpetual. They read Zendesk tickets, contacts, groups, tasks and help center articles with SQL, write changes back with inserts, updates and deletes, and sign in with an email plus an API token or password.
Support teams live in Zendesk, but questions like "which customers open the most tickets" or "how long do refunds take compared with last quarter" usually need ticket data next to CRM, billing and product data in SQL Server. Zendesk's own exports and API get you there with scripts that handle paging, rate limits and custom fields. These components make Zendesk objects look like tables in an SSIS data flow, so a nightly package can copy them, or push records from another system into Zendesk.
Quick facts
- Version: 5.2.145, released November 19, 2026
- Developer: Devart
- Components: Zendesk Source, Zendesk Destination, Zendesk Lookup, Zendesk Connection Manager
- Zendesk: Zendesk data types and API, including custom fields and custom objects; email with API token or password sign-in
- SSIS: SQL Server Integration Services 2012, 2014, 2016, 2017, 2019, 2022 and 2025
- Platform: Windows Vista or later, 32-bit and 64-bit (including Terminal Server), .NET Framework 4.5
- Download: 616.24 MB installer shared with the whole SSIS line; needs a free Devart account
- Price: $149.95 a year or $299.95 perpetual for a Developer license; Server and Site licenses cost more
- Trial: 30 days, fully functional
- Refund: Devart's ordering FAQ gives a full refund within 30 days only when a technical problem that support can't fix stops the product working
- What we checked: the order page charged $149.95 for the Developer license with one year of updates, $299.95 for a perpetual Developer license, $379.95 a year or $749.95 perpetual for Server, and $499.95 a year or $999.95 perpetual for a Site license, and the download page listed version 5.2.145 at 616.24 MB, on November 22, 2026. We didn't run a package against a Zendesk account.
Download Free TrialBuy Developer LicenseBuy Server LicenseBuy Site License
Overview
After installation the Zendesk components appear in the SSIS Toolbox in Visual Studio. You add a Devart Zendesk Connection Manager, enter your Zendesk subdomain, your email and an API token from Zendesk's Admin Center, and test the connection. Then you drop a Source, Destination or Lookup into a Data Flow task. Zendesk objects show up as tables with their fields, including the custom fields your admins added, and they work like any other SSIS source or destination next to SQL Server, flat files or other cloud apps.
Features
SQL over Zendesk tickets and more
The Zendesk Source in Devart's Zendesk SSIS components reads Zendesk objects with SQL, including grouping, filtering and ordering. Simple statements are turned into Zendesk API calls and run on Zendesk's side; for complex ones the data goes into a local cache and the query runs there. The source editor lists every object and field, builds a query by drag and drop, inserts package variables and previews the rows.
Faster ticket reads for big help desks
Devart's Zendesk SSIS components can query tickets through Zendesk's Search API (on by default) or its incremental export API, which is designed for pulling large numbers of tickets and only what changed. That matters for a nightly package on a help desk with years of history.
Custom fields and custom objects
Devart's Zendesk SSIS components read and write user-defined custom fields on Zendesk objects, and can retrieve metadata for Zendesk custom objects so their fields appear as columns. Custom lookup fields are supported too (since version 3.0), and version 5.0 added section and author fields to help center articles.
Write changes back to Zendesk
The Zendesk Destination in Devart's Zendesk SSIS components supports INSERT, UPDATE and DELETE with a batch size you set, so a package can create tickets from another system, update ticket fields in bulk, or load contacts from a CSV file.
A Lookup that batches and caches
The Zendesk Lookup in Devart's Zendesk SSIS components checks several incoming rows at once and caches the returned results, which saves API calls when you match many rows against Zendesk users or tickets.
Benefits
- No Zendesk API scripts to maintain. Zendesk objects behave like tables, and Devart keeps up with API changes.
- Support data in your warehouse. Tickets land in SQL Server next to CRM and billing data for Power BI or SSRS reports.
- Two-way. The same components read from Zendesk and load records into it.
- Built for volume. The incremental export option and batching Lookup keep large nightly loads reasonable.
Real-World Uses
- Support reporting. A nightly package copies tickets and their custom fields into SQL Server, where a Power BI report tracks volume and resolution time per product.
- Tickets from other systems. A package reads failed orders or alerts from an operations database and opens Zendesk tickets with the Destination.
- Contact sync. The Lookup matches CRM customers against Zendesk users and inserts only the new ones.
- Help center audits. A package exports help center articles with their sections and authors to find stale content.
Who It's For, and Who Should Skip It
These components suit companies that run SSIS on SQL Server and want Zendesk data in their warehouse, or need to create and update Zendesk records from other systems on a schedule.
Skip them if you don't use SSIS: Zendesk's own Explore reports, its export and apps from the Zendesk Marketplace are simpler outside the Microsoft stack. If you only need Zendesk data in Excel or Power BI, Devart's ODBC Driver for Zendesk is a lighter fit. And if your security rules require OAuth for Zendesk, note that the components sign in with an API token or password; Devart's documentation lists OAuth access tokens as not supported at present.
Usage Guide
- Sign in to Devart (a free account), download the installer from the product's download page and run it; select the Zendesk components and the SSIS versions you use.
- Create an API token in Zendesk: Admin Center, Apps and integrations, APIs, Zendesk API, Add API token. Copy it right away; Zendesk shows it only once.
- Add a connection in Visual Studio: in Connection Managers, add a Devart Zendesk connection, choose APIToken, and enter your subdomain, email and token.
- Read data: drag a Devart Zendesk Source into a Data Flow task, pick an object such as tickets or write a SELECT, and click Preview.
- Write data: add a Devart Zendesk Destination, choose the object and the action (insert, update or delete), map the columns and run the package.
Before you buy
The Developer license covers development and testing on one developer's machines only. Running packages on a production SSIS server needs a Server license ($379.95 a year or $749.95 perpetual) or a Site license. If you need three or more of Devart's SSIS sources, compare the SSIS Universal Bundle, which Devart sells for $499.95 a year or $999.95 perpetual and which includes Zendesk.
Where it falls short
- No OAuth sign-in yet. Connections use an email with an API token or password; the documentation says the OAuth access token type isn't supported at present.
- API speed. Everything goes through Zendesk's API, so a first full load of a busy help desk takes time, and complex queries run locally after the data is fetched.
- Windows and SSIS only. No use outside SQL Server Integration Services.
- Large download. The installer is over 600 MB even if you only want the Zendesk components.
- Few reviews. Only a dozen Capterra reviews cover the whole SSIS line, none of them about Zendesk specifically.
What Users Say
Capterra (whole SSIS line)
Review sites rate Devart's SSIS components as one product line, not the Zendesk components on their own. On Capterra, SSIS Data Flow Components average 4.6 out of 5 from 12 reviews, with 4.3 for ease of use and 4.3 for customer service.
Reviewers, mostly BI specialists, database administrators and integrators, describe the components as quick to set up inside Visual Studio and good value next to larger ETL suites; the criticisms are occasional bugs and packages that take effort to keep tidy as they grow. Test the trial against your own Zendesk account, with your custom fields, before deciding.
Comparisons
Zendesk SSIS components vs. Devart's ODBC Driver for Zendesk
Devart also sells an ODBC Driver for Zendesk for Excel, Power BI and other ODBC tools. For ETL packages in SSIS, the SSIS components fit better, with a Destination and Lookup built for data flows; for ad-hoc queries and reports outside SSIS, the driver is the one to buy.
Zendesk components vs. the SSIS Universal Bundle
The SSIS Universal Bundle includes Zendesk along with more than 40 other sources such as Freshdesk, Salesforce, HubSpot and Jira. If Zendesk is one of three or more sources you need, the bundle is the better deal; for Zendesk alone, these components cost far less.
Editions and Pricing
Each button opens the order page with that license and term selected; you can still change the term to 2 or 3 years or add premium support there. A perpetual license includes one year of updates and support.
FAQs
How do Devart's Zendesk SSIS components sign in to Zendesk?
Devart SSIS Data Flow Components for Zendesk sign in with your Zendesk subdomain and email plus either an API token or your password. An API token is the usual choice, since it can be revoked without changing your password.
Can Devart's Zendesk components export all tickets, not just recent ones?
Yes. Devart SSIS Data Flow Components for Zendesk read tickets through Zendesk's Search API by default, and an Incremental Export option switches to Zendesk's incremental export API, which suits large ticket histories.
Do the Zendesk SSIS components handle custom fields?
Yes. Devart SSIS Data Flow Components for Zendesk read and write custom fields by default and can expose the fields of Zendesk custom objects as columns.
Can Devart's SSIS components create Zendesk tickets?
Yes. The Zendesk Destination supports INSERT, UPDATE and DELETE, so a package can create tickets and contacts or update and delete existing records.
Which SSIS versions do the Zendesk components work with?
Devart SSIS Data Flow Components for Zendesk work with SQL Server Integration Services 2012, 2014, 2016, 2017, 2019, 2022 and 2025, on Windows Vista or later with .NET Framework 4.5.
Do I need a separate license for the production SSIS server?
Yes. The Developer license of SSIS Data Flow Components for Zendesk covers development and testing only; deploying packages to a server needs a Server license or a Site license.
What happens when the subscription ends?
The subscription license of SSIS Data Flow Components for Zendesk works for the term you paid for, so packages that use it need a renewal. A perpetual license keeps working at the version you have.
Can I get a refund?
Only for technical problems. Devart's ordering FAQ gives a full refund within 30 days of purchase when a bug or technical issue stops SSIS Data Flow Components for Zendesk working and support can't fix it, so use the 30-day trial first.
System Requirements
- Microsoft SQL Server Integration Services 2012, 2014, 2016, 2017, 2019, 2022 or 2025
- Visual Studio with Integration Services projects for designing packages
- Windows Vista or later, 32-bit or 64-bit, with .NET Framework 4.5
- A Zendesk account with an API token or password
Conclusion
Devart SSIS Data Flow Components for Zendesk are worth $149.95 a year to SSIS teams that need Zendesk tickets in SQL Server or want to create and update Zendesk records from other systems: you get SQL over Zendesk objects with custom fields, write-back, and an incremental export option for large help desks. Budget for a Server license for production. Without SSIS, Zendesk's own reports or Devart's ODBC driver are simpler, and if Zendesk is one of several sources, the Universal Bundle is better value.
Download Free TrialBuy Developer LicenseBuy Server LicenseBuy Site License