MongoDB V2 Connector

Back Next

MongoDB V2 sources in mappings

To read data from MongoDB, configure a MongoDB V2 object as the Source transformation in a mapping.

Specify the name and description of the MongoDB V2 source. Configure the source, query options, and advanced properties for the source object. When you configure a Source transformation, you can add or remove source fields of primitive data types.

You can parameterize the MongoDB V2 source connection and source object with values specified in a parameter file when you configure a mapping or a mapping in advanced mode.

The following table describes the source properties that you can configure for a MongoDB V2 source:

Property	Description
Connection	Name of the MongoDB V2 source connection. You can select an existing connection or create a new connection. You can also click New Parameter to define a parameter for the source connection.
Source Type	Type of the source object. Select one of the following options: Single Object Multiple Objects¹ Parameter Related objects appear based on simple primary key-foreign key relationships. You can use the Advanced Relationship option to define the relationship for objects that you want to join.
Object	Name of the MongoDB V2 source object based on the source type selected. Select the source object for a single source.
¹ Applies only to mappings in advanced mode.

The following table describes the query options that you can configure in a Source transformation:

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 on an object. For more information about the complex filter conditions, see MongoDB filter formats. You can configure filter conditions for columns of the following data types: Date Double Float Integer String
Select distinct rows only	Not applicable.

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 on an object.

For more information about the complex filter conditions, see MongoDB filter formats.

You can configure filter conditions for columns of the following data types:

Date

Double

Float

Integer

String

Select distinct rows only

Not applicable.

The following table describes the advanced properties that you can configure in a Source transformation:

Property	Description
Pre Query¹	Statement that you want to run before reading data from the source. You can use only insert, update, and delete operations. For example, if you want to insert records in the database before you read the records from the table, specify the following preSQL statement: { insert: 'yourCollection', documents: [ { name: 'Alice', age: 25 } ] }
Post Query¹	Statement that you want to run after reading data from the source. You can use only insert, update, and delete operations. For example, if you want to update records in a table after you read the records from a table, specify the following postSQL statement: { update: 'yourCollection', updates: [ { q: { name: 'Alice' }, u: { $set: { age: 26 } } } ] }
Additional Properties	Additional options that you want to specify to read data from MongoDB. Separate multiple options with an ampersand. For information about the additional properties that you can configure, see the Additional connection properties chapter.
Tracing Level	Amount of detail that appears in the log for this transformation. You can use the following tracing levels: Terse Normal Verbose Initialization Verbose Default is normal.
¹ Doesn't apply to mappings in advanced mode.