Mongo Aggregation

MongoDB Aggregation component allows users to group and transforms data from one or more MongoDB collections. The aggregation query pipeline consists of a series of stages that can be used to filter, group, project, sort, and transform data from MongoDB collections.

All component configurations are classified broadly into the following sections:

• ​Basic Information​​

• Meta Information

• Resource Configuration​​

• ​Connection Validation​

Please follow the given demonstration to configure the Mongo Aggregation component in a pipeline workflow.

Configuring the Mongo Aggregation Component in a Pipeline Workflow

Configuring Meta Information of Mongo Aggregation Component

• Connection Type: Select the connection type from the drop-down:

  • Standard

  • SRV

  • Connection String

• Host IP Address (*): Hadoop IP address of the host.

• Port(*): Port number (It appears only with the Standard Connection Type).

• Username(*): Provide username.

• Password(*): Provide a valid password to access the MongoDB.

• Database Name(*): Provide the name of the database from where you wish to read data.

• Collection Name(*): Provide the name of the collection.

• Additional Parameters: Provide the additional parameters to connect with MongoDB. This field is optional.

• Enable SSL: Check this box to enable SSL for this components. MongoDB connection credentials will be different if this option is enabled.

• Certificate Folder: This option will appear when the Enable SSL field is checked-in. The user has to select the certificate folder from drop down which contains the files which has been uploaded to the admin settings for connecting MongoDB with SSL. Please refer the below given images for the reference.

• Script: Write the Mongo Aggregation script in this field.