Tableau & MongoDB: Visual Analytics on JSON at the Speed of Thought

By Jeff Feng June 2, 2015

Tableau + MongoDB

We are thrilled to share that Tableau is partnering with MongoDB to make it easy for people to visually analyze rich JSON-like data structures directly in MongoDB. This is a story about the leader in rapid-fire visual analytics teaming together with the leader in modern databases for rapid application development to better serve users' needs. The partnership and integration has been driven by your desire to visualize MongoDB data with Tableau as exemplified by your requests on Tableau’s Ideas Forum.

Tableau aims to help democratize data access by helping people see and understand data. It is widely known that 80 percent of the world’s data is unstructured or semi-structured data, much of which is stored in JSON format because of its simple syntax and conciseness. This growth of unstructured data will only accelerate over time because of the popularity of web applications, mobile devices, IoT and social media—all of which heavily leverage JSON data.

Today, people generally move their MongoDB data into a relational database or Hadoop to transform it into a format that Tableau can interpret for analysis. Thus, fast and easy access for visualizing JSON data is a massive opportunity for empowering data-driven users and organizations.

MongoDB is a document database used for flexible web, mobile, and IoT application development. MongoDB enables organizations to build modern applications using dynamic schemas resulting in faster design iterations and greater agility. Not only is it the world’s most popular NoSQL database with more than 10 million downloads, it is also the fifth most popular database overall ahead of DB2, according to DB-Engines.

For the first time ever, people using Tableau can access JSON data stored in MongoDB via a new connector developed by the team at MongoDB. The connector first creates an initial relational view definition of the JSON data. Then, it either converts a SQL statement to a MongoDB Aggregation Pipeline query or a straight find operation based on the query.

MongoDB will soon announce beta availability of the connector, with general availability planned around the MongoDB 3.2 release late this year. During MongoDB’s beta, Tableau will be supporting the MongoDB connector on both Windows and Mac via our PostgreSQL driver.

Earlier today, Tableau’s very own Thierry D’hers, our VP of Program Management, joined MongoDB’s co-founder and CTO Eliot Horowitz on the big stage at MongoDB World 2015 in New York City (pictured below) to share our excitement in true Tableau fashion-with a live demo of Tableau + MongoDB. In the demo, we used FAA data to predict which attendees at the conference would have the most difficulty flying home. To see a sneak preview of Tableau + MongoDB in action, we’ve shared a recording of the demo below.

FAA & MongoDB World Attendees Document
Schema of world_attendees and june_flights collections in demo.

Thierry D'hers presenting Tableau demo on JSON FAA data in MongoDB
Thierry D'hers presenting Tableau+MongoDB demo on the big stage at MongoDB World 2015.

Read: To read more about MongoDB’s BI and visualization connector and its impact on users, please read MongoDB’s press release.

Respond: Do you have an interesting big data use case? We’d love to hear about it. Please reach out and let me know.

Comments

Submitted by Matthieu de Groot (not verified) on

Great news!

Submitted by Hans-Peter Huber (not verified) on

Very good news! Waiting for the next step! :)

Submitted by Vincent L. (not verified) on

Does anybody know when this will be released?

It would be a game changer for me :)

Submitted by Wes Gurney (not verified) on

Any update on this? Being able to visualize data in our MongoDB collections would def. by game changer.

Submitted by Elena (not verified) on

Sorry, but I can't understand how I can to connect to MongoDB? Where should I get beta connector?

Submitted by James Malvi (not verified) on

I would like to share a tool which helps to format json http://jsonformatter.org

Submitted by Jeff F. on

The MongoDB BI Connector will be coming out in their 3.2 release in December.
-Jeff

Submitted by Andy Miller (not verified) on

Has there been an actual release data set?

Submitted by Mykola Striletskyy (not verified) on

You can try to use our solution which helps visualize data from MongoDB - http://www.getdataforce.com/

Submitted by Mary S. on

Has MonoDB support been released yet? If not, any ETA?

Submitted by revathi (not verified) on

is there any existing driver to connect mongo with tableau?

Submitted by Yohan Albo (not verified) on

I think MongoDB has released the connector as part of the "MongoDB connector for BI" component. See: https://www.mongodb.com/products/bi-connector

Has Someone already tested it with Tableau? I have a NoSQL project that needs to start soon...

Yohan Albo - www.datatocapital.com

Submitted by Sara Khan (not verified) on

The for the post...

comcast spped test
comcast spped test

Submitted by Danidiara (not verified) on

The healing property of the herb soothes inflammation speedily. An infusion of the seeds mixed with common salt can be used helpfully as a gargle in an acute condition caused by a cold.You can use the same strong theory - focus. As a result, the next objective is even easier to achieve because of that increased confidence. Speedy Short-Term Massive Action. Exercising your penis pro 10 minutes a day of the week adds up to a tiny further than an hour apiece week. Wholesale Jerseys China.Wholesale NFL Jerseys China. Use that energy, that confidence you gained and go make another sale. Imagine if you used the momentum you shaped while you were in 1st gear and moved into 2nd gear and then third, fourth and 5th.Follow these simple rules,Wholesale Jerseys Cheap, plus rember to keep it casual plus confident plus you're all set for a fun filled night of fireworks, sit bk and observe the sparks fly!.the list of places where you can show off your favorite hockey jersey is endless.Visit my site:http://www.wholesalenfljerseyschinasupply.us.com/

Submitted by Davide Boiardi (not verified) on

We would be very grateful for any reliable and well explained information for connecting Tableau to MongoDB.

Submitted by tonitp (not verified) on

Hello ! Open source bla bla bla, free software bla bla bla .. if you want Mongo Connector BI you must PAY for it !! https://www.mongodb.com/download-center?jmp=hero#bi-connector

Submitted by Saurabh Bobde (not verified) on

Is there any information with regards to the performance of using Tableau with MongoDB? That is, would there be a point at which, you may want to instead use it on a separate instance of Mongo, rather than your "live" instance? (Yes, this kind of may defeat some of the scaling leverage that Mongo offers in the first place, but this could be warranted by some practical scenarios).

Thoughts/views appreciated.
Thanks.

Submitted by Gaurav P. on

We at stackArmor have been working with multiple customers to help them evaluate and tune their BI and Data Visualization solution for NoSQL workloads. Amazon Web Services (AWS) offers great choices for both Tableau Server and MongoDB with pre-built templates and a wide variety of instance types for performance and cost optimization. You can easily create a lab and install both Tableau and MongoDB to run through performance scenarios. You can check StackBuilder from stackArmor to get started quickly with pre-built templates for both Tableau Server and MongoDB.

Submitted by Taras (not verified) on

There is a simple solution for visualization data from NoSQL. It connects to MongoDB and gives you a real-time result in a visual dashboard reporting interface. Called Databasel .

Submitted by antoine (not verified) on

Databasel? where do we find more info about this stuff?

Add new comment

non-humans click here