DBHawk Tutorials

This section contains the features and various tutorials to show how to do various database tasks with DBHawk

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

DBHawk_-Atlas_-MongoDB_Connection-5

Connect MongoDB Atlas with DBHawk


Add DBHawk IP address under IP whitelist

DBHawk_-Atlas_-MongoDB_Connection-3

Add Users and assign appropriate roles.

DBHawk_-Atlas_-MongoDB_Connection-2

Get Primary, and secondary server details

DBHawk_-Atlas_-MongoDB_Connection-6

Now login with DBHawk and setup new Data Source

DBHawk-MongoDB-Atlas-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.

DBHawk-Connection-With-MongoDB-Atlas

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.

MongoDB-Import-Data

Import MongoDB Data with DBHawk

Import-MongoDB-Collections

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.

MongoDB-Browse-Data-1110x608

Query MongoDB Data with DBHawk


Now run SQL queries to create charts.


Write a SQL Query to get total population by USA state

DBHawk-MongoDB-Charts-1110x620

Create Bar Chart with MongoDB Data


Write a SQL Query to get top 5 most populated states

DBHawk-MongoDB-Chart2

Create PIE chart with MongoDB Data


Create a dashboard with above charts

MongoDB-dashboard-1110x529

MongoDB Dashboard with MongoDB Database