Devart ODBC Driver for Streak: Your Gmail CRM Pipelines as SQL Tables
Devart ODBC Driver for Streak is a $109.95-per-year Windows ODBC driver for Streak, the CRM that lives inside Gmail. Paste your Streak API key into its setup dialog, and Excel, Access, Power BI, Tableau, SQL Server or a script can query your pipelines, stages, boxes and tasks with SQL, and update them too.
Streak keeps deals and contacts right next to the email threads they came from, which is why small sales, hiring and partnership teams like it. Reporting is where it gets thin: pipeline totals by stage, overdue tasks across the team or a hiring funnel by month usually mean an export. The driver gives those questions a live connection instead.
Quick facts
- Version: 1.7.0, released October 16, 2026 (first released December 15, 2021)
- Developer: Devart
- Platform: Windows Vista or later, 32-bit and 64-bit, including Terminal Server, with .NET Framework 4.5 or later
- Sign-in: a Streak API key, which you find in Streak's integrations list
- Objects: Devart's Streak connectivity covers boxes, tasks, stages, pipelines and other Streak objects
- Price: $109.95 per year for Desktop, or $219.95 perpetual
- Trial: 30 days with a trial key from a Devart account
- Refund: within 30 days when a technical fault that support can't fix stops it working
- What we checked: the order page charged $109.95 for Desktop for Windows, 1-year subscription. The download page listed version 1.7.0 with a 32.38 MB EXE and a 36.40 MB MSI. All checked on November 14, 2026. We didn't install the driver or connect it to a Streak account
Before you buy
A Streak API key acts as the user it belongs to, so the driver sees the pipelines that user is part of. Use the key of someone with access to every pipeline the report needs, and keep it private: anyone with the key and the driver can read and change those boxes. Unticking Save API Key keeps the key out of the DSN on a shared computer.
Download Free Trial Buy Now
Overview
Streak organises work as pipelines (a sales process, a hiring process), each with stages, and every deal, candidate or project in a pipeline is a box, which can carry tasks. Devart's driver turns those objects into tables. Once a DSN holds your API key, a pivot table of boxes by stage or a Power BI chart of tasks per teammate is a query away.
The DSN dialog has a single field that matters, the API key, plus proxy settings. That makes this one of the simplest Devart drivers to set up. Since late 2021 it has had steady compatibility releases, including fixes for Access linked-table JOINs, Tableau date columns and Excel imports.
The Streak DSN dialog: data source name, the API key with Save API Key ticked, and empty proxy settings.
Features
Pipelines, stages, boxes and tasks as tables
Devart ODBC Driver for Streak exposes Streak's core objects so you can JOIN boxes to their stages and pipelines, count tasks per person, or filter boxes by any column, with SQL-92 SELECT syntax including subqueries, GROUP BY and aggregate functions.
Updates from a spreadsheet or Access
Devart ODBC Driver for Streak supports INSERT, UPDATE and DELETE. Moving a batch of boxes to a new stage, or creating boxes from a list of leads in Access, can be done with SQL rather than one drag at a time in Gmail.
One key, stored encrypted
Devart ODBC Driver for Streak connects with nothing but an API key, and it has stored keys encrypted in the DSN since version 1.4.0.
Real-World Uses
- Sales pipeline review. A founder refreshes an Excel pivot of open boxes by stage before the Monday meeting.
- Hiring funnel. A recruiter counts candidates per stage per month in Power BI from a Streak hiring pipeline.
- Task follow-up. A team lead lists overdue tasks by assignee in Access every morning.
- Lead import. An assistant loads a list of event contacts into a Streak pipeline with INSERT statements from a spreadsheet.
Who It's For, and Who Should Skip It
Devart ODBC Driver for Streak suits small teams that run sales, hiring or deal flow in Streak, work on Windows, and want reports in Excel, Access or Power BI that Streak's own views don't give them.
Skip it if Streak's built-in views and exports are enough, or if you work on a Mac; the driver is Windows-only. Developers can call Streak's API directly at no extra cost.
Usage Guide
- In Streak, open the integrations list and copy your API key.
- Download the trial from the Download button (Devart account needed) and run the EXE or MSI.
- Open ODBC Data Sources (the bitness must match your application), click Add and choose Devart ODBC Driver for Streak.
- Activate the trial key on the License tab.
- Paste the API key, decide whether to save it, add a proxy if you use one, and click Test Connection.
- Connect from Excel, Power BI, Access or DBeaver by picking the DSN.
Where It Falls Short
- Windows only. Mac and Chromebook users can't run it.
- One person's view. The API key limits the data to that user's pipelines.
- No table reference. Devart doesn't publish a list of the Streak tables and columns; you browse them in your tool.
- API speed. Large pipelines with long histories load more slowly than a real database.
What Users Say
The Streak driver isn't reviewed separately: review sites rate Devart's ODBC drivers as one product.
Devart's ODBC line on review sites
Capterra: 4.7 out of 5 from 26 reviews. G2: 4.6 out of 5 from 18 reviews. TrustRadius: 5.2 out of 10 from 58 ratings. Reviewers on the first two describe the drivers as quick to install and easy on the budget, and one G2 reviewer credits them with helping a CRM transition. Complaints focus on the learning curve for writing SQL against cloud data, on unclear error messages, and, for a few buyers, on never getting a connection to work at all.
For a Streak team, the trial answers the only question that matters: whether your pipelines and boxes show up the way your report needs them.
Comparisons
ODBC driver vs Streak's exports
Exporting a pipeline from Streak is free and fine once a quarter. The driver costs $109.95 a year and pays off when the same report is rebuilt every week, or when Streak data has to sit next to other numbers in Power BI or Access.
ODBC driver vs Devart SSIS components for Streak
Devart's SSIS components for Streak are for scheduled loads into SQL Server through Integration Services. The ODBC driver is for live use from desktop tools; most small teams will want the driver.
Editions and Pricing
Order any edition with the Buy Now button, then choose the edition and a subscription or perpetual license on the order page. Prices as listed on November 14, 2026.
| Edition | Yearly | Perpetual | Covers |
|---|
| Desktop for Windows (selected by default) | $109.95 | $219.95 | One computer, one user at a time |
| Server Standard for Windows | $799.95 | $1,599.95 | One server up to 6 cores, several users |
| Server Enterprise, Site, OEM | On request | On request | Bigger servers, device bands, redistribution |
Subscriptions run for their term and check the license online; a perpetual license activates offline and doesn't expire.
FAQs
Where do I find the API key for the Streak ODBC driver?
Devart ODBC Driver for Streak uses the API key shown in Streak's integrations list. Copy it into the API Key field of the DSN.
Does the Streak driver work on a Mac or Chromebook?
No. Devart ODBC Driver for Streak is a Windows-only ODBC driver, for 32-bit and 64-bit Windows applications.
Can the whole team share one Streak driver license?
No. Devart ODBC Driver for Streak's Desktop license covers one user at a time on one computer; shared access through a server needs Server Standard or Server Enterprise.
What is Devart's refund policy?
Devart ODBC Driver for Streak can be refunded within 30 days of purchase only if a technical issue keeps it from working and Devart's support can't fix it.
System Requirements
- Windows Vista or later, 32-bit or 64-bit, including Windows Server and Terminal Server
- .NET Framework 4.5 or later
- Only one version of the driver installed
- A Streak account and its API key, and HTTPS internet access (proxy supported)
Conclusion
Devart ODBC Driver for Streak is a sensible $109.95-a-year purchase for a Streak team on Windows that wants real pipeline reports in Excel or Power BI: setup is a single API key, and SQL handles the stage and task summaries Streak's views can't. The main reason to pass is the platform; teams on Macs or Chromebooks can't use it, and occasional exports may be all a small team needs. Try it free for 30 days first.
Download Free Trial Buy Now