Couchbase sources in mappings

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

Specify the name and description of the Couchbase source. Configure the source, query options, and advanced properties for the source object.

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

Property	Description
Connection	Name of the Couchbase source connection.
Source Type	Type of the Couchbase source objects available.
Object	Name of the Couchbase source object based on the source type selected.

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

Property	Description
Filter	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. You can configure filter conditions for columns of the following data types: - Date - Double - Float - Integer - String
Sort	Not applicable for Couchbase Connector.

Property

Description

Filter

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.

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

Sort

Not applicable for Couchbase Connector.

The following table describes the advanced properties that you can configure for a Couchbase source:

Property	Description
preSQL	SQL statement that you want to run before reading data from the source.
postSQL	SQL statement that you want to run after reading data from the source.

You can set the tracing level in the advanced properties session to determine the amount of details that logs contain.

The following table describes the tracing levels that you can configure:

Property	Description
Terse	The Secure Agent logs initialization information, error messages, and notification of rejected data.
Normal	The Secure Agent logs initialization and status information, errors encountered, and skipped rows due to transformation row errors. Summarizes session results, but not at the level of individual rows.
Verbose Initialization	In addition to normal tracing, the Secure Agent logs additional initialization details, names of index and data files used, and detailed transformation statistics.
Verbose Data	In addition to verbose initialization tracing, the Secure Agent logs each row that passes into the mapping. Also notes where the Secure Agent truncates string data to fit the precision of a column and provides detailed transformation statistics. When you configure the tracing level to verbose data, the Secure Agent writes row data for all rows in a block when it processes a transformation.