You can perform insert, update, upsert, and delete operations on a JDBC target. Configure the field mapping based on the target operation.
When you map the primary key field, the synchronization application can identify the records to insert, update, upsert, or delete.
When you run a task with the insert, update, or upsert operations to a JDBC target, map the primary key field and all other fields that you want to update.
When you run a task with the delete operation on a JDBC target, map the primary key field only. You do not need to map any other fields.
When you write to a Postgres JDBC target field of the bit data type, the synchronization task fails due to a PostgreSQL and JDBC limitation.
If you create a synchronization task with a JDBC target object and a specified precision value (for example, 6,3) for decimals, if the target contains a decimal field with a precision that exceeds the specified precision value, the task fails. This is due to a Derby limitation.