Mailchimp ODBC & JDBC Driver

Easily access real-time Mailchimp campaign and audience information through your business intelligence tool of choice with direct access to your Mailchimp data.

Current Versions Gateway (ODBC & JDBC) 1.0.0

OEM & Distribution
  • DB Visualizer
  • Excel
  • Looker
  • Marketing & Social Media
  • Microstrategy
  • Other JDBC
  • Other ODBC
  • PowerBI
  • SAP
  • Sisense
  • Tableau

Go from Chimp to Champ by elevating your Mailchimp campaign data to the next level of customer intelligence. How, you ask? With easy access to your Mailchimp data in Power BI or any other BI/Analytics tool you rely on for comprehensive campaign analysis.

With our Magnitude Simba Mailchimp Connector on Simba Gateway, you’re only steps away from Direct BI connectivity to Mailchimp data – comprehensivecampaign information, reports, pings, landing pages, audience lists and more - without extraction.

The Simba Mailchimp Connector enables streamlined analytics and reporting on Mailchimp data. Complying with both the ODBC 3.80 and JDBC 4.2 data standards, the connector simplifies the process of connecting to data sources by enabling you to use the same connection across both types of applications. On Windows and macOS, the connector is supported by two additional applications:

  • The Simba Gateway Settings application provides an intuitive user interface designed to simplify the process of configuring connectors and defining connections.
  • The Connection Assistant application further simplifies the connection process by conveniently providing ODBC connection strings and JDBC connection URLs for all connections that were configured through Simba Gateway Settings.

The connector returns Mailchimp data through specially generated schema tables, which map the data to a traditional relational format that is compatible with ODBC and JDBC applications. For a complete reference guide to the database schema tables used by the connector, see the Simba Mailchimp Connector Reference Guide.

Features and Specifications

  • Supports 32- and 64-bit applications
  • Supports OAuth2 authentication
  • Supports TLS 1.1/1.2
  • Uses OpenSSL 1.1.1.
  • Supports Unicode
  • Supports multiple platforms, including Windows, Linux and Mac OS X
  • Supports ANSI SQL-92
  • Support for ODBC 3.8
  • Support for JDBC 4.2


User Guides, Release Notes, and FAQs.

Ready to buy? We're here to help!

If you are evaluating our drivers or our Simba SDK, our Sales Engineers would be happy to assist you.