• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1063
  • Last Modified:

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.
0
miyahira
Asked:
miyahira
1 Solution
 
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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
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
 
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

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now