Chat now with support
Chat con el soporte

Toad Data Point 5.0 - User Guide

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

  1. Click on the Connections toolbar (ALT+F+N).
  2. Select MongoDB from the Group list.
  3. 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.

  4. Click Connect to connect immediately while saving the connection information. Optionally, click Save to save the connection without connecting.
  5. 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

Documentos relacionados