You can use a single object as a target in a synchronization task.
The following table describes the Oracle target properties:
Property
Description
Connection
Name of the active target connection.
Target Object
Name of target objects available in the connection.
Truncate Target
When you enable the Truncate Target option, the Secure Agent truncates the table. Default is false.
Enable Target Bulk Load
Uses Oracle bulk API to write data in bulk mode to Oracle.
Default is unselected.
Display target fields in alphabetical order
Displays target fields in alphabetical order. By default, fields appear in the order returned by the target system.
Configuring an update override for the target
To override the default update SQL statement that the Secure Agent generates, you can specify an SQL statement in the Update Override field of the advanced target properties.
1Next to the Update Override field, click Configure.
2In the Update Override SQL Editor dialog box, enter the update SQL statement that the Secure Agent must use.
3Click Generate SQL to generate an SQL query.
4Click Format SQL to format the SQL query you entered.
You can modify the generated SQL query in the SQL editor based on your requirement.