Table of Contents

Search

  1. Preface
  2. Introduction to Oracle Connector
  3. Connections for Oracle
  4. Synchronization tasks with Oracle Connector
  5. Mappings and mapping tasks with Oracle Connector
  6. Replication tasks
  7. Troubleshooting
  8. Appendix A: Data type reference

Oracle Connector

Oracle Connector

Configuring an update override for the target

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.
  1. Next to the
    Update Override
    field, click
    Configure
    .
  2. In the
    Update Override SQL Editor
    dialog box, enter the update SQL statement that the Secure Agent must use.
  3. Click
    Generate SQL
    to generate an SQL query.
  4. Click
    Format SQL
    to format the SQL query you entered.
    You can modify the generated SQL query in the SQL editor based on your requirement.
  5. Click
    OK
    .

0 COMMENTS

We’d like to hear from you!