Exasol Connector

Exasol Connector

Exasol targets in mappings and mapping tasks

Exasol targets in mappings and mapping tasks

When you configure a mapping to use an Exasol target, you can configure target properties.
The following table describes the target properties that you can configure in a Target transformation:
Property
Description
Connection
Name of the target connection.
Target Type
Specify the type of the target object. Select from one of the following options:
  • Single. Select to specify a single Exasol object.
  • Parameter. Select to define the target type parameter when you configure the mapping task.
Object
You can select an existing object or create an object at runtime.
Operation
Specify the target operation. You can perform insert, update, and delete operation on an Exasol target.
Update columns
Updates the columns specified in the list of column names.
The following table describes the Exasol advanced target properties:
Property
Description
Schema Name
The source schema name for the update or delete operation.
Source Table Name
The name of the source table that temporarily holds the data that you want to update or delete.
Key Column
The primary key for the update or delete operation. If the target table does not have a primary key, you can define a composite key with multiple column names using a comma delimiter.