Mongo Atlas is widely used the hosted Mongo DB service. SQuirreL SQL Client is a graphical Java program that will allow you to view & query data sources using JDBC.
In this blog we demonstrate how to connect SQuirreL to Mongo DB 4.0 cluster with 3 Replica Sets ( 1 primary + 2 secondary) using the Simba MongoDB JDBC driver.
- Add the Name, Example URL & the Website URL the Class Name should populate automatically if the driver is successfully loaded.
- Name the Alias,
Select the MongoDB Atlas driver from the Driver drop down menu.
URL use :
Do ensure all the parameters in the URL connection string including the Replica set names, port are set correctly.
are required too.
Id/passwd can be part of the URL; in which case the User Name/Password fields can be empty.
- Double click on the newly created alias which should connect to the DB. You are now able to run SQL-92 queries on your Mongo DB Atlas. Type your query into the window and then click the run icon.
- Congratulations! You should also be able to view the list of tables & their content.