MongoDB Connector > Mappings and mapping tasks with MongoDB > MongoDB targets in mappings
  

MongoDB targets in mappings

To write data to a MongoDB target, configure a MongoDB object as the Target transformation in a mapping.
Specify the name and description of MongoDB target. Configure the target and advanced properties for the target object.
The following table describes the target properties that you can configure for a MongoDB target:
Property
Description
Connection
Name of the MongoDB connection that is associated with a dataset.
Target Type
Type of the MongoDB target objects available.
  • - Single Object. Reads from a single JDBC object.
  • - Parameter. Parameterizes the object name.
You can write data to multiple MongoDB target objects.
Object
Name of the MongoDB target object based on the target type selected.
Operation
You can select one the following operations:
  • - Insert
  • - Update
  • - Delete
Note: You cannot perform a delete operation on a MongoDB virtual table.
Update columns
Specifies the default primary key column and temporary key columns to update or delete target data.
If the MongoDB target does not include a primary key column, and the mapping is configured to perform an update or delete task operation, click Add to add the primary key column and temporary key columns.
You must select the default primary key column and the temporary key columns.
Select the key columns to update data to or delete data from the MongoDB target table.
By default, no columns are specified.
The following table describes the advanced properties that you can configure for a MongoDB target:
Property
Description
preSQL
SQL statement that you want to run before writing data to the target.
For example, if you want to insert records into the database before you write the records into the table, specify the following preSQL statement:
INSERT INTO cloud.employees ("name", "uid") VALUES('Presq_src', 2012)
postSQL
SQL statement that you want to run after writing the data into the target.
For example, if you want to update records in a table after you write the records into the table, specify the following postSQL statement:
UPDATE cloud.employees
SET uid = 2011 WHERE uid=2014
Bulk Mode
Performs bulk upload when you configure an insert, update, or delete operation to write data to a MongoDB target. Select this option to improve the performance of inserting, updating, or deleting data in bulk from MongoDB.
Batch Size
The number of rows that the Secure Agent writes in a single batch to MongoDB. Specify a batch size value that is greater than zero.
Applicable if you select the Bulk Mode check box.
Note: To gain better performance it is recommended that the batch size value is less than or equal to 1000.
Forward Rejected Rows
Determines whether the transformation passes rejected rows to the next transformation or drops rejected rows.
By default, the agent forwards rejected rows to the next transformation.