Host/URI

Specifies the host name or MongoDB URI of the MongoDB server. This is a mandatory property.

Agent

Select the Actian Integration Agent that is installed on your system and is registered to the logged in user (The agent must be registered to the logged in user, otherwise it will not work).

This property is only applicable when connecting via an agent.

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.

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.