About data masking and licenses in Oracle

Hello,

We are trying to implement data masking for testing data.

I know that this feature is available with Oracle Enterprise. However for us it's very expensive.

In order to lower license costs, could be possible to have an Oracle Enterprise only for one named user, or have an Oracle Personal or Express Edition for data masking.

Maybe it's possible to have one Oracle server with data masking feature, mask data, and export that data to other databases.
LVL 1
miyahiraAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
You should ask Oracle this directly to ensure you are legal with what you are proposing.
0
miyahiraAuthor Commented:
Yes, of course I asked Oracle, but their salesmen (at least in my country) are not so fast or don't like to answer this kind of questions.

Just asking if someone had some similar license experience, so I can ask Oracle with more information.
0
gatorvipCommented:
Take a look at the licensing options here:
http://www.oracle.com/us/corporate/pricing/specialty-topics/index.html

In particular, you want to look at the policies document ( http://www.oracle.com/us/corporate/pricing/databaselicensing-070584.pdf )

In short, for a testing environment, you need a license. For a development environment, you do not need an additional license as long as the development is restricted to 1 user per 1 computer per install.

However, this is just my interpretation of their documentation and you shouldn't necessarily rely on it. The Oracle reps are best suited to answer licensing questions.
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

miyahiraAuthor Commented:
It's not possible.

http://download.oracle.com/docs/cd/E11882_01/license.112/e10594/options.htm#DBLIC2114

"Oracle Data Masking Pack must be licensed for those databases servers where the masked data originates from as well as those database servers containing the masked data."
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
miyahiraAuthor Commented:
Found by myself.
0
AkenathonCommented:
You can do what you say... there's nothing wrong in processing your data on an EE at the minimum license, and then export the data to a SE at your production licenses. Nobody will say anything against your usage of the exported data. Some pitfalls:

- Some licenses have minimums, e.g. you can buy by named user, but they won't license anything below 25 users. That's something only your Oracle representative can confirm... look into Personal Oracle, I think it's the only one that can be licensed for just one user (actually it's MEANT to be licensed for just one user!)
- If your structures have anything only supported by EE, they cannot be directly transported onto a SE. For instance, a create table with partitions will fail if you run it on a DB without the partitioning option. However, the data can still be merged on a SE non-partitioned table. Same for advanced compression options, etc.
- What you CANNOT do is make use of their free license for prototyping and/or personal study to use an EE for this. You would be using the EE as part of your testing environment, so it's clearly NOT allowed

Remember you can always run some custom scripts to scrub sensitive data after cloning the production DB into the testing environment. Actually that's what everybody did before masking was invented :-)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.