Looking for middleware from mongodb to tableau

Question

At the moment I’m trying to get MongoDB to go to tableau via SSIS with Microsoft SQL server 2012 the main problem is that MongoDB, of course, is a document orientated database and Microsoft SQL has issues with this because it’s a relational database type program.

Is there any program that I can use as middleware for tableau to read from, that will convert document-oriented databases into a relational data type that tableau will understand?

Answer 1

• Apache Drill provides an out of the box way to explore data in multiple formats, including Parquet, JSON, Hive. Generally, a big data ODBC connector that discovers schemas on the fly if there isn’t one already available. Now you can get right down to exploring analyzing data without doing a major ingestion project, even if your data has some nested structure. Works on clusters or standalone.

• Here’s a short video intro, and another showing using it with Tableau. http://drill.apache.org/overview/

• 10 minute start example.https://cwiki.apache.org/confluence/display/DRILL/Apache+Drill+in+10+Minutes#ApacheDrillin10Minutes-StartDrill

• Tableau also has a Data Extract API which allows you to create extracts (static snapshots) from any external data source you like. The API is available for Java, C/C++, C#, and Python. See http://www.tableausoftware.com/data-extract-api or search the Tableau knowledge base under support on their site.

Get indepth knowledge about this field through Tableau Certification Course by Intellipaat.