Is masking critical data part of the requirement?
Because a very cool feature of multitenant is you can clone a pdb for this very
use case of having a copy of prod for doing dev/test work in.
It also supports periodic refreshes as the master data is updated.
But you’d still have to account for the sensitive/PII data you would want to
restrict.
From: Chris Taylor <christopherdtaylor1994@xxxxxxxxx>
Sent: Wednesday, June 10, 2020 12:37 PM
To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
Subject: Anyone using any nifty products to generate a Sales Demo environment
off live data?
So we have a 130TB production db for a lot of our Products that we sell.
We have a Demo env that we use dbms_datapump to subset portions of the data
into the Demo DB.
Now we've got products in multiple DBs and the business is wanting to create
demo environments for all those product lines.
I'm curious if anyone on this list has a product in their Org that facilitates
building demo environments off live data .
We tried Oracle's data masking tool but that has severe drawbacks
(shortcomings) so we gave up on that (but might have to revisit)
Thanks,
Chris