Re: Enterprise Manager Application Data Modelling question

this is the second oracle-l thread where the future of EM has been questioned. is the product going away in the future? will it be replaced by something else for shops that run their own databases?

On Tue, Nov 13, 2018 at 6:03 PM <peter.sharman_at_westnet.com.au> wrote:

> Looking at other options is not on the table, Tim.
>
> I make no comment about EOL for EM. :(
>
> Pete
>
>
> ----- Original Message -----
> From:
> tim.evdbt_at_gmail.com
>
> To:
> <peter.sharman_at_westnet.com.au>, <oracle-l_at_freelists.org>
> Cc:
>
> Sent:
> Tue, 13 Nov 2018 15:56:05 -0800
> Subject:
> Re: Enterprise Manager Application Data Modelling question
>
>
> In the end, all products are EOL, but some are closer to EOL than others.
>
> With masking options from Informatica, IBM, Delphix, Red Gate, Dataveil,
> and others to choose from, each of which mask data across most all
> relational database platforms, as well as documents, it seems short-sighted
> to invest licensing money, time, and effort on masking one island of
> information within Oracle one way, and masking all other database platforms
> using other methods. Because all confidential data in non-prod needs to be
> masked, not just Oracle.
>
> Full disclosure: I work for Delphix, and we do data masking at-rest across
> almost all databases and documents, including mainframe.
>
> In the past 4+ years, I have only once come up against data masking using
> the Oracle EM pack. This company disliked their experiences masking with
> the Oracle pack because it generated complex SQL and PL/SQL to perform the
> masking within the database engine. Masking algorithms are computationally
> intensive (i.e. encryption, hashing, list-processing, etc) and thus
> difficult to optimize in generated SQL and PL/SQL, performing poorly as
> they chew up CPU expensively licensed for database. When you charge as
> much as Oracle does based on CPU, you don't want that CPU doing anything
> but database workload.
>
> By contrast, each and all of the other data masking packages retrieve
> arrays of rows to an appserver, mask them in the appserver (typically a
> generic Linux server), then either insert them forward or update them back
> using ROWID, less reliance on the Oracle optimizer, and employing less
> expensive CPU for the computationally-intense masking workload, conserving
> the expensive database licensed CPUs for database workload.
>
> So when your customers regroup to mask across the enterprise instead of an
> island of Oracle, any of these masking vendors will be happy to solve
> that. Especially down under, on that super big island y'all have... :)
>
>
>
> On 11/13/18 14:36, peter.sharman_at_westnet.com.au wrote:
>
> Yes, I know, it’s unlike me to be asking a question on EM instead of
> answering one. 😊
>
> This is one I’ve never seen before. I’ve been setting up Data Masking
> for a customer and we have a couple of different ADMs. Previously, the
> Referential Relationships screen showed no records, as the referential
> integrity is not defined in the database (not ideal, but that's how it
> is). But now the screen is completely blank - no buttons, no screen saying
> no records found, nothing. Anyone seen anything like that before?
> Restarting the OMS didn't have any impact. Logged an SR, but no response
> on it yet and the customer really wants to see some progress so trying all
> avenues to move this forward.
>
> EM 13.2 vanilla.
>
> Thanks
>
> Pete
>
>
>

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