Create MongoDB Connections
Toad allows you to connect to a MongoDB database, a NoSQL data source, to view and query tables.
After creating a connection, see About MongoDB Data Sources for more information.
To create a MongoDB connection
- Click
on the Connections toolbar (ALT+F+N).
- Select MongoDB from the Group list.
-
Enter the connection information in the Create New Connection dialog. Review the following for additional information:
| Host |
Enter the host server name or IP address.
If SSL is used, enter host server name only. |
| Port |
The default port is 27017. If different, enter the port number. |
| Database |
Enter the database to use in this connection. |
| Authentication |
Select one of the following*:
- Username / Password
- X.509
- LDAP
- Kerberos
- None
|
| *Username / Password |
Enter the username and password to use when connecting. |
| *X.509 |
Enter the username to use when connecting. Select your Certificate Authority file and your PEM key file. If your PEM key file is password protected, enter the password. |
| *LDAP |
Enter the username and password to use when connecting.
Optionally, click SSL and select one of the following:
- None - SSL is not used
- Server Validation - The server is validated using certificate authority file
- Server and Client Validation - The server is validated using certificate authority file and the client certification is validated by the server
- Unvalidated - The server is not validated
|
| *Kerberos |
Enter principal and password to connect. |
| SSL |
Optionally, click SSL and select one of the following:
- None - SSL is not used
- Server Validation - The server is validated using certificate authority file
- Server and Client Validation - The server is validated using certificate authority file and the client certification is validated by the server
- Unvalidated - The server is not validated
If SSL is used, enter host server name instead of IP address. |
| Category |
(Optional) Select an existing category or create a new one. See Set Connection Categories for more information. |
|
Note: In NoSQL and Business Intelligence connections, Toad automatically saves the password in the connections.xml file as obfuscated text, as well as in Toad. To add additional password security, use Toad's Master Password feature. See Security Options for more information. |
- Click Connect to connect immediately while saving the connection information. Optionally, click Save to save the connection without connecting.
- Upon creating an initial connection, Toad automatically maps the data source objects. This process runs in the background, and until it is finished, you may experience a delay when attempting to access these objects.
Tips:
- Connections are stored in the connections.xml file and can be found by clicking the Application Data Directory link in Help | About.
- You can specify a proxy server to use for Business Intelligence and NoSQL connections at Tools | Options | Database | Data Services.
Related Topics
About Business Intelligence and NoSQL Data Sources