Devart ODBC Driver for Salesforce Marketing Cloud: Marketing Data and Data Extensions in Any ODBC Tool
Devart ODBC Driver for Salesforce Marketing Cloud is a $179.95-per-year Windows ODBC driver that opens Marketing Cloud (the platform once called ExactTarget) to Excel, Access, Power BI, Tableau, SQL Server and any other ODBC tool. Marketing Cloud objects, and your own Data Extensions if you switch them on, appear as SQL tables you can query, join and update. It signs in with a user name and password, an App Center client, or a Server-to-Server installed package.
Marketing Cloud's own Query Activities and Automation Studio work inside the platform. The moment an email team wants campaign results in the same Power BI model as web sales, or a CRM admin needs to bulk-fix a Data Extension from a spreadsheet, the data has to come out. This driver is one way to get it out without writing SOAP or REST code.
Quick facts
- Version: 1.15.0, released October 16, 2026 (the driver has been on sale since July 2016)
- Developer: Devart
- Platform: Windows Vista or later, 32-bit and 64-bit, including Terminal Server, .NET Framework 4.5 or later
- Authentication: User and Password (the default), App Center Client with an optional sandbox account, or Server to Server with your tenant subdomain
- Extras: Partner IDs for business units, Data Extensions as tables, a metadata cache, proxy support
- Price: $179.95 per year for one user (Desktop), $349.95 perpetual
- Trial: 30 days, after activating a trial key from a Devart account
- Refund: within 30 days of purchase, limited to technical problems Devart's support can't fix
- What we checked: the order page charged $179.95 for Desktop for Windows on a 1-year subscription, renewing every 12 months. The download page listed version 1.15.0 with a 31.66 MB EXE and a 35.48 MB MSI. All checked on November 14, 2026. We didn't install the driver or connect it to a Marketing Cloud account
Before you buy
Pick the sign-in method your Marketing Cloud admin will actually allow. The default User and Password mode points at a web service address (the sample uses the s7 stack, webservice.s7.exacttarget.com), so you need the endpoint for your own account's stack. Many admins prefer an installed package instead: that's the Server to Server mode, which needs the 28-character tenant subdomain starting with "mc" plus a client ID and secret. Reading Data Extensions is off by default and takes extra time when on, so enable it only if you need them.
Download Free Trial Buy Now
Overview
This is one of Devart's older cloud drivers. It shipped in July 2016 under the ExactTarget name and has had more than 25 releases since, gaining App Center Client sign-in in 2018, the Data Extensions option and Server-to-Server authentication in 2023, and a metadata cache in 2024. The current release is part of Devart's twice-yearly update cycle.
You install it on a Windows machine, create a DSN with your Marketing Cloud credentials, and every ODBC program on that machine sees Marketing Cloud as a database. SELECT statements support JOINs, subqueries, grouping and aggregates, and INSERT, UPDATE and DELETE write changes back.
The driver's DSN dialog in User and Password mode: the exacttarget.com web service address, user ID, saved password, a Partner IDs field and proxy settings.
Features
Data Extensions as ordinary tables
Devart ODBC Driver for Salesforce Marketing Cloud reads your Data Extensions, the custom tables most Marketing Cloud accounts are built around, and treats them like the predefined objects once you set the Extension Objects option to true. That's what lets you join a "Loyalty Members" extension against other Marketing Cloud data, or update it from Access.
Three authentication modes
Devart ODBC Driver for Salesforce Marketing Cloud supports a user name and password, an App Center Client ID and secret (with a switch for sandbox accounts), and Server to Server authentication using a tenant subdomain plus an installed package's client ID and secret. The last suits shared reporting machines, where no person's login should be stored.
Business units through Partner IDs
Devart ODBC Driver for Salesforce Marketing Cloud has a Partner IDs setting that limits retrieve requests to specific partner accounts or business units. In an enterprise account with a business unit per brand or country, one DSN per unit keeps each report to its own data.
A metadata cache for faster connects
Devart ODBC Driver for Salesforce Marketing Cloud can cache object metadata in a temporary database and reset it every hour, day or month, or keep it until the driver unloads. With many Data Extensions, this saves the wait while the driver rediscovers them on each connection.
Benefits
- Email results beside revenue. Campaign and subscriber data join sales or web data in Power BI or SQL Server.
- Fewer manual exports. Reports refresh from the platform rather than from CSV files someone downloads every Monday.
- Bulk Data Extension edits. Fix or load records with SQL instead of import wizards.
- Works with older stacks. SSRS, Access linked tables and MapInfo appear in the driver's compatibility history.
Real-World Uses
- Weekly campaign report. A marketing analyst builds a Power BI page on campaign data that refreshes without anyone logging in to Marketing Cloud.
- Suppression list upkeep. A CRM admin compares a Data Extension against a list in Excel and deletes the stale rows with one statement.
- Brand-level reporting. An agency sets one DSN per business unit with Partner IDs, so each client's report reads only that client's data.
- Warehouse feed. IT reads Marketing Cloud through a SQL Server linked server and copies it nightly into the company warehouse.
Who It's For, and Who Should Skip It
Devart ODBC Driver for Salesforce Marketing Cloud is for marketing operations, CRM and BI people on Windows who want Marketing Cloud data in tools they already know, and who can get an installed package or API user from their Marketing Cloud admin.
Skip it if your reporting can stay inside Marketing Cloud's own analytics and Query Activities, or if you're on a Mac or Linux. Developers who'd rather work in .NET code should look at Devart's dotConnect provider for the same service; spreadsheet-only users may prefer Devart's Excel Add-in, which also exists for Marketing Cloud.
Usage Guide
- Ask your Marketing Cloud admin which access to use: an API user, or an installed package with client ID, secret and tenant subdomain.
- Download the trial with the Download button (sign in to a Devart account) and run the EXE or MSI.
- Open ODBC Data Sources (32-bit or 64-bit, to match your application), click Add and choose Devart ODBC Driver for Salesforce Marketing Cloud.
- Activate the trial key on the License tab.
- Choose the authentication mode and fill in its fields; add Partner IDs if you report on specific business units.
- On Advanced Settings, turn on Extension Objects if you need Data Extensions and pick a Cache Metadata interval, then Test Connection.
- Open the DSN from Excel, Power BI, Access or your tool of choice.
Tip
Big Data Extensions and long send histories can hold millions of rows. Put a filter in the WHERE clause of every query on them, or a Power BI refresh can spend minutes pulling history you don't need.
Where It Falls Short
- Windows only. There's no macOS or Linux edition.
- Setup depends on your admin. Without the right endpoint, installed package or permissions, the driver can't connect, and those are controlled inside Marketing Cloud.
- Slow discovery with many Data Extensions. Devart itself warns that reading Data Extension information adds time; the metadata cache is the workaround.
- Priced above Devart's simpler cloud drivers. At $179.95 a year it costs more than the $109.95 tier many SaaS drivers sit in.
What Users Say
The Marketing Cloud driver has no review profile of its own. The sites below rate Devart's ODBC drivers as one line; where a reviewer named a specific driver, that's noted.
On Devart's other Salesforce driver
The nearest relative with a review is Devart's ODBC driver for Salesforce's CRM (Sales Cloud), a different product from this one but built on the same framework. A Capterra reviewer called it "a very reliable, well-performing product."
Support and day-to-day use (Capterra, TrustRadius)
Support gets credit on Capterra, where one reviewer wrote: "Customer Support is very responsive. Although they may be in a different time zone." TrustRadius reviewers are less warm overall, rating the line 5.2 out of 10 from 58 ratings; their main complaints are that the user interface could be better and that error messages could be more specific, which matters when a Marketing Cloud permission is missing and the driver has to tell you why.
Ratings at a glance
Capterra: 4.7 out of 5 from 26 reviews, with 92% of them positive. G2: 4.6 out of 5 from 18 reviews. TrustRadius: 5.2 out of 10 from 58 ratings.
Reliability and responsive support are what people praise; vague errors and a dated interface are what they put up with. For Marketing Cloud in particular, the setup step (authentication, business units, Data Extensions) is where to spend the trial.
Comparisons
ODBC driver vs Devart's other Marketing Cloud products
Devart sells the same Marketing Cloud connectivity in several forms: this ODBC driver for any ODBC tool, the dotConnect ADO.NET provider for .NET developers, an Excel Add-in for spreadsheet users, SSIS components for ETL packages and an MCP server for AI assistants. Choose the ODBC driver when several different tools (BI, Access, SQL Server, scripts) need the data.
ODBC driver vs Marketing Cloud's built-in tools
Query Activities, Automation Studio and data extracts are included with Marketing Cloud and run inside the platform. They're the better choice for work that stays there, such as building audiences. The driver is for getting live data into outside tools and for editing it from them.
Editions and Pricing
One Buy Now button covers every edition: choose the edition and the subscription or perpetual license on the order page. Prices as listed on November 14, 2026.
| Edition | 1-year subscription | Perpetual | License covers |
|---|
| Desktop for Windows (default on the order page) | $179.95 | $349.95 | One computer, one user at a time |
| Server Standard for Windows | $999.95 | $1,999.95 | One server with up to 6 cores, many users |
| Server Enterprise, Site, OEM | Quoted | Quoted | Larger servers, device ranges, redistribution |
A subscription runs only for its term and needs internet access to activate and verify; a perpetual license activates offline and keeps the purchased version. 2- and 3-year terms and premium support can be added on the order page.
FAQs
Is this the same as the old ExactTarget ODBC driver?
Yes. Devart ODBC Driver for Salesforce Marketing Cloud is the continuation of Devart's ExactTarget driver; its product page and files still use the "exacttarget" name, and the version history runs unbroken from 2016.
Can the Marketing Cloud ODBC driver connect to a sandbox?
Yes. Devart ODBC Driver for Salesforce Marketing Cloud has a Sandbox option in App Center Client authentication, so you can point a DSN at a sandbox account for testing before touching production data.
Does the driver work with Salesforce CRM data too?
No. Devart ODBC Driver for Salesforce Marketing Cloud only connects to Marketing Cloud. Salesforce's CRM (Sales Cloud and Service Cloud) needs Devart's separate ODBC Driver for Salesforce.
Can I use the driver on a reporting server for the whole team?
Not with a Desktop license, which allows one user at a time. Devart ODBC Driver for Salesforce Marketing Cloud on a shared server needs Server Standard ($999.95 a year, up to 6 cores) or Server Enterprise.
Will Devart refund me if the driver doesn't suit my reporting?
Probably not. Devart ODBC Driver for Salesforce Marketing Cloud is refunded within 30 days only when a technical issue stops it working and support can't fix it. Use the free trial to confirm it reaches your Data Extensions first.
Can I deploy the driver to many PCs at once?
Yes. Devart ODBC Driver for Salesforce Marketing Cloud ships as an MSI as well as an EXE, and Devart added the MSI specifically for deployment through Group Policy.
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 Salesforce Marketing Cloud API user or installed package, and HTTPS access (directly or via proxy)
Conclusion
Devart ODBC Driver for Salesforce Marketing Cloud is worth its $179.95 a year for Windows teams that keep exporting campaign and Data Extension data by hand: Data Extensions as tables, Server-to-Server sign-in and business-unit filtering are the features that make it practical in a real enterprise account. The reason to pass is setup friction; if your admin won't create an installed package, or the platform's own Query Activities are enough, you don't need it. Test it in the 30-day trial against your own account before buying.
Download Free Trial Buy Now