Couchbase Connector > Mappings and Mapping Tasks with Couchbase > Couchbase targets in mappings
  

Couchbase targets in mappings

Configure a Couchbase object as the Target transformation in a mapping to write data to a Couchbase target.
Specify the name and description of Couchbase target. Configure the target and advanced properties for the target object.
The following table describes the target properties that you can configure for a Couchbase target:
Property
Description
Connection
Name of the active Couchbase connection that is associated with a dataset.
Target Type
Type of the Couchbase target objects available.
You can write data to a single Couchbase target object or parameterize the object. You cannot write data to multiple objects.
Object
Name of the Couchbase target object based on the target type selected.
Operation
You can select one the following operations:
  • - Insert
  • - Update
  • - Delete
Update columns
Specifies the default primary key column and temporary key columns to update, upsert, or delete target data.
If the Couchbase target does not include a primary key column, and the mapping performs an update, upsert, 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. By default, no columns are specified.
Select the key columns to upsert or update data to or delete data from the Couchbase target table.
The following table describes the advanced properties that you can configure for a Couchbase target:
Property
Description
UpdateMode
Specifies the mode to write data to Couchbase target. You can specify the following modes:
Update As Update
Updates all rows flagged for update if the entries exist.
Update Else Insert
Updates all rows flagged for update if the entries exist in the target. If the entries do not exist, the Secure Agent inserts the entries.
Note: Use Update Else Insert option to perform upsert operation on a Couchbase target table.
preSQL
SQL statement that you want to run before writing data to the target.
postSQL
SQL statement that you want to run after writing the data into the target.
Forward Rejected Rows
Not applicable for Couchbase Connector.