Step by Step Guide to Connect DBHawk with MongoDB Atlas database Tutorial

MongoDB Atlas is a cloud database service. You can create your free sandbox account to learn/play with MongoDB database.

DBHawk supports MongoDB Atlas.
This tutorial shows how you can create free MongoDB sandbox account and connect with DBHawk. You can create sample collection, import data and browse data with DBHawk. You can write queries against MongoDB database, create charts and dashboards.

First, visit MongoDB Atlas website and sign up for a free account.

After successfully creating sandbox account, log in to your account.

Create a sample MongoDB cluster

Connect MongoDB Atlas with DBHawk

Connect MongoDB Atlas with DBHawk

Add DBHawk IP address under IP whitelist

Connect MongoDB Atlas with DBHawk

Connect MongoDB Atlas with DBHawk

Add Users and assign appropriate roles.

Connect MongoDB Atlas with DBHawk

Connect MongoDB Atlas with DBHawk

Get Primary, and secondary server details
Connect MongoDB Atlas with DBHawk

Now login with DBHawk and setup new Data Source

DBHawk MongoDB Atlas Database Connection Setup

DBHawk MongoDB Atlas Database Connection Setup

Enter all primary and secondary servers under URI section. Make sure to check Is URI checkbox. Also, make sure to enter only URI in <cluster_address>:<port number> and separate each server with a comma.

Enter MongoDB Username and Password details. Click on Test connection to make sure you can successfully connect to the database. Update the connection.

Connect to MongoDB Database

Connect to MongoDB Database

Now choose the created connection from the Connect to Database and connect to MongoDB Atlas database.

Download sample MongoDB files from here

Now import this file with DBHawk.

Import MongoDB Data with DBHawk

Import MongoDB Data with DBHawk

MongoDB Import Collection with DBHawk

MongoDB Import Collection with DBHawk

After successful import, refresh schema and select zip2 collection. You can query using JSON Query window or write a SQL query to query data.

Query MongoDB Data with DBHawk

Query MongoDB Data with DBHawk

Now run SQL Query to create charts.

Write a SQL Query to get total population by USA state

Create Bar Chart with MongoDB Data

Create Bar Chart with MongoDB Data

Write a SQL Query to get top 5 most populated states

Create PIE chart with MongoDB Data

Create PIE chart with MongoDB Data

Create a dashboard with above charts

MongoDB Dashboard with MongoDB Database

MongoDB Dashboard with MongoDB Database

 

top