Planning for a POC running multiple RDBMS (MS SQL Server & Oracle)

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
Hello everyone,

Hope you guys are doing well.

Currently, we're planning a POC that will run both MS SQL Server and Oracle as its primary dSources. As I still have very little experience in handling a Delphix POC (especially setting up an Oracle environment), I would like to ask for your assistance in doing this. I'm well aware of the docs.delphix.com (which is a big help by the way) website but it would really be helpful on my part if you guys can impart some of your experiences and expertise with me. (Thanks in advance!)

Any advice on how to approach this? What are the most important things to take note of?

That being said, the main challenge that we'll be dealing with is the amount of the resources they can provide. What would be the lowest (but still acceptable) we can allocate to run a Delphix Engine? (Docs say 64gb for RAM but unfortunately, that's still a reach in this case)

Lastly, hope I can get a minimum list of requirements that will also serve as a reference for future cases as well.

Best regards,
Mark
Photo of Mark

Mark

  • 310 Points 250 badge 2x thumb
  • Challenged

Posted 1 year ago

  • 0
  • 1
Photo of Joey Dobias

Joey Dobias, Employee

  • 430 Points 250 badge 2x thumb
Official Response
A POC with one or many RDBMSs can be a complex undertaking. To ensure that the full benefit of the Delphix Engine is realised for your specific use case scenarios, Delphix strongly encourages engaging with our Professional Services team. It would be daunting to contemplate managing purely through the community forum.

As for the approach, the documentation should be considered the source of truth. The minimum requirements are documented at https://docs.delphix.com/docs/architecture-best-practices

Areas which are most likely to present problems are implementing the Delphix Engine into an environment that too closely reflects your live infrastructure. Having to deal with LDAP integration, non standard privilege elevation (third party sudo management) on UNIX or cross domain trust policies on Windows greatly complicates things. If possible, keep the POC as simple as possible to demonstrate core functionality and then refine the configuration from there.

  • Go slowly.
  • Use simple highly permissive sudo profiles on UNIX
  • Use the same Windows domain user if possible across all Windows hosts
  • Keep the Oracle and MSSQL implementations as close to plain vanilla configurations as possible (no ASM, PDBs, third party MSSQL backup tools etc).
  • Ensure the source and target hosts are all in the supported OS matrix.

The Delphix Engine supports a large variety of configurations to make it usable in a wide variety of heterogeneous and fairly idiosyncratic customer environments. However, these do require more advanced planning and implementation and are, if possible, best left for post POC live implementations.

If you are not in a position to use our Professional Services team, then the advice to keep things simple at first is even more important since any issues will have to be self resolved or via the experiences of the community forum - which is good but our support team is much better equipped to deal with issues. 
Photo of Joey Dobias

Joey Dobias, Employee

  • 430 Points 250 badge 2x thumb
Official Response
As an aside, you can operate the Delphix Engine with much less resources (how much less really depends on how hard you push it). It won't be supported by Delphix, but that might be okay for your POC requirements.