API/Python/Open-Source Solutions

Expand all | Collapse all

HOW TO REWIND 2 DBs WITH DEPENDENCY?

Jump to Best Answer
  • 1.  HOW TO REWIND 2 DBs WITH DEPENDENCY?

    Posted 08-21-2015 11:34:00 AM
    Hello, On my environment I have 2 DBs (Siebel and BRM) with data dependancy between each order. Some information created by Siebel is synched with BRM and vice-versa. This is mandatory and the consistency is relevant to customer products and billing. That said my question is: is there a way to automatically rewind, forward and/or bookmark those two databases together?


  • 2.  RE: HOW TO REWIND 2 DBs WITH DEPENDENCY?
    Best Answer

    Posted 08-21-2015 01:30:00 PM
    Absolutely. The best way to do this would to setup a snapshot policy for both sources that executes at the same time. So, say every hour, on the hour. Then, you could do one of two things:

    1. Use JetStream to create a template that contains those two sources. Then you create a container in that template for each pair of virtual db's that you want to keep in sync. Every refresh, rewind, bookmark action will happen on the container as a whole. (clicking rewind/refresh will rewind/refresh both vdb's at the same time.
    2. Use API/CLI scripting to execute refreshes/rewinds/bookmarks on both object to whatever point-in-time reference you desire.


  • 3.  RE: HOW TO REWIND 2 DBs WITH DEPENDENCY?
    Best Answer

    Posted 08-21-2015 01:57:00 PM
    Absolutely great answer. Thank you.