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
Add DBHawk IP address under IP whitelist
Add Users and assign appropriate roles.
Get Primary, and secondary server details
Now login with DBHawk and setup new Data Source
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.
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.
After successful import, refresh schema and select zip2 collection. You can query using JSON Query window or write a SQL query to query data.
Now run SQL Query to create charts.
Write a SQL Query to get total population by USA state
Write a SQL Query to get top 5 most populated states
Create a dashboard with above charts