Rittman Mead Blog - Oracle Warehouse Builder

New ODI12c Article, and Details of our Inaugural ODI12c Course in Brighton, May 12th-14th 2014

Oracle have just published the May/June 2014 edition of Oracle Magazine, and my business analytics column this time round is on the new 12c release of Oracle Data Integrator. In “Go with the Flow" I look at how this new editor supports OWB-style multi-step mappings, and how new

Technical

New OTN Article: Making the Move from Oracle Warehouse Builder to Oracle Data Integrator 12c

One of the reasons I've been silent on the blog lately regarding new Oracle Data Integrator 12c content (even though I promised it some months ago) is because I've been writing an article focused on migration options from Oracle Warehouse Builder (OWB). Published recently on OTN, this article hopefully helps

Technical

Oracle Data Integrator 12c release : Part 2

In the first part of this article, we discovered the new mappings and reusable mappings, the debugger and the support of OWB jobs in the freshly released ODI 12c. Let's continue to cover the new features in ODI 12c with the Weblogic Management Framework, the new component KMs and some

Technical

My Journey to ODI 12c

Most readers of this blog probably know me for my time spent with OBIEE (especially my work in repository development), but I'm guessing some of you long-time readers know that I grew up working with the Oracle Database. Many and many a year ago, I was a fledging Oracle DBA

Technical

Oracle Data Integrator 12c release : Part 1

That's it! The long awaited Oracle Data Integrator 12c is out! You can find the 12.1.2 version on the ODI Downloads page and discover the new features here while it gets downloaded. The main news is surely the new flow-based paradigm and the ability to load multiple targets

Oracle BI Suite EE

Oracle Openworld 2013 : Reflections on Product Announcements and Strategy

I'm sitting writing this at my desk back home, with a steaming mug of tea next to me and the kids pleased to see me after having been away for eight days (or at least my wifepleased to hand them over to me after looking after them for eight days)

Oracle BI Suite EE

Oracle Openworld 2013 Days 3 & 4 : Oracle Cloud, OBIEE and ODI Futures

It's getting to the end of day 4 of Oracle Openworld, with Team Oracle USA coming back from 8-1 down and pulling-off the unlikeliest of comeback victories, and Openworld sessions covering OBIEE, ODI and Oracle Cloud futures. Here's the details: 1) Oracle's Cloud Strategy Last year Oracle announced a number

Oracle BI Suite EE

An Oracle BI "Blast from the Past": Ten Products from Oracle's BI History You May Not Have Heard Of...

With Oracle BI Enterprise Edition, the BI Apps and Hyperion EPM Suite, Oracle have a set of reporting and analysis tools that can be considered "best of breed" and compete with any other tool on the market. Coupled with the Oracle database, the engineered systems strategy and the Fusion Apps/

Technical

Oracle Data Integrator Designer for OWB Developers

Last time I described some of the aspects of ODI Topology. I only touched the surface of this subject and mainly kept to database sources; if you attend one of the Rittman Mead ODI bootcamps (we have public versions of the ODI course coming up in Australia, India, USA and

Technical

Oracle Data Integrator Topologies for OWB Developers

Back in October of 2011 I posted the first part of a series of blogs that aimed to describe some of the key features of Oracle Data Integrator (ODI) from the point of view of an ETL developer who already knows Oracle Warehouse Builder (OWB). The blog series was themed

Technical

Oracle Warehouse Builder and Data Integrator

Sometimes, when I am working with customers on data warehousing projects I am asked questions about Oracle Warehouse Builder and its future. I know no more on this than what I read in Oracle's reposted a statement of direction from May 2011 and recent internet postings elsewhere which states that

Oracle BI Suite EE

Real-time BI: EDW with a Real-time Component

I apologize for the long delay in getting this last portion of the Real-time discussion in place. Since I wrote the first two installments, we've had the BI Forum (US and UK versions), plus a flurry of activity around Rittman Mead in the US, followed up by KScope11. But a

Business Insights

Real-time BI: Federated OLTP/EDW Reporting

The typical approach in Federated OLTP/EDW reporting environments is to use a BI tool such as OBIEE to do horizontal federation. This means combining data from multiple sources at the same grain in a single logical table. One note of clarification: my use of the word "federated"

Oracle BI Suite EE

Real-time BI: An Introduction

Discussing real-time data warehousing is difficult because the meaning of real-time is dependent on context. A CIO of an organization that has weekly batch refresh processes might view an up-to-the-day dashboard as real-time, while another organization that already has daily refresh cycles might be looking for something closer to up-to-the-hour.

Technical

The One Mapping Paradigm

Here at Rittman Mead we have been working on some new methodology and design patterns for ETL. We have long realised that the bottleneck in Business Intelligence and Data Warehousing projects is ETL, so we have been prototyping new techniques to approaching this and trialling them at client's sites. Taking

Oracle BI Suite EE

Looking forward to RMOUG

I'm currently on a plane headed to Denver for the annual RMOUG Training Days conference. This is my second year speaking at RMOUG, which is the largest regional Oracle user group conference in the country (or so they tell me). RMOUG always has a strong database and DBA slant to

Technical

Transcend Part 2: Dimensions

In the last post, I described the concept of a "Mapping" entity in Transcend as a bundling of pre- and post-mapping processes that can be executed with a single call. The "Dimension" entity is very similar. In fact, in strict programming terms (for those of you

Technical

Transcend Part 1: Mappings

If you read the blog regularly, then you know that Rittman Mead offers a product called Transcend that is designed to interact with the Oracle Database to make some of the heavy-lifting in ETL mappings very simple. Because we recently released version 2.5 of Transcend, I thought I'd talk

Oracle BI Suite EE

Kaleidoscope is a Wrap

Every year, ODTUG shows why Kaleidoscope is the premier conference for the technical hacks in all of us. I can't remember a time when I learned so much, had so many great conversations, and felt more at home than this year. The content was spectacular across the board, and even

Technical

Wrapping up Collaborate 10

It's been a fun week in good old Las Vegas. Though in the end I broke even at the tables, I enjoyed holding a large amount of the Mandalay Bay's money for them for two or three days, just to give it all back to them last night before leaving.

Technical

Collaborate 10 - The Early Days

One of the things I had expected to do this week was to write about some of my BI and DW highlights from Collaborate 10. However, that is not to be. I am currently sitting at home in the UK, a victim of a cloud of volcanic ash that has

Technical

Oracle Warehouse Builder 11gR2 - Using Code Templates - Loading Metadata from Essbase to Relational Tables - Part 2

In the first part of this series here, i had shown how to go about using the ODI RKM's from within Warehouse Builder to reverse engineer Essbase metadata. Though i did promise to come back sooner on the rest of the series, a client engagement completely held me away from

Technical

Oracle Warehouse Builder 11gR2 – Importing Essbase Cubes using ODI Knowledge Modules – Part 1

One of the new features introduced in OWB 11gR2 is the ability to import metadata objects through JDBC drivers. So, as long as we have an external API providing the JDBC interface to OWB, OWB should be able to leverage that and import the metadata through the API. For example,

Technical

Oracle 11g Pivot

One of the things that I often come across is the "up-dateable fact", that is a fact that starts life "incomplete" and changes overtime. Examples include things such as support calls that start life as "open" then progress through "responded", "resolved&

Technical

Atlanta BI Users Group Meeting

Rittman Mead is proud to announce our sponsorship of the February meeting of the Atlanta BI Users Group, a regional special interest group with involvement from IOUG, ODTUG the IOUG BIWA SIG, and the Georgia Oracle Users Group (GOUSER). I'd like to thank Greg Lancaster and the entire BI team