Forum Stats

  • 3,816,773 Users
  • 2,259,232 Discussions
  • 7,893,563 Comments

Discussions

bi-directional sync between oracle rdbms to oracle nosql db

spic
spic Member Posts: 7 Green Ribbon
edited Jan 19, 2021 7:26PM in NoSQL Database Discussions

I am trying to figure out if there is away or a tool to sync database tables between Oracle RDBMS and oracle nosql database. My requirement is whenever there is a changes to tables in oracle rdbms table, then this value has to get synced into oracle nosql db table and vice versa in real time. Is this possible and is there a tool to do it. What are the alternative ways to do it. I am trying to build and app using oracle nosql database and i have a source or driving table in oracle rdbms. If syncing is possible, then how to handle the circular updates between dbs. like updates to table 1 is updated to the other database table and this causes an update back to source database and vice versa.


Thanks.

Tagged:

Answers

  • jxie-Oracle
    jxie-Oracle Member Posts: 4 Employee

    Hi,

    Looks the easiest way is to implement this in the application. If this is not possible, to sync from Oracle RDBMS to NoSQL, the user might want to use the RDBMS trigger but I am not sure if the RDBMS trigger can support write to external databases. To sync from NoSQL to RDBMS,  Streams API may be used to propagate NoSQL writes to the RDBMS. In either case, the user has to write some code.

    Hope it helps.

    Thanks,

    Junyi