Exasol Connector

Exasol Connector

Exasol sources in mappings and mapping tasks

Exasol sources in mappings and mapping tasks

When you configure a mapping to use an Exasol source, you can configure the source properties.
The following table describes the Exasol source properties:
Property
Description
Connection
Name of the source connection.
Source Type
Type of the source object. Select one of the following types:
  • Single. Select to specify a single Exasol object.
  • Parameter. Select to define the source type when you configure the mapping task.
Object
The source object for the mapping.
Query Options
You can configure the following query options:
  • Filter. Configure a simple filter to filter source data to limit the amount of source data that enters the data flow.
  • Sort. You can sort source data to provide sorted data to the mapping.
You can set the tracing level in the advanced properties to determine the amount of detail that appears in the logs.
The following table describes the tracing level values:
Tracing Level
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.