MySQL Connector

Back Next

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 target connection. You can select an existing connection, create a new connection, or define parameter values for the target connection property. If you want to overwrite the target connection properties at runtime, select the Allow parameter to be overridden at run time option.
Target Type	Type of the MySQL target object available. You can choose from the following source types: Single Parameter
Parameter	A parameter file where you define values that you want to update without having to edit the task. Select an existing parameter for the target object or click New Parameter to define a new parameter for the target object. The Parameter property appears only if you select parameter as the target type. If you want to overwrite the target object at runtime, select the Allow parameter to be overridden at run time option. When the task runs, the Secure Agent uses the parameters from the file that you specify in the advanced session properties.
Object	Select an existing object from the list or create a new object at run time.
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 truncates the table before running the task. Default is not selected.
Update Override	An update SQL statement that updates the data in a MySQL target table. The update SQL statement you specify overrides the default update statements that the Secure Agent generates to update the target based on key columns. You can define an update override statement to update target tables based on both key or non-key columns. In the override statement, you must enclose all reserved words in quotation marks.

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.

Mappings and mapping tasks with MySQL Connector

Configuring an update override for the target

Download Guide

Watch

Comments

Cloud Connectivity Homepage

Communities

Knowledge Base

Success Portal