Posts Tagged ‘Enterprise Manager’


Running into Enterprise 2.0 at Oracle Open World 2009

October 12th, 2009 by Mark Peterson • No Comments »

If social computing is Enterprise 2.0 then Enterprise 2.0 is here, it’s exciting and it’s everywhere. There’s no place more at the center of Enterprise 2.0 than where we are here at Oracle Open World 2009.
Oracle Open World 2009, started officially this week. The keynotes speeches where well attended. Scott McNealy and Larry Ellison discussed the pending acquisition of Sun by Oracle and how software and hardware will come together in more power ways than ever before-a definite component of Enterprise 2.0. Likewise, Andrew McAffee (@amcaffe), who coined the term Enterprise 2.0 told us how Enterprise 2.0 will affect our lives. It’s so profound we can’t keep from running into it, which is precisely what I did. I ran right into it at Oracle Open World.

About 15 people started Oracle Open World by running a 5K fun run. The very informal event (and hopefully annual event) was put on by Judson Althoff. What better way to illustrate the power of Enterprise 2.0, but by talking about how many of us came upon this fun run.  For those who found it on the Oracle web-site and told me about it, thank you. I found the link on Twitter. I used the tag #ooW09, added “fun run” and there it was. We are to meet at the corner of 5th and Howard at 7:00AM on Monday.

This is a great example of what McAffee mentioned that there is structure to the internet and wisdom in the crowd. The internet is not like a library with “books on the ground”. It has structure and Google, Face-book, and Twitter contain some of the technologies that help create the structure.

What better way to celebrate being here, being part of Oracle Open World, by meeting people with some very specific desires (like running a 5K at 7:00AM) and finding them here at the center of Enterprise 2.0.

I met men and woman from all over the world; from the UK and South Africa; and organizers like Judson Althoff – just to name a few. The event was very informal, extremely successful, and no one got hit by a bus! (Oops) Judson (organizer and safety marshal) was kind enough to yell “clear”  or “NOT CLEAR”,  while we ran through the intersections together. (Near misses don’t count.)

Judson Althoff Kicking of Oracle Open World First Annual 5K Fun Run

Judson Althoff Kicking of First Annual Oracle Open World Fun Run

I’m excited about whats to come at Oracle Open World and so should we all. We’re here in the center of Enterprise 2.0 with more good things to come.

For those who ran with me, I was the guy who looked like the running-robber geek with lime-green water bottles. You can read more about me on my running blog at http://health-and-wellbeing.blogspot.com/

No Comments »

 

What Oracle is Doing Right

August 3rd, 2009 by Robert McMillen • No Comments »

For a change of pace I thought it would be good to  mention a few of the things I think that Oracle is doing right.   Over the last several years I continue to be impressed with what I see coming out of Oracle related to their product directions and new products.  Here’s my take on the things I see Oracle doing right.

The first one I’ll note is that Oracle is doing a great job at maintaining a Leadership Role in software innovation.  It’s obvious if you look at various evaluations such as the “Magic Quadrant” by Gartner that Oracle’s products are consistently in the top right quadrant where market leaders are found.  Here are a few Oracle products that I’ve had the opportunity to work with.

  • E-Business Suite R12 – R12 is more evolutionary than revolutionary but it significantly improves on what was a solid release in 11i by expanding the international capabilities of this massive applications suite.  With over 224 separate modules, R12 is mind-boggling in it’s scope of capabilities.  Oracle gets some dings for the bugs that were found in the first year  but they’ve quickly addressed the core issues in the releases leading up to release 12.1.  While there is an improved user interface the real changes are beneath the surface and which improve the productivity of everyday users.
  • 11g Database – there are many people who are better qualified to speak on this product than I but as one who has been working with the Oracle database since the last legs of version 6 I’m amazed that  Oracle continues to add useful and valuable capabilities to this workhorse of a database system.  In the areas of performance, operating systems supported, scalability and reliability the Oracle database keeps most of the world’s business working smoothly.  Yes the management interfaces are not as slick as they could be but the newer versions of Oracle Enterprise Manager tend to overwhelm me with information.  The power of PL/SQL remains a constant in the middle of all of the changes we have seen over the years.  Each new release allows more parameters to be changed on the fly rather than requiring downtime.  Recently introduced capabilities that I think will change the future of data management include Real Applications Testing, Active Data Guard, Database Vault and Total Recall.  There’s much more and I’ll probably get dinged in my comments for leaving it out but enough said.
  • Fusion Middleware 11g – Just released and while most of us are still trying to digest it all let me summarize it as a significant statement of Oracle’s capabilities to innovate dozens of products and continually integrate them in ways that architects, developers and management can better deliver business solutions that evolve more and more quickly.  The introduction of better technologies from the BEA acquisition has positioned Oracle to be the dominant player in this market.
  • JDeveloper 11g – This IDE has to compete with dozens of other great Java IDE’s like Eclipse and Aptana but still is a stand out.  This product offers all the bells and whistles including the ability to interact with all areas of the database and middleware environments that Oracle offers.  Additionally the capabilities of the Application Development Framework simplify the development of very robust user interfaces incorporating the best Web 2.0 goodies.  Using JDeveloper I can do Use Case design, write code, test, develop a database design and still not delve all of its capabilities.
  • Fusion Applications – Though not yet  released this coming Applications Suite will introduce an innovative User Interface that is a mash-up of the best of Web 2.0 and what Oracle has learned from it’s product acquisitions (such as PeopleSoft).  Built on Oracle Fusion Middleware capabilities this application will bring Service Oriented Architecture and more industry-standards to the underlying technology stack.    The focus on improving user productivity already seen in the UI will be much appreciated by those who do the real daily work of running the details of a business.
  • Miscellaneous - Kudos to Oracle for supporting the Open Source community by releasing versions of products that they have developed (see here).

Ok, it’s time to take a rest from this area of adulation and move to the second item I think Oracle has done well.  I’ll cover that in the next post.

No Comments »

 

Data Masking Options for Applications

April 30th, 2008 by Robert McMillen • 2 Comments »

In March 07, Oracle released the Applications Management Pack (AMP) for Enterprise Manager. One of the interesting features about the AMP is that it provides the ability to do data masking when cloning data from a production environment to a secondary environment where testing is done. This data masking ensures that confidential information such as SSN, compensation and health information is not revealed to those with access to testing environments.

What is confusing is that Oracle has also released a Data Masking Pack (DMP) for Enterprise Manager, however the data masking capabilities are different from those in AMP. DMP was announced in November 07. With this confusion in mind, here is some information about the data masking capabilities of DMP and a comparison of the two later in the article.

The Data Masking Pack ships with several mask primitives out of the box, such as Fixed values, Array of Values, Random Digits (zero padded), Random numbers, Random alphabetic characters of specified lengths, Random dates within a date range, Substring of original value, External table columns containing replacement mask data, and Shuffle within same table. If these options are not enough, it also supports user-defined functions written in PL/SQL to provide unlimited flexibility in creating mask formats. All of these mentioned primitives can be combined to create unlimited numbers of mask formats needed for masking any type of sensitive data. One note about Shuffling. The shuffling algorithm shuffles the data in the column, i.e. retains the data histogram, but removes the association of the original column data to the row.

The Data Masking Pack (DMP) supports only masking of Oracle database tables and columns and does not work on other data formats like Excel or plain text files. DMP generates logs of the masking process and Enterprise Manager has a built-in reporting engine that can be used to generate reports. It also provides the ability to preview the sample masked data prior to the masking process.

The key feature with any data masking solution is whether it maintains relational integrity. This requires that any data masking cannot break the relationship between one or tables. An example would be when masking is done for SSN and the SSN is used as a foreign key to another table.
For this reason DMP supports database enforced and application enforced referential integrity. It also supports the definition of any application relationships, including Oracle Financials and is certified for use with them.

Lastly, the Enterprise Manager has a built in scheduler that can be used to run the database cloning and the data masking processes. The script generated by the tool can be registered and run as a concurrent manager job.

Now that we’ve looked at the Data Masking Pack, let’s finish with a comparison of its features with that of the Application Management Pack (AMP).

Category

Data Masking Pack

Application Mgmt Pack

Referential integrity enforcement

Yes

No

Consistent masking values for all tables across databases (deterministic masking)

Yes

No

Pre-defined masking configuration for E-Business Suite

No, requires creation of EBS mask definition

Yes

User defined masking formats

Yes

No

High performance

Yes, uses Create Table As Select to generate masked copy of replacement table

Possibly, uses multiple workers to update tables.

RapidClone integrated

No

Yes

Supports other cloning methods, e.g. RMAN

Yes

No

Can run masking standalone

Yes

No

Masking configuration UI

Enterprise Manager

EBS

Masking execution

Enterprise Manager

Enterprise Manager (Clone+Mask)

Purge table support

No

Yes

Supports tables other than EBS

Yes

No

Supports applications other than EBS

Yes

No

Pricing

$10,000 per CPU of the server where data is being masked

$6,000 per CPU or $120 per Named User Plus.

2 Comments »

 

Applications Mgmt Pack for Enterprise Manager Updated

February 22nd, 2008 by Anonymous • No Comments »

A new version of AMP, version 2.0.1 is now available for E-Business Suite owners. It is distributed as a rollup update Patch 5969524 via Metalink. This update supports 11i and R12 versions. More information is available here.

No Comments »