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.
Note: This feature is available in the Toad Data Point Professional Edition only.
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. 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.
- 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.