Devart ODBC Driver for Confluence Cloud: Confluence Content as SQL Tables for Excel, BI and Databases
Devart ODBC Driver for Confluence Cloud 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, Alteryx, DBeaver, Python and other ODBC tools query Atlassian Confluence Cloud with SQL, and change it with INSERT, UPDATE and DELETE. It signs in with OAuth and works only with Confluence Cloud, not Confluence Data Center or Server.
Confluence holds a company's documentation, but questions about that documentation (which spaces grow fastest, which pages nobody has touched in two years, who writes most of the content) are hard to answer from inside Confluence. The driver lets you ask them in SQL from the tools your analysts already use.
Quick facts
- Version: 1.5.0, released October 16, 2026; first released November 4, 2022
- Developer: Devart
- Platforms: Windows 32-bit and 64-bit, including Windows Terminal Server; Windows Vista or later with .NET Framework 4.5
- Works with: Confluence Cloud only
- Sign-in: OAuth refresh token plus your site's Cloud ID and Cloud Name; optional proxy
- Download: 32.97 MB EXE or 37.19 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 Confluence Cloud, 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.5.0 (EXE 32.97 MB, MSI 37.19 MB), on November 19, 2026. We didn't connect it to a Confluence site
Download Free Trial Buy Now
Overview
You install the driver, add a DSN in the ODBC Data Source Administrator, and authorize it against Atlassian so it keeps an OAuth refresh token. Two more values identify your site: the Cloud ID, Atlassian's unique ID for the site, and the Cloud Name, which Devart's manual describes as the first part of the email address you sign in with. Since version 1.2 (March 2024) the driver stores tokens and passwords encrypted in the DSN record. Proxy settings cover networks without direct HTTPS access.
Confluence objects then appear as tables. SQL-92 SELECT statements with joins, subqueries, WHERE filters, GROUP BY, aggregates and ORDER BY run against them, and INSERT, UPDATE and DELETE, alone or batched, send changes back to Confluence.
Features
SQL over Confluence Cloud
Devart ODBC Driver for Confluence Cloud maps Confluence Cloud objects to tables and the Confluence Cloud API's field types to ODBC data types in both directions, so a BI tool sees ordinary text, number and date columns. Joins, subqueries, grouping and aggregate functions all work.
Write-back and bulk updates
Devart ODBC Driver for Confluence Cloud supports INSERT, UPDATE and DELETE and can combine statements into batches for bulk changes, within what your Atlassian account is allowed to do.
OAuth sign-in with encrypted storage
Devart ODBC Driver for Confluence Cloud authenticates with an OAuth refresh token tied to your site's Cloud ID, so you never put an Atlassian password in a connection string, and version 1.2 started encrypting the stored tokens in the DSN.
Four years of fixes
Devart ODBC Driver for Confluence Cloud is older than most of Devart's SaaS drivers: first released in November 2022, with 13 releases so far. Releases fixed DATETIME columns in Tableau, linked-server licensing in SQL Server Management Studio, joins on linked tables in Access, OAuth sign-in and re-activation under another Windows user; 1.5 (October 2026) improved compatibility with Node.js, Visual FoxPro and DBeaver.
Settings for fussy tools
Devart ODBC Driver for Confluence Cloud can force ODBC 2.x or 3.x behaviour, return strings as ANSI or Unicode, convert dates to UTC or local time, use regional number and date formats, and skip foreign-key metadata. It honours SQL_ATTR_MAX_ROWS (added in 1.1), so tools that cap row counts don't pull the whole table first.
Benefits
- Content audits in Excel. List and sort Confluence content in a spreadsheet instead of clicking through spaces.
- Documentation metrics in BI. Chart activity by space or author next to your other dashboards.
- Atlassian data in one place. Join Confluence with Jira or HR data inside SQL Server or Power BI.
- Scriptable changes. Make bulk edits through SQL instead of the REST API.
Real-World Uses
- Stale-page clean-up. A knowledge manager pulls content with last-modified dates into Excel to find pages due for review or archiving.
- Documentation dashboard. A support lead charts how much content each team's space adds per month in Power BI.
- Compliance inventory. An IT auditor loads the list of spaces and their content into SQL Server through a linked server for a yearly review.
- Alteryx workflow. An analyst blends Confluence data with Jira issue data from Devart's Jira driver in one Alteryx workflow.
Who It's For, and Who Should Skip It
The driver suits knowledge managers, BI analysts and Atlassian administrators on Windows who want Confluence Cloud data in Excel, BI tools or SQL Server without writing REST API code.
Skip it if your company runs Confluence Data Center or Server (the driver works only with Cloud), if Confluence's built-in analytics answer your questions, or if you're on a Mac. A shared report server or gateway needs the Server license, which costs about seven times the Desktop one.
Usage Guide
- Sign in to devart.com with a free account, download the EXE or MSI, install it, and choose Trial or enter your activation key.
- Open ODBC Data Sources (32-bit or 64-bit, matching your application), click Add on the User DSN or System DSN tab, and pick Devart ODBC Driver for Confluence Cloud.
- Authorize the driver with your Atlassian account to get the refresh token, and fill in your site's Cloud ID and Cloud Name.
- Add proxy details if your network needs them, click Test Connection, then OK.
- In Excel, choose Data > Get Data > From Other Sources > From ODBC, pick the DSN, choose a table in the Navigator and click Load.
Before you buy
Confirm your Confluence is the Cloud edition: Data Center and Server sites aren't supported. The driver acts as the Atlassian user who authorized it, so it sees and changes only what that user can. The Desktop license covers one desktop computer used by one person at a time; a report server, Power BI gateway or SQL Server linked server shared by several people needs Server Standard ($799.95 a year) or higher.
Where it falls short
- Cloud only, Windows only. No Data Center or Server support, and no macOS or Linux build.
- No table reference. The online manual covers connection options but not the schema, so you browse the tables in your tool.
- Page bodies aren't spreadsheet-friendly. Confluence content is rich formatted text, so expect metadata to be far more useful in reports than page text.
- API speed. Large sites are read through Atlassian's web API, much slower than a database.
What Users Say
How Devart's ODBC line rates
The Confluence Cloud driver has no 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 the spaces you care about in the 30-day trial before relying on these general marks.
Comparisons
ODBC driver vs the Confluence REST API
Atlassian's REST API can return the same content, but you write and maintain the code, handle paging and OAuth, and flatten JSON yourself. The driver does that work and hands any ODBC tool plain tables.
Confluence driver vs Devart's ODBC Driver for Jira
Devart sells a separate ODBC driver for Jira at the same price. Teams that report on both Atlassian products need both drivers, and at that point Devart's ODBC Universal Bundle, which includes both and over 90 more, is worth pricing.
Editions and Pricing
| Edition | 1-year subscription | Perpetual | Typical use |
|---|
| Desktop for Windows | $109.95 | $219.95 | One person's PC |
| Server Standard for Windows | $799.95 | $1,599.95 | A report server or SQL Server machine shared by many users |
| Server Enterprise, Site, OEM | Quote | Quote | Larger 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
Does ODBC Driver for Confluence Cloud work with Confluence Data Center or Server?
No. Devart ODBC Driver for Confluence Cloud connects only to Atlassian's Confluence Cloud, using OAuth and the site's Cloud ID.
What are Cloud ID and Cloud Name in ODBC Driver for Confluence Cloud?
Devart ODBC Driver for Confluence Cloud needs both to find your site: the Cloud ID is Atlassian's unique identifier for the Confluence Cloud site, and the Cloud Name is, per Devart's manual, the first part of the email address you sign in with; both are set alongside the refresh token in the DSN or connection string.
Can ODBC Driver for Confluence Cloud change Confluence content?
Yes. Devart ODBC Driver for Confluence Cloud supports INSERT, UPDATE and DELETE and batched statements, limited by the permissions of the Atlassian user who authorized it.
Is there a Mac or Linux version?
No. Devart ODBC Driver for Confluence Cloud is offered for 32-bit and 64-bit Windows only.
What happens when the subscription year ends?
The yearly price of Devart ODBC Driver for Confluence Cloud includes a year of support and upgrades. The perpetual license ($219.95 for Desktop) keeps working after the first year; renewing support for new versions 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 Confluence Cloud working and support can't fix it. Use the 30-day trial on your own site first.
System Requirements
- Windows Vista or later, 32-bit or 64-bit, including Windows Terminal Server
- .NET Framework 4.5
- An Atlassian Confluence Cloud site and an account that can authorize OAuth access
- An ODBC-compatible application
- HTTPS access to Atlassian, directly or through a proxy
Conclusion
Devart ODBC Driver for Confluence Cloud is worth $109.95 a year if you need to audit or report on Confluence Cloud content in Excel, Power BI, Alteryx or SQL Server and would rather not maintain REST API scripts: it has four years of fixes behind it and supports write-back. If your Confluence runs on Data Center or Server, or you're on a Mac, it won't help. Try it against your own site in the 30-day trial.
Download Free Trial Buy Now