MongoDB

version: 1.0.0

Category: Database

Tier: 2

Type: Source, Target

Authentication:

Basic (Username and Password)

Supported Save Mode as Target:

Append
Overwrite

See: Target Connector Save Modes

Connection Properties

Name	Mandatory	Description

Name	Mandatory	Description
Connection Name	Yes	Name of the connection
Description	No	Description of connection
Username	Yes	Username used for authentication
Password	Yes	Password used for Authentication
Host	Yes	You can include port of host if not srv, or comma separated host if shard cluster
Database	Yes	The MongoDB database
Connection scheme	Yes	Indicates whethere mongodb or mongodb+srv

mongodb+srv

MongoDB shard cluster (comma separated host)

Mongodb single host

Fields
NOTE: Since mongodb is a nosql database which collections do not have strict type, fields are read by EazyDI depending on sample size of data in collection. Columns can also be lists, nested objects, similar to json, you can use the necessary mapping functions to cast columns to match target columns.

MongoDB as source:

Field Mapping using functions

Target

Note:

When adding the mongodb primary key _id in the mapping as a target, when running the pipeline, if the _id does not yet exist, mongodb will create new documents, if they exist, mongodb will not create new documents but those existing in mongodb with the same _id will be updated instead on whatever the incoming data is. This is the known behavior for mongodb and EazyDI was designed not to prevent or hinder what the behavior of mongodb is so users will have full control on how to use it.