MySQL Connector

Back Next

MySQL targets in replication tasks

MySQL targets in
replication
tasks

When you replicate data to a database target, the

replication

task truncates the table name in the target database if the source object name exceeds 128 characters.

The following table describes the target properties in a

replication

task:

Property	Description
Connection	Name of the target connection. Select a target connection or create a connection.
Target Prefix	String that prefixes the source object names to create names for the target objects in the target. For more information, see “Truncating Table Names” in the help for Tasks .
Load Type	Replicates full load of data from MySQL to other applications.
Delete Options	This property is not applicable for MySQL Connector.

You can also configure the commit size, which defines the number of rows to commit. If you do not specify a value, the Secure Agent uses the default value. Default is 10000.

Replication tasks with MySQL

Download Guide

Watch

Comments

Cloud Connectivity Homepage

Communities

Knowledge Base

Success Portal