ODBC Driver for Trello
ODBC Driver for Trello boxshot
Version
1.3.0
License
Shareware
Trial Limitations
30-day full-featured trial
Operating Systems
Windows (32-bit and 64-bit)
System Requirements
Windows Vista or later, 32-bit or 64-bit, .NET Framework 4.5. A Trello account and token. An ODBC application
File Size
35.76 MB
Release Date
10/16/2026
Last Updated
11/19/2026
3 views 0 downloads
ODBC driver that puts Trello boards, lists and cards into Excel, BI and SQL

Devart ODBC Driver for Trello: Trello Boards, Lists and Cards as SQL Tables

Devart ODBC Driver for Trello is a Windows ODBC driver, $109.95 a year for one desktop or $219.95 perpetual, that lets Excel, Power BI, Tableau, Access, SQL Server linked servers, DBeaver, Python and other ODBC tools read and change Trello boards, lists and cards with SQL. It connects to Trello over HTTPS with a Trello token and needs no other client software.

Trello is easy to use on screen and awkward to report on. Its own exports are per board, and answering "how many cards sit in Doing across all our boards" or "which cards are past due and who owns them" usually means a Power-Up, a paid automation tool, or a script against the Trello API. The driver turns that data into tables your existing reporting tools already understand.

Quick facts

  • Version: 1.3.0, released October 16, 2026; first released March 13, 2025
  • Developer: Devart
  • Platforms: Windows 32-bit and 64-bit, including Windows Terminal Server; Windows Vista or later with .NET Framework 4.5
  • Sign-in: a Trello token, with optional proxy server settings
  • Download: 35.76 MB EXE or 39.84 MB MSI installer
  • Price: $109.95 a year or $219.95 perpetual for Desktop; $799.95 a year or $1,599.95 perpetual for Server Standard
  • Trial: 30 days, full-featured (download needs a free Devart account)
  • Refund: Devart's ordering FAQ gives a 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 $109.95 for ODBC Driver for Trello, Desktop for Windows with one year of support and upgrades, Devart's ordering data listed $219.95 perpetual and $1,599.95 perpetual for Server Standard, and the download page listed version 1.3.0 (EXE 35.76 MB, MSI 39.84 MB), on November 19, 2026. We didn't connect it to a Trello account

Download Free Trial Buy Now

Overview

You install the driver, add a DSN in the Windows ODBC Data Source Administrator (or write a connection string such as Token=...), and paste in the token that authorizes the driver to read your Trello account. If the PC can't reach Trello directly, proxy host, port, user and password fields route the traffic through your proxy.

Trello objects then show up as tables in any ODBC application. You query them with SQL-92 SELECT statements, including joins, subqueries, WHERE filters, GROUP BY, aggregate functions and ORDER BY, and you change them with INSERT, UPDATE and DELETE, which go back to Trello through its API.

Features

SQL across boards, lists and cards

Devart ODBC Driver for Trello exposes Trello boards, lists and cards as tables, so one SELECT can join cards to their lists and boards, count cards per list, or filter by due date across every board the token can see. Trello field types map to ODBC types in both directions.

Write back to Trello

Devart ODBC Driver for Trello supports INSERT, UPDATE and DELETE, and can combine statements into batches for bulk updates. That lets you create cards from a spreadsheet of tasks or move a group of cards in one statement instead of dragging them one by one.

Trello-specific connection options

Devart ODBC Driver for Trello has a Customized Board Cards option for personalizing the data shown for each card on a board, and a Suppress Extended Requests option that cuts the number of API calls by skipping the extra requests the driver otherwise makes to fill in missing fields. Fewer calls means faster loads and less risk of hitting Trello's API limits.

Works with common tools

Devart ODBC Driver for Trello has step-by-step connection guides from Devart for Excel, Power BI, Tableau, Qlik Sense and QlikView, DBeaver, SQL Server Management Studio, Access, Python, PHP, Node.js and dozens more. Version 1.3 (October 2026) improved compatibility with Node.js, Visual FoxPro and DBeaver, and 1.2 (April 2026) added fixes for Qlik Replicate and PHP's PDO_ODBC.

Tuning for awkward tools

Devart ODBC Driver for Trello lets you force ODBC 2.x or 3.x behaviour, return strings as ANSI or Unicode, use local regional settings for numbers and dates, return dates as UTC, set connection and query timeouts, and turn foreign-key metadata on only when a tool needs it. These switches fix most of the odd errors older BI and reporting tools throw.

Benefits

  • Cross-board reporting. See every board's cards in one table instead of exporting board by board.
  • Live refresh. An Excel or Power BI report updates from Trello on demand, with no CSV step.
  • Join with other data. Match Trello cards to tickets, invoices or time sheets held in SQL databases.
  • Bulk edits. Change labels, due dates or lists on many cards with one UPDATE.

Real-World Uses

  • Team workload dashboard. A team lead builds a Power BI page showing open cards per member and per list across all project boards.
  • Overdue card list in Excel. A project coordinator refreshes a workbook each Monday listing cards past their due date.
  • Content calendar export. A marketing team pulls its editorial board into Excel to share with people who don't use Trello.
  • Board history in a warehouse. A developer copies Trello tables into SQL Server through a linked server each night to keep history Trello itself doesn't report on.

Who It's For, and Who Should Skip It

The driver suits analysts, project managers and developers who already work in Excel, Power BI, Tableau or SQL and want Trello data there without writing API code, especially teams running many boards.

Skip it if one board's CSV export once a month is all you need, or if your team only needs charts inside Trello, which Trello's own views and Power-Ups cover. It's Windows-only, so Mac users need another route, and a report server shared by many users needs the far dearer Server license.

Usage Guide

  1. Sign in to devart.com with a free account, download the EXE or MSI, run it, and choose Trial (or enter your activation key).
  2. Open ODBC Data Sources (32-bit or 64-bit, matching your application), go to User DSN or System DSN, and click Add.
  3. Pick Devart ODBC Driver for Trello, name the DSN, and enter your Trello token, plus proxy details if you need them.
  4. Click Test Connection, then OK.
  5. In Excel, choose Data > Get Data > From Other Sources > From ODBC, pick the DSN, select a table in the Navigator and click Load.

Before you buy

The Desktop license covers one desktop computer used by one person at a time, directly or remotely. A Power BI gateway, report server or SQL Server linked server that several people use needs Server Standard ($799.95 a year) or higher. Every query goes through Trello's web API, so large boards with long card histories load far slower than a database, and your Trello account's API rate limits apply.

Where it falls short

  • Windows only. There's no macOS or Linux build of the Trello driver.
  • Thin documentation. The online manual covers the connection options but has no table reference, so you learn the schema by browsing it in your tool.
  • API speed. Reading many boards with Suppress Extended Requests off means many API calls.
  • Young product. First released in March 2025, with no reviews of its own yet.

What Users Say

How Devart's ODBC line rates

The Trello driver hasn't collected reviews of its own on the major review sites. Capterra rates Devart's ODBC drivers as one line, at 4.7 out of 5 from 26 reviews, and G2 at 4.6 out of 5 from 18. Those reviewers mostly use the database and Salesforce drivers. They praise the quick install and stable connections. The usual complaints are the cost once you need several drivers, documentation that is thin on how to supply credentials, and DSN setup that trips up first-time users. Test your own boards and largest queries in the 30-day trial before relying on these general marks.

Comparisons

ODBC driver vs Trello's own export

Trello's built-in export works one board at a time and produces a file you have to clean up and re-export whenever the board changes. The driver reads every board the token can see as live tables, and can write changes back.

Trello driver vs Devart's ODBC Universal Bundle

Devart's ODBC Universal Bundle includes this driver along with drivers for more than 90 databases and cloud apps (Jira, Asana, ClickUp and others among them). If you need two or three sources, compare the bundle's price before buying single drivers.

Editions and Pricing

Edition1-year subscriptionPerpetualTypical use
Desktop for Windows$109.95$219.95One person's PC
Server Standard for Windows$799.95$1,599.95A report server or SQL Server machine shared by many users
Server Enterprise, Site, OEMQuoteQuoteLarger servers, company-wide installs, or shipping the driver in your own product

Buy Now opens the order page on Desktop for Windows with a 1-year subscription. The edition, subscription or perpetual license, and a 1-, 2- or 3-year support term are chosen there; all editions are sold under the same order page.

FAQs

How does ODBC Driver for Trello sign in to Trello?

Devart ODBC Driver for Trello authenticates with a Trello token entered in the DSN or in the connection string's Token parameter; the token decides which boards and workspaces the driver can see.

Can ODBC Driver for Trello create or move Trello cards?

Yes. Devart ODBC Driver for Trello supports INSERT, UPDATE and DELETE and batched statements, within what the token's Trello account is allowed to change.

Does ODBC Driver for Trello work with free Trello accounts?

Devart ODBC Driver for Trello works through Trello's public API, which every Trello plan offers, so the plan limits only which boards and features exist, not the connection.

Is there a Mac or Linux version?

No. Devart ODBC Driver for Trello is offered for 32-bit and 64-bit Windows only.

Do I need the Server license for a Power BI gateway or linked server?

Usually yes. Devart ODBC Driver for Trello's Desktop license is for one user on one desktop computer at a time; shared use on a server needs Server Standard or higher.

What happens when the subscription year ends?

The yearly price of Devart ODBC Driver for Trello includes a year of support and upgrades. The perpetual license ($219.95 for Desktop) keeps the driver working with a year of updates included; renewing support is optional.

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 ODBC Driver for Trello working and support can't fix it. Use the 30-day trial on your own boards first.

System Requirements

  • Windows Vista or later, 32-bit or 64-bit, including Windows Terminal Server
  • .NET Framework 4.5
  • A Trello account and token
  • An ODBC-compatible application
  • HTTPS access to Trello, directly or through a proxy

Conclusion

Devart ODBC Driver for Trello is worth $109.95 a year if you report on Trello in Excel, Power BI, Tableau or SQL and you're tired of exporting board by board: every board becomes live tables, SQL joins work across them, and bulk edits go back to Trello. If one board's export now and then is enough, or you're on a Mac, it isn't for you. Run the 30-day trial against your busiest boards before you buy.

Download Free Trial Buy Now

Submit Your Review
Your Name:
Rating:
(Please click on one of the stars to indicate your rating.)
One Line Summary:
Review:
No html tags are allowed.
Submit Review
We may earn a commission when you buy through links on this page.
Copyright © 2026, Ivertech. All rights reserved.