Re: Enterprise Manager Application Data Modelling question

  • From: Tim Gorman <tim.evdbt@xxxxxxxxx>
  • To: peter.sharman@xxxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 13 Nov 2018 15:56:05 -0800

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


Other related posts: