HOW TO REWIND 2 DBs WITH DEPENDENCY?

  • 0
  • 3
  • Question
  • Updated 3 years ago
  • Answered
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?
Photo of Thiago Salgado

Thiago Salgado

  • 154 Points 100 badge 2x thumb
  • UNSURE

Posted 3 years ago

  • 0
  • 3
Photo of Adam Bowen

Adam Bowen, Official Rep

  • 17,418 Points 10k badge 2x thumb
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.
Photo of Thiago Salgado

Thiago Salgado

  • 154 Points 100 badge 2x thumb
Absolutely great answer. Thank you.