MySQL Connector Guide > Mappings and Mapping Configuration Tasks with MySQL Connector > MySQL Targets in Mappings
  

MySQL Targets in Mappings

To write data to a MySQL database, configure a MySQL object as the Target transformation in a mapping.
Specify the name and description of the MySQL target. Configure the target and advanced properties for the target object.
The following table describes the target properties that you can configure for a MySQL target:
Property
Description
Connection
Name of the active MySQL target connection.
Target Type
Type of the MySQL target object available. You can choose from the following source types:
  • - Single
  • - Parameter
Object
Name of the MySQL target object based on target type selected. Specify the target file or target object that you want to create at runtime. You can also select an existing object from the list.
Operation
Select the target operation. You can perform the following operations on a MySQL target:
  • - Insert
  • - Update
  • - Upsert
  • - Delete
  • - Data Driven
Truncate target
When you enable the Truncate Target option, the Secure Agent drops and recreates the table before running the task. Default is not selected.
If you select the Forward Rejected Rows option, the Secure Agent flags the rows for reject and writes them to the reject file. If you do not select the Forward Rejected Rows option, the Secure Agent drops rejected rows and writes them to the session log file. The Secure Agent does not write the rejected rows to the reject file.