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 |
---|---|---|
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