Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

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

image-20240331-040526.png

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

image-20240331-040737.png

  • MongoDB shard cluster (comma separated host)

image-20240331-040825.png

  • Mongodb single host

image-20240331-040858.png

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:

image-20240331-040957.png

Field Mapping using functions

image-20240331-041243.png

Target

image-20240331-041451.png

  • No labels