This is a Guest Post from our Friends at Tableau

MemSQL is the database platform for real-time analytics. One of the great features of the latest release, MemSQL 5, is users can connect directly from Tableau. Using the new MemSQL 5 named connector, currently in beta, users can analyze current and historical data together while MemSQL ingests millions of transactions per second. MemSQL is also wire-protocol compliant with MySQL, so if you already have a MySQL driver installed or you are running Tableau 9.3 or later, you can connect to MemSQL.

How can you use MemSQL and Tableau? Say you work for a connected device company that helps millions of people monitor their physical activity and heart rate. Millions of devices send physical activity and heart rate data throughout the day. You just released an app that gamifies exercise and you want to see how effective it is right now. So you open Tableau and select the new named connector called “MemSQL”.

Connect Tableau to MemSQL

Input the server name of your MemSQL aggregator node, port (default is 3306 as in MySQL), and user credentials.

Tableau Server Name

On the data tab, you see all your databases and tables, which include data from the MemSQL in-memory rowstore and memory and disk-based columnstore. Select the tables you want to analyze and instantly start visualizing your operational data.

MemSQL 5 Tableau Connection

Using MemSQL 5? Sign up for the beta Tableau connector here: http://www.tableau.com/tableau-10-beta-program

The new connector is part of Tableau’s upcoming 10.0 release. To learn more about 10.0, visit http://tableau.com/coming-soon

For questions related to MemSQL integration with Tableau, please contact MemSQL at [email protected]