Ideas to automate triggering refresh of VDBs on receipt of replication from another engine ?

  • 0
  • 1
  • Question
  • Updated 1 month ago
We have a process that requires replicating from one engine to another and need to automate refreshing VDBs on the receiving engine when each replication job completes.  Has anyone done this or have suggestions on approaches?
Photo of Nithin Rayilla

Nithin Rayilla

  • 110 Points 100 badge 2x thumb
  • exicted

Posted 1 month ago

  • 0
  • 1
Photo of Matt Griffith

Matt Griffith

  • 318 Points 250 badge 2x thumb
I suggest controlling the replication jobs via the API then you can trigger a refresh when the job completes.

This way you know when a rep' job is running (because the script started it) and can poll for a successful completion before running the refresh.
Photo of Nithin Rayilla

Nithin Rayilla

  • 110 Points 100 badge 2x thumb
Actually we are trying to to do in this way what you said but we are trying to understand how to call a VDB refresh after the replication job completed with respectively. 
Photo of Mouhssine SAIDI

Mouhssine SAIDI

  • 4,682 Points 4k badge 2x thumb

Hi,


You have to take a look from the end-to-end approach to choose the solution you will go with.

- You call control all the path from triggering replication to refresh the VDB on receipt (the easy one and you have the full control on all path steps, you can scale/change it as you need)
- The replication process is already automated by delphix cron from admin console or other scheduler utility; In this case you have to use API and check the status of last replication based on the result you decide to refresh the receipt VDB or not.

But i still have one question normally VDB will be used by a dev profile user automating it's refresh can destroy the ongoing job, at least if it's also used as master on the receipt engine

Regards,

Mouhssine

Photo of Nithin Rayilla

Nithin Rayilla

  • 110 Points 100 badge 2x thumb
But i still have one question normally VDB will be used by a dev profile user automating it's refresh can destroy the ongoing job, at least if it's also used as master on the receipt engine?
Ans: Actually we created a Master Copy for which no one is going to connect it.. we create the child VDB from that for all our clients. they will use that.