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@xxxxxxxxxxxxxx> 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@xxxxxxxxx
To:
<peter.sharman@xxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxxx 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
