Posted by: michaelverzijl | 06/10/2011

Review Session Day 4: Oracle Open World

Yesterday was day 4 of Oracle OpenWorld 2011 in San Francisco.
It was an exciting an long day (especially with the Appreciation Event after a full day of conference)

The day started with an Hands-on-lab with Oracle GoldenGate Monitor.

After this session Stewart Bryson gave a session on Agile DWH/BI with OBIEE and Exadata.

Stewart showed a mythology where you create user stories, do a times based iterations and deliver the product to the consumer. On this way you don’t have to wait for months before you actually see some results. Import to notice is that rework is not part of the game, but a separate user story.

Furthermore Stewart told how he implements the Oracle’s Data Warehouse Reference Architecture.
In this architecture you have 3 layers:

  1. Staging layer – where you receive new data
  2. Foundation layer – Gathers all historical data (flexible manner)
  3. Performance layer – Performance and reporting

In the Foundation layer you only do inserts, no updates. Furthermore Stewart recommends to use SCD2 in the foundation layer for all attributes.
You can easily change SCD2 in SCD1 in the report by using analytical functions like LAST_VALUE/RANK.

The ideal way to work is with a combination of Oracle Exadata:

  • Use compression from Exadata
  • Storage indexes
  • Smart scans

If you start a new project do this in a model-driven iteration:

  • Start with a few requirements
  • Start with modelling your report on the foundation layer (discover facts and dimensions)
  • Start with the high impact reports and dashboards

On this way you are prototyping with OBIEE instead of queries and showing the data in OBIEE. If performance is a problem a user can open a new user story for an ETL iteration.

I think this is a good solution where you can deliver value to the customer in a short period.

The second session of today was on ODI and security constraints.
Presented by Sangeetha Sourirajan and Sumit Agrawal.

The presentation is given because both speakers encounted a project where the ODI configuration needed to be changed.
Normally the work schema has a lot of Oracle grants like creating table, dropping tables and so on.

The DBA of the project didn’t allowed this so they created a solution were the KM were adjusted so that:

  • Minimum system privileges were needed
  • Grant object level privileges were given
  • All is done in runtime creation

After this it was time for the last Keynote for this years Oracle OpenWorld.
First Infosys showed a demonstration of the vision and strategy of Infosys.

After this Larry took the stage and announced:

The last session of today was the Oracle Data Integration roadmap session, presented by Denis Gray.
Dennis mentioned that the product consist of:

  • GoldenGate
  • Oracle Data Integrator
  • Oracle Enterprise Data Quality

The differentiator between these products and competitors is that competitors need additional hardware, Oracle doesn’t.
The strategy is:

  • Be Open and Heterogeneous
  • Easy and fast to implement (no new hardware)
  • Easy to fit-in with architecture
  • Flexible batch or real-time data flows

Furthermore ODI is positioned as a product that isn’t dependent on Oracle technology, as it can also work outside an Oracle environment.
Future releases are planned:

  • -> BI integration (somewhere between now and a month) and is available in BI apps next to Informatica
  • 12c release Developer jumpstart -> in 18 months

In the 12c release it will be easier to migrate from Informatica/Data Stage to ODI.
Furthermore Denis addressed the migration plans from OWB to ODI:

  • Currently there are no plans to come with a migration tool for OWB mappings to ODI interfaces
  • There will be no forced migration, but support will be discontiniud after the 12c database release

An import area is the costs of ODI versus OWB. OWB is a free product, but if you use certain options you still need to pay for the license.
This is called the EETL solution of OWB. A lot of customers aren’t aware of this and this makes the comparison between OWB and ODI a but unfair.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s


%d bloggers like this: