Chapter 17. Connecting to MongoDB

Procedure

1. In Fuse Online, in the left panel, click Connections to display any available connections.
2. In the upper right, click Create Connection to display connectors.
3. Click the MongoDB connector.

4. Configure the connection:

   1. In the Database host(s) field, specify one or more MongoDB database hosts that this connection can access. Separate multiple specifications of host:port with commas. Replace host with a host name, a virtual host name, or an IP address. For example: mongodb0.example.com:1234,mongodb1.example.com:1234.
   2. In the Username field, enter a user name that is authorized to access the database.
   3. In the Password field, enter the password for the user name that you specified.
   4. Optional. In the Administration database field, if the database has an administration database, enter the name of the MongoDB administration database that is used to grant access permission. A MongoDB administrator should let you know whether the database that you want to access has an administration database.
   5. Optional. In the Replica set name field, specify the name of the MongoDB replica set (cluster) that the connection can access.
   6. In the Database field, enter the name of the MongoDB database that contains the collection(s) that you want the connection to read.
5. Click Validate. Fuse Online immediately tries to validate the connection and displays a message that indicates whether validation is successful. If validation fails, revise the input parameter(s) and try again.
6. When validation is successful, click Next.
7. In the Name field, enter your choice of a name that helps you distinguish this connection from any other connections. For example, you might enter MongoDB North.
8. In the Description field, optionally enter any information that is helpful to know about this connection.
9. Click Save to see that the connection you created is now available. If you entered the example name, you would see that MongoDB North appears as a connection that you can choose to add to an integration.

Procedure

1. In the Fuse Online panel on the left, click Integrations.
2. Click Create Integration.
3. On the Choose a connection page, click the MongoDB connection that is configured to access the database that you want the integration to obtain updates from.
4. On the Choose an action page, select the Mongo consumer action.

5. Configure the action:

   1. In the Collection name field, enter the name of the MongoDB collection that you want the connection to read.
   2. In the Collection field used to track incoming documents field, enter the name of the relevant MongoDB collection field. This field contains data that can be sorted, such as a date or an ID.
   3. Select the Persistent tracking enabled checkbox if persistent tracking is enabled for the database that you want the connection to read.
   4. In the Field used to store the tracking progress field, optionally specify the name of a field that is in the specified collection. A MongoDB administrator must have configured this field.
   5. In the DB used to store tail tracking field, optionally enter the name of the MongoDB database that contains tail tracking information.
   6. In the Collection used to store tail tracking field, optionally enter the name of the collection that contains tail tracking information.
   7. In the Field used to store tail tracking field, optionally, enter the name of the field that stores tail tracking information for the collection that this connection is reading.
   Note

   To identify the tail tracking field, you can specify the tail tracking database or tail tracking collection. With one of these pieces of information, the connection can find the tail tracking field.

6. Click Next.

Procedure

1. On the Add to Integration page, click the plus sign where you want to add a MongoDB connection. Skip this step if you are adding a simple integration’s finish connection.
2. Click the MongoDB connection that you want to use.
3. On the Choose an action page, select the MongoDB producer action.

4. Configure the action:

   1. In the Collection name field, enter the name of the collection that you want the connection to operate on.

   2. In the Operation to perform field, accept the Insert operation or click in the field to display the available actions. Click the action that you want the connection to perform. See the table below for a description of each operation.

      Each operation returns a response. If this is a finish connection, then the response is lost. Consequently, if this is a finish connection, the recommendation is to add a Log step to finish the integration instead. Configure the Log step to capture the response.

5. Click Next.