Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

How to Configure the DataDirect ODBC MongoDB Driver With Tableau Desktop

DZone's Guide to

How to Configure the DataDirect ODBC MongoDB Driver With Tableau Desktop

Learn how to use a MongoDB connection from within the Tableau Desktop application to configure the DataDirect ODBC MongoDB Driver.

· Database Zone ·
Free Resource

MariaDB TX, proven in production and driven by the community, is a complete database solution for any and every enterprise — a modern database for modern applications.

The DataDirect ODBC drivers can connect any ODBC application to a wide range of data sources. This tutorial demonstrates how to use a MongoDB connection from within the Tableau Desktop application. These same steps can be used for any ODBC connection from within Tableau. 

Prerequisites

This tutorial assumes that you have ODBC drivers installed and a data source configured. If you have not yet done those steps, please follow these instructions:

  1. Download and install the ODBC driver for your database using the 15-day trial software. In this tutorial, we are connecting to MongoDB.

  2. Configure a data source to your database. See the DataDirect documentation for assistance on setting up your data source. The sample below uses a MongoDB data source

Connect to an ODBC Data Source

  1. Start Tableau and select Other Databases (ODBC).
  2. Tableau1

  3. In the popup window, select the DSN radial button and in the drop-down, choose the data source previously configured to connect to MongoDB.
  4. Tableau2

  5. Select Connect and a new popup screen will appear.
  6. Tableau3

  7. Enter any additional parameters required to connect to your MongoDB source, such as a user name and password, and select OK. The original connection screen will now display the connection attributes.
  8. Tableau4

  9. Select Sign In and the Tableau configuration screen should now appear. You can use Tableau's schema and table drop-down list to browse and select your data. Or, you can execute SQL statements by clicking on the New Custom SQL option.
  10. For example, you can execute a statement such as Select * from schema_name.table_name and then click on the Sheet 1 option at the bottom of the Tableau screen. This screen will allow you to select data and create tables or charts, such as the sample below:
  11. Tableau5sample_chart

And that's it!

MariaDB AX is an open source database for modern analytics: distributed, columnar and easy to use.

Topics:
mongodb ,database ,datadirect ,odbc driver ,tableau ,tutorial

Published at DZone with permission of

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}