RE: Anyone using any nifty products to generate a Sales Demo environment off live data?
Date: Wed, 10 Jun 2020 10:50:03 -0700 (PDT)
Message-ID: <42d8b7b5-5017-4045-9ce1-36f00344d009_at_default>
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_at_gmail.com>
Sent: Wednesday, June 10, 2020 12:37 PM
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
To: ORACLE-L <oracle-l_at_freelists.org>
Subject: Anyone using any nifty products to generate a Sales Demo environment off live data?
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jun 10 2020 - 19:50:03 CEST