Re: Anyone using any nifty products to generate a Sales Demo environment off live data?

Yes - masking or updating data is critical as its a healthcare application.

We have a fast clone process we can use if we want to create a snapshot of the whole database. But not a great option for the Demo since we have to update monster tables. And the Oracle masking product runs into all kinds of issues that made it an awful headache.

I suspect what I'm looking for doesn't exist.

Chris

On Wed, Jun 10, 2020 at 1:52 PM Jeff Smith <jeff.d.smith_at_oracle.com> wrote:

> 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
> *To:* ORACLE-L <oracle-l_at_freelists.org>
> *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
>
>
>

--
http://www.freelists.org/webpage/oracle-l