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

Hmmmm no, haven't looked at VPD as an option. And not familiar with Oracle data reduction. I'll poke around and see what I can find out about this combo.

Chris

On Wed, Jun 10, 2020, 9:28 PM Al B. <albert.y.balbekov_at_gmail.com> wrote:

> Have you looked into Oracle VPD and Oracle Data Reduction ?
>
> They do not update tables for masking or hideing rows/columns, buy rather
> modify returned data in flight at runtime.
>
> Albert
>
> On Wed, Jun 10, 2020, 12:01 PM Powell, Mark <mark.powell2_at_dxc.com> wrote:
>
>> If the Oracle Masking product does not work for you then I expect you
>> need to roll your own masking routines. Perhaps depending on exactly what
>> issues you hit you can use the Oracle tool plus a series of your own
>> routines to prep/complete the work.
>>
>>
>> Mark Powell
>> Database Administration
>> (313) 592-5148
>>
>>
>> ------------------------------
>> *From:* oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on
>> behalf of Chris Taylor <christopherdtaylor1994_at_gmail.com>
>> *Sent:* Wednesday, June 10, 2020 2:00 PM
>> *To:* Jeff Smith <jeff.d.smith_at_oracle.com>
>> *Cc:* ORACLE-L <oracle-l_at_freelists.org>
>> *Subject:* 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
>>
>>
>>
>>
>> DXC Technology Company - Headquarters: 1775 Tysons Boulevard, Tysons,
>> Virginia 22102, USA.
>> DXC Technology Company -- This message is transmitted to you by or on
>> behalf of DXC Technology Company or one of its affiliates. It is intended
>> exclusively for the addressee. The substance of this message, along with
>> any attachments, may contain proprietary, confidential or privileged
>> information or information that is otherwise legally exempt from
>> disclosure. Any unauthorized review, use, disclosure or distribution is
>> prohibited. If you are not the intended recipient of this message, you are
>> not authorized to read, print, retain, copy or disseminate any part of this
>> message. If you have received this message in error, please destroy and
>> delete all copies and notify the sender by return e-mail. Regardless of
>> content, this e-mail shall not operate to bind DXC Technology Company or
>> any of its affiliates to any order or other contract unless pursuant to
>> explicit written agreement or government initiative expressly permitting
>> the use of e-mail for such purpose. --.
>>
>

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