Does it change the way we connect to source?

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
Hi Team,
Need your help!

I am a part of testing service which is delivering 170+ projects for Virgin Media every year.

The main challenge we are facing is to have multiple data test environments to support multiple projects at the same time to avoid conflicts. Usually higher costs are involved to have multiple databases in test environment hence not a viable option.

I just wanted to check if we can create multiple virtual database instances of a single source (oracle for instance) which can maintain separate copy of data in it, which then can be shared with different testing projects? If yes, then will it change the way different systems (middleware, ETL/JOB etc.) will connect to oracle in this case if we decide to use virtual instances instead.

Basically to put this case forward, the other technologies should not ideally feel the difference and should not realise that they are interacting with virtual instances and not the actual database.

I hope I explained it well! Let me know for any question.

Many Thanks,
Subodh Deshmukh
Photo of Subodh Deshmukh

Subodh Deshmukh

  • 100 Points 100 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Gary Hallam

Gary Hallam, Official Rep

  • 2,104 Points 2k badge 2x thumb
Hi Subodh,
The virtual database (VDB) will look, taste, feel and smell like a regular database!  Your connection string to the database will be a regular one and your applications and middleware will not notice any difference.  In fact, you can have your developers and testers prepare multiple branches or versions of the same database and switch between them using a self service web UI (that we call a data pod) without needing to change the connection string at all.
Many customers when testing out the VDB capability don't actually tell their development teams to see if anyone notices the difference, so your other technologies won't notice either.  You will just empower people to work smarter and faster!
Regards,
Gary
Photo of Gary Hallam

Gary Hallam, Official Rep

  • 2,104 Points 2k badge 2x thumb
Feel free to drop an email to gary.hallam at delphix.com if you want to discuss further Subodh.