DEV Community

Cover image for Build INTERACTIVE Analytics Dashboards | METABASE. Part2: Connecting to Database
Ramy Gamal
Ramy Gamal

Posted on

Build INTERACTIVE Analytics Dashboards | METABASE. Part2: Connecting to Database

After submitting your profile information you will need to provide database connection so metabase can process your data.

Metabase supports wide range of databases including:

In this tutorial we will use MongoDB sample database as our data source.

Connecting to MongoDB

We will need to get database connection string. So in your ATLAS dashboard press on Connect, then get the connection string.

Getting Mongo Connection String

You will have a connection string similar to this one

mongodb+srv://DB_USER:*******@cluster0.4i388.mongodb.net/sample_analytics?retryWrites=true&w=majority
Enter fullscreen mode Exit fullscreen mode

So copy it and replace the placeholders and then provide the connection string to metabase.
Submitting connection string to metabase

Important Note

Make sure to whitelist all the IPs in your ATLAS configuration so metabase can access it.
image

Now the database is added as a data source in metabase and automatically metabase started generating some charts for you.
image

It was pretty easy right? In the next post we will discuss how to create custom charts in metabase.

Discussion (0)