dotConnect for MailChimp
Version
3.3.248
License
Shareware
Trial Limitations
Fully functional 30-day trial, no credit card. Needs a free Devart account
Operating Systems
Windows, Linux, macOS (x64 and x86). Installer and Visual Studio integration on Windows, NuGet package on all platforms
System Requirements
.NET 5 to 11, .NET Core 2.0 to 3.1, .NET Standard 2.0/2.1 or .NET Framework 4.5 to 4.8. Visual Studio 2015 to 2026 for design-time tools. Mailchimp account
File Size
17.26 MB
Release Date
11/11/2026
Last Updated
11/14/2026
504 views 0 downloads
ADO.NET provider for Mailchimp audiences, campaigns and e-commerce data via SQL

dotConnect for MailChimp: Mailchimp Audiences and Campaign Results Through ADO.NET

dotConnect for MailChimp is a $339.95 ADO.NET data provider from Devart that lets .NET applications read and update a Mailchimp account with SQL: audience members with their merge fields and tags, campaigns and who opened them, and Mailchimp's e-commerce data (stores, products, orders, carts, promo codes). It's for developers who sync subscribers with a CRM or website database, or report on email results inside their own software, on .NET 5 to 11 or .NET Framework 4.5 to 4.8. The license is perpetual with a year of updates.

Think of the sign-up form on your site writing straight into a Mailchimp audience with an INSERT, or a nightly job copying last month's campaign opens into SQL Server for the sales team.

Quick facts

  • Version: 3.3.248, released November 11, 2026
  • Developer: Devart
  • Data source: Mailchimp Marketing API v3 (the default since version 1.9 in 2020), with v2 still selectable
  • Authentication: Mailchimp API key, or OAuth 2.0 (Client Id and Client Secret) with Web Login in Visual Studio and interactive login at runtime
  • .NET: .NET 5 to 11, .NET Core 2.0 to 3.1, .NET Standard 2.0/2.1, .NET Framework 4.5 to 4.8
  • ORMs: EF Core 1 to 11, Entity Framework 4 to 6, Dapper, NHibernate
  • Download: 17.26 MB Windows installer, or the Devart.Data.MailChimp NuGet package
  • Price: Developer $339.95, Server $799.95, OEM for 10-100 devices $4,999.95 (perpetual, one year of updates)
  • Trial: 30 days, unrestricted
  • Refunds: within 30 days only for technical issues support can't fix
  • What we checked: version 3.3.248 and the 17.26 MB download on Devart's site, the connection-string options, the revision history back to the first release in February 2016, Devart forum threads about Mailchimp performance and merge fields, and the order page on November 14, 2026: $339.95 for one Developer license. We didn't connect it to a Mailchimp account.

Download Free TrialBuy Now

Overview

Mailchimp's data is shaped around audiences (which the API still calls lists), members, merge fields and campaigns. The awkward part for SQL users is that every audience can have its own merge fields: one account's members have First Name, City and Zip Code, another's have only email and status. dotConnect for MailChimp turns that into columns on a ListMembers table, with connection options deciding which merge fields become columns.

The provider is one of Devart's longest-running cloud connectors, first released in February 2016. Its biggest recent change came in May 2026, when Devart added ten e-commerce objects (Stores, Products, ProductVariants, Customers, Orders, OrderLines, Carts, CartLines, PromoRules and PromoCodes), so the store data that powers Mailchimp's product recommendations and abandoned-cart emails is now reachable too.

dotConnect for MailChimp Add Connection dialog with Access Token field and Web Login button

The MailChimp data source in Visual Studio's Add Connection dialog: one token field, a Web Login button that signs in through the browser, and an API key connection string being built in code behind it.

Features

Audience members with their merge fields

dotConnect for MailChimp's ListMembers table returns each subscriber's email, status, language, VIP flag, member rating, sign-up and opt-in details, location, open and click rates, interests and tags, plus the audience's merge fields as columns. The Merge Fields Detection Behavior option decides how merge fields are joined to the member rows (None, JoinCommon by default, or JoinAll), and Use Merge Tag As Field Name names the columns by merge tag (FNAME, LNAME) instead of the display label.

Campaigns and their results

dotConnect for MailChimp exposes Campaigns, with optional ContentHtml and ContentText fields, plus campaign activity such as SentTo (who each campaign went to, with open counts and last open time) and Opened. That's enough to build an engagement report by customer, or to flag contacts who haven't opened anything in six months.

Mailchimp e-commerce objects

dotConnect for MailChimp added Stores, Products, ProductVariants, Customers, Orders, OrderLines, Carts, CartLines, PromoRules and PromoCodes in version 3.2.100 (May 2026). A shop that isn't on one of Mailchimp's ready-made platform integrations can use them to push its own orders and carts into Mailchimp, which then drive purchase-based segments and cart reminders.

API key or OAuth, with a token store

dotConnect for MailChimp works with a plain API key, which suits internal tools, or with OAuth 2.0 for apps that connect to other people's accounts. The Web Login button opens the system browser for sign-in, and a Token Server option keeps OAuth refresh tokens in a file or registry key between sessions.

ORMs, bulk loading and Visual Studio

dotConnect for MailChimp supports EF Core 1 to 11 (with Devart's Entity Developer as an optional visual designer), Entity Framework 4 to 6, Dapper and NHibernate. A MailChimpLoader component speeds up bulk inserts such as subscriber imports, results can be paged, and Visual Studio 2015 to 2026 gets a Server Explorer data source with the API version on the main connection screen.

Entity Developer Create Model Wizard using Devart dotConnect for Mailchimp with API Version v3

Entity Developer's Create Model Wizard with Devart dotConnect for Mailchimp as the provider, API Version v3, and the Connection Editor describing the API Key. The diagram behind it is a sample model.

Benefits

  • Subscriber data where your other data lives. Join Mailchimp engagement with CRM or order data in your own database.
  • No hand-written handling of per-audience fields. Merge fields arrive as columns.
  • A direct path for custom shops. The e-commerce objects let a custom-built store feed Mailchimp's purchase-based marketing.

Real-World Uses

  • CRM sync: a scheduled job compares ListMembers with CRM contacts, unsubscribes people marked "do not contact" and adds new leads with their merge fields.
  • Engagement reporting: a radio station or nonprofit copies SentTo and campaign data into SQL Server weekly and builds Power BI reports on it.
  • Custom store integration: an ASP.NET shop inserts Orders and Carts so Mailchimp can send abandoned-cart reminders.
  • Promo code distribution: a loyalty app reads PromoCodes to show members the discount codes that a campaign is promoting.

Who It's For, and Who Should Skip It

It suits .NET developers who need Mailchimp data inside their own applications or databases, especially when subscriber records must stay in step with another system.

Skip it for one-off exports (Mailchimp's own CSV export is free), for spreadsheet work (Devart's Excel Add-in for Mailchimp is the better tool), and for ETL in SQL Server Integration Services, where Devart's SSIS components for Mailchimp are the purpose-built option. If your store runs on Shopify, WooCommerce or another platform with a native Mailchimp integration, use that rather than writing orders yourself.

Usage Guide

  1. Create an API key in your Mailchimp account settings (or register an OAuth app if your software will connect to customers' accounts).
  2. Install the provider from the Windows installer (free Devart account) to get Visual Studio integration, or add the Devart.Data.MailChimp package from NuGet.
  3. In Server Explorer, add a MailChimp connection and either paste the API key or click Web Login. Leave API Version at v3.
  4. Under Advanced, set Merge Fields Detection Behavior and Use Merge Tag As Field Name to get the member columns you want.
  5. Query with MailChimpCommand or scaffold an EF Core model, select only the columns you need, and add the license key before deploying.

Before you buy

  • Buy Now puts one Developer license with a year of updates in the cart. Pick Server ($799.95) on the order page if the sync will run on a server, or OEM if you'll ship it to clients. Update terms of 2 or 3 years and premium support are chosen there too.
  • The license is perpetual: the version you buy keeps working after the update year.
  • Devart's ordering FAQ refunds within 30 days only when a technical problem can't be fixed by support, so check performance on your own audience size during the trial.

Where it falls short

  • Some tables are slow by nature. Devart explains that SentTo is read by first loading every campaign and then making a separate request per campaign, and that selecting ContentHtml or ContentText on Campaigns costs one extra request per row. Leave those columns out unless you need them.
  • Mailchimp throttles heavy use. A user hit "(503) Server Unavailable", which Devart attributed to Mailchimp's Akamai protection blocking an IP that sent too many requests. Don't run several big jobs against one account at once.
  • Very large pulls can time out. Reading over 6 million SentTo rows without a filter ended with Mailchimp closing the connection. Raise Default Command Timeout and filter early.
  • Merge fields differ per audience. Two accounts can show different ListMembers columns, which surprises people writing one report for both.

What Users Say

The provider has no rated reviews on the big software directories. The real-world experience comes from Devart's forum, including threads from users of Devart's Mailchimp SSIS components, which run on the same Devart.Data.MailChimp engine (it appears in their error traces).

Devart forum, May to September 2019: "Extremely Slow"

A user (malchim) wrote: "I am wondering why our downloads from Mailchimp are so slow. It is pulling roughly 2000 records a minute," along with a 503 error. Devart's engineer (Pinturiccio) explained how SentTo is read per campaign, and that "the Campaigns records can be read slowly as well, especially if you select ContentHtml or ContentText fields." On the 503: "This error occurs on the MailChimp side when numerous requests are sent to their server. In this case Akamai is blocking access to MailChimp from a particular IP."

The same user later found that two accounts showed different ListMembers columns. Devart's admin (Shalex) pointed to the Merge Fields Detection Behavior setting and noted that missing custom fields can be created in Mailchimp's web interface.

Devart forum, December 2017 (ODBC driver for Mailchimp)

A user of Devart's Mailchimp ODBC driver (championc) wrote that "extracting info from the ListMembers table only extracts the original MailChimp created fields only," while his user-defined fields were missing. Devart replied four months later with a new version and an option to retrieve custom fields. It's the same need that the provider's merge-field options address.

The pattern: Devart answers in detail and its explanations are technically sound, but replies weren't always quick, and the pain points are Mailchimp's own API limits (per-campaign requests, rate limiting, per-audience fields), which no connector can fully hide.

Comparisons

vs. Mailchimp's own .NET client libraries and REST API

Calling the Marketing API directly, or through a free client library, costs nothing and covers every endpoint, including new ones on day one. The provider's case is SQL and EF Core: joins with your own data, merge fields as columns, and the same data-access style as the rest of your app. For a sign-up form, call the API. For a two-way sync or reporting, the provider saves time.

vs. dotConnect for Salesforce Marketing Cloud

Devart sells the same kind of provider for Salesforce Marketing Cloud, the enterprise email platform. The choice follows your email platform, not the provider: same price, same editions.

Editions and Pricing

EditionPriceLicense covers
Developer (what Buy Now orders by default)$339.95A single developer's workstations
Server$799.95One server inside one organization
OEM for 10-100 devices$4,999.95Distribution inside your own application
Site, OEM 100+ devicesShown on the order pageCompany-wide use or wider distribution

FAQs

Can dotConnect for MailChimp add or unsubscribe members?

dotConnect for MailChimp supports INSERT, UPDATE and DELETE statements wherever Mailchimp's API allows the change, so member changes are written as SQL rather than API calls. Mailchimp's own rules (for example on resubscribing people who unsubscribed) still apply, so test the exact member operations you need during the trial.

Why do my merge fields not show up as columns in dotConnect for MailChimp?

dotConnect for MailChimp controls this with the Merge Fields Detection Behavior option (None, JoinCommon or JoinAll) on the connection's Advanced settings. Compare it across connections first, and remember that a merge field that doesn't exist in an audience has to be created in Mailchimp itself.

Does dotConnect for MailChimp need an API key or OAuth?

Either. dotConnect for MailChimp accepts an API key for your own account, or OAuth 2.0 with your app's Client Id and Client Secret, which is the right choice when your software connects to other businesses' Mailchimp accounts.

Will dotConnect for MailChimp hit Mailchimp's rate limits?

It can. dotConnect for MailChimp turns queries into Mailchimp API requests, and some tables need one request per campaign or per row. Select only the columns you need, filter early and avoid running many jobs in parallel.

Does dotConnect for MailChimp run on Linux or in Docker?

Yes. dotConnect for MailChimp's NuGet package runs on .NET 5 to 11 and .NET Core on Linux and macOS as well as Windows. Only the installer and Visual Studio designers are Windows-specific.

System Requirements

  • .NET 5 to 11, .NET Core 2.0 to 3.1, .NET Standard 2.0/2.1, or .NET Framework 4.5 to 4.8
  • Windows, Linux or macOS. Visual Studio 2015 to 2026 design-time integration on Windows
  • A Mailchimp account with an API key or an OAuth app

Conclusion

dotConnect for MailChimp is worth $339.95 to a .NET developer who keeps Mailchimp audiences in sync with a CRM or website database, or who needs campaign results inside in-house reports. Its best feature is the handling of merge fields as columns, which is the messiest part of Mailchimp's data, and the new e-commerce objects make it useful for custom shops too. The main reason not to buy is that Mailchimp's API limits still apply: big SentTo or campaign-content pulls are slow, and heavy parallel jobs get throttled. For a simple sign-up form, the free API is enough. Use the 30-day trial on your largest audience before you decide.

Download Free TrialBuy Now

We may earn a commission when you buy through links on this page.
Copyright © 2026, Ivertech. All rights reserved.