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
Connect MongoDB Atlas with DBHawk
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
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
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
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
Now run SQL queries to create charts.
Write a SQL Query to get total population by USA state
Create Bar Chart with MongoDB Data
Write a SQL Query to get top 5 most populated states
Create PIE chart with MongoDB Data
Create a dashboard with above charts
MongoDB Dashboard with MongoDB Database