Configuring MongoDB Connector Sources

You can add MongoDB to Cloud Application Business Insights by using MongoDB Connector. MongoDB Connector is a built-in connector.

Before you begin

Ensure that the database that you want to connect is up and running.

Procedure

Complete the following steps to add MongoDB Databases by using MongoDB Connector:

  1. Open Dashboard Designer.
  2. In the navigation pane, go to Connector & Sources > Connector Sources.
  3. On the All Connector Sources page, click Add Source.

    An Add Connector Source window is displayed.

  4. From the Connector Type list, select MongoDB connector.
  5. In the Connector Source Name field, enter a name for the source.

    Source name can contain alphanumeric characters and underscores.

  6. In the Mongo URI field, enter URI details for MongoDB that you want to add.

    For example, mongodb://server_IP_or_HOSTNAME:port

    Where:
    • server_IP_or_HOSTNAME is the IP address or hostname of the server where MongoDB is installed.
    • port is the default port for MongoDB.

      The default port is 27017.

  7. In the Mongo Database Name field, enter the name of the MongoDB Database.
  8. In the Mongo Collection Name field, enter the collection name of the MongoDB Database.
  9. From the Authentication Type list, select any of the following options:
    • If username and password are not configured during MongoDB installation, click None.
    • If username and password are configured during MongoDB installation, select SCRAM-SHA, enter username in the User Name field, and password in the Password field.
  10. Click Next.
  11. In the Query field, enter a sample query in JSON format for the MongoDB Database.

    For example, {"id":"value"}

    For more information about query formats, see https://docs.mongodb.com/manual/tutorial/query-embedded-documents/.

  12. Click Save.
  13. To make sure that the connection to the data source is successful, click Test Connection.
    If the source details and the sample request are valid and complete, then a message, which indicates that the connection is successful is displayed. For connection failure messages, you must fix the errors that are mentioned in the messages and test the connection again.
    Note: Even if the source details are valid, a connection failure message might be displayed due to an invalid response received for the sample request.

Results

The All Connector Sources page displays the following details for each connector source:
  • Connector source name
  • Connector type
  • Date and time when the connector source was first created, and the username of the user who first created the source.
  • Date and time when the connector source was last modified, and the username of the user who last modified the connector source. Only the latest record is displayed.
MongoDB is added and can be used to create custom data definitions.