AV | MongoDB

Was this helpful?

MongoDB

The MongoDB connector is used to read JavaScript Object Notation (JSON) documents in a MongoDB database.

Prerequisites

You must have the MongoDB account and credentials.

Connection Details

Specify the following details to define a connection:

Property	Description
Host/URI	Specifies the host name or MongoDB URI of the MongoDB server. This is a mandatory property.
Port	(Optional) Specifies the port number of the MongoDB server. If omitted, the default port number is 27017.
User	(Optional) Specifies the username or identifier that authenticates to the MongoDB server. Omit this keyword if the user security is disabled on the server for the connectivity.
Password	(Optional) Specifies the password of the user that authenticates to the MongoDB server. Omit this keyword if the user security is disabled on the server for the connectivity.
Database	(Optional) Specifies the name of the database on the MongoDB server.

Source Details

Specify the following source details:

Property	Description
Collection	Specifies the name of MongoDB collection in the database to operate on. This is a mandatory property.
Query	(Optional) Specifies the text of the JSON query that selects the documents to operate on. For example, {"name":{"$eq":"fred"}}
Quantity	(Optional) Specifies the total number of records to read from the database.
Limit	(Optional) Specifies the maximum number of documents to return from the parsed data.
Select Source Tables	(Optional) Select which arrays of objects in the JSON data you wish to map to tables in the target.

Additional Information

Limitations: Any document you want to add into a MongoDB collection must be a JSON document.

Last modified date: 10/30/2024