MongoDB Sources in Mappings
To read data from MongoDB directory server, configure a MongoDB object as the Source transformation in a mapping. You can configure a Source transformation to represent a single MongoDB source.
Specify the name and description of the MongoDB source. Configure the source properties for the source object.
The following table describes the MongoDB source properties that you can configure in a Source transformation:
Source Property | Description |
|---|
Connection | Name of the source connection. |
Source Type | Type of source object. Select Single or Multiple objects as the source type. |
Object | Name of the source object. Select the source object for the mapping. |
The following table describes the MongoDB query options that you can configure in a Source transformation:
Source Property | Description |
|---|
Filter | Filter value in a read operation. Click Configure to add conditions to filter records and reduce the number of rows that the Secure Agent reads from the source. You can specify the following filter conditions: - - Not parameterized. Use a basic filter to specify the object, field, operator, and value to select specific records.
- - Completely parameterized. Use a parameter to represent the field mapping.
- - Advanced. Use an advanced filter to define a more complex filter condition that uses the MongoDB query format.
|
Sort | Sort value in a read operation. Click Configure to add conditions to sort records and reduce the number of rows that the Secure Agent reads from the source. You can specify the following sort conditions: - - Not parameterized. Use a basic filter to specify the object, field, operator, and value to select specific records.
- - Parameterized. Use a parameter to represent the field mapping.
|