Avoiding data synchronization \"loops\" with JDBC

We’re creating a bidirectional data synchronization solution using the JDBC adapter between Oracle and SQL Server databases.

There is an approach for that.

Create a column called “UserName” in the tables you are listening to (the buffer table that is fed by the triggers), and have the JDBC adapter login to the DB using a dedicated username value. Then, when the trigger is executed, you will be able to get the username value from the session and insert it into the buffer table.

When the JDBC adapter reads the buffer table, skip all the columns, for which UserName matches the value used by itself.