Rittman Mead Blog - Oracle Data Integrator (ODI)

Introducing Oracle Enterprise Data Quality

Visually, BI dashboards and analyses can be impressive and appear to meet the user’s needs, but if the data displayed on the dashboards isn't reliable or correct then those same users can quickly lose faith in what they contain. Therefore, it’s important that assessing and managing

Technical

Public training schedule for 2012-H2 announced

Rittman Mead offer training courses at centres in Brighton UK, Atlanta GA, Bengaluru India, and Melbourne Australia. These courses are our standard, "bootcamp" courses, five days in length, and is typically taught by consultants such as Mark Rittman, Robin Moffatt, Stewart Bryson, Ashley Beauman and Venkatakrishnan J. If

Technical

Oracle Data Integrator 11g Groovy: Add Columns to a Datastore

One of the great new features in Oracle Data Integrator 11.1.1.6 is the integration of the scripting language Groovy right within the ODI user interface. David Allan has written several blog posts on the subject, showing how easy it is to create a project and describing how

Technical

Extreme BI: Capturing Change with Oracle GoldenGate and ODI: Part 2 (Implementation)

In my previous post [https://www.rittmanmead.com/blog/2012/04/capturing-change-goldengate-odi-intro], I provided an introduction to the Extreme BI approach to change data capture from Source → Staging Layer and Source → Foundation Layer. I described the Oracle Next-Generation Reference DW Architecture and how we plan to implement an appropriate solution

Technical

Extreme BI: Capturing Change with Oracle GoldenGate and ODI : Part 1 (Introduction)

Before I jump into the first of two posts discussing change data capture with Oracle GoldenGate and Oracle Data Integrator 11g, I would like to first introduce myself. My name is Michael Rainey and I am the newest member of the Rittman Mead America team, joining just last month as

Technical

Oracle Data Integrator Designer for OWB Developers

Last time [https://www.rittmanmead.com/blog/2012/03/oracle-data-integrator-topologies-for-owb-developers/] 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 [http://www.rittmanmead.com/training/] (we have

Technical

Oracle Data Integrator Topologies for OWB Developers

Back in October of 2011 I posted [https://www.rittmanmead.com/blog/2011/10/oracle-warehouse-builder-and-data-integrator/] 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

Oracle BI Suite EE

BI EE 11.1.1.5 - Calling BI EE 11g Agents through Oracle Data Integrator 11g

I was asked recently to come out with a way of calling BI EE 11g agents directly from Oracle Data Integrator 11g. There are many ways of accomplishing this. I thought i will write a quick blog post about the various possible solutions and more importantly get back to blogging

Business Insights

Looking Back at 2011, Looking forward to 2012

Well it's the last working day now before the end of 2011, and so I thought it'd be interesting to take a look back at the events of 2011, and a bit of think-forward as to what's on the horizon for 2012. As usual,

Rittman Mead Life

Rittman Mead Scheduled OBIEE11g, ODI11g and OBIA7.9.6.3 Courses

When Jon Mead and I started Rittman Mead back in 2007, one of the first services we offered was training [http://www.rittmanmead.com/training], back in those days on OWB and OBIEE 10g and typically delivered by myself, Jon, Borkur at Peter Scott. Since then, we've grown

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 [http://www.oracle.com/technetwork/middleware/data-integrator/overview/sod-1-134268.pdf] a statement of

Oracle BI Suite EE

What Skills Does an Oracle BI Developer Need in 2011?

Back in 2009, I wrote a blog post entitled "What Skills Does an Oracle BI Developer Need in 2009" [http://www.rittmanmead.com/blog/2009/03/what-skills-does-an-oracle-bi-developer-need-in-2009/] . At the time, OBIEE 11g was in the planning stage, Oracle had recently acquired Hyperion and so Essbase and Planning were

Technical

ODI 11g New Mapping and Interface Features - Part 3 - OBIEE Lineage

In the first two parts of this min-series, I looked at the new mapping and interface features with ODI 11.1.1.3 [https://www.rittmanmead.com/blog/2011/06/odi-11g-new-mapping-and-interface-features-part-1/], and yesterday I took a look at Load Plans [https://www.rittmanmead.com/blog/2011/06/odi-11g-new-mapping-and-interface-features-part-2-load-plans/] , a new

Technical

ODI 11g New Mapping and Interface Features - Part 2 - Load Plans

Yesterday I posted on the blog an overview of some of the new interface (mapping) features in the original, 11.1.1.3 release of Oracle Data Integrator 11g [https://www.rittmanmead.com/blog/2011/06/odi-11g-new-mapping-and-interface-features-part-1/]. In today's posting, I'm going to look at the

Technical

ODI 11g New Mapping and Interface Features - Part 1

About a year or so ago I posted an entry on this blog highlighting the new architectural features of Oracle Data Integrator 11g [http://www.rittmanmead.com/blog/2010/09/odi-11g-now-available-for-download/]. At the time, I talked about the new user interface, integration with WebLogic Server and Enterprise Manager, and how

Technical

Not The Only 11.1.1.5.0 In Town

Just a short posting to mention that earlier this month Oracle released version 11.1.1.5.0 of Data Integrator Look out for more Rittman Mead postings on ODI over the coming months

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

Technical

Moving Data

I just looked at the Rittman Mead Blog archive and saw the last post that was written by me was back in August 2010! Where has the time gone? Some of the time has been spent preparing and giving conference and user group talks, (as I write this I am

Oracle BI Suite EE

Oracle BI EE 11g & ODI 11g - BI Knowledge Modules & SELECT_PHYSICAL

As mentioned in my blog post here [https://www.rittmanmead.com/blog/2010/08/oracle-bi-ee-11g-new-bi-server-functions/], one of the new features of BI EE 11g is the ability to connect directly to the Physical Layer of the Repository using the SELECT_PHYSICAL property. This opens up quite a lot of integration

Technical

Transcend Part 2: Dimensions

In the last post [https://www.rittmanmead.com/blog/2010/12/01/transcend-part-1-mappings/], 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

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'

Technical

Configuring ODI 10.1.3.6 to use Oracle Golden Gate for Changed Data Capture

If you've an interest in Oracle data warehousing and ETL, you'll probably have noticed the recent announcements around the Oracle acquisition of Golden Gate [http://www.oracle.com/goldengate/index.html]. Golden Gate were a company that produced a cross-platform data replication and changed data capture

Technical

UKOUG Tech and EBS Conference, Day 1

I'm now back in my hotel room, having escaped from the Focus Pubs at the end of Day 1 of the UKOUG Technology and E-Business Suite Conference in Birmingham. It's been a long day, with an 8am meeting on the stand in the exhibition, a stint

Technical

YouTube Video of my "Oracle BI Apps 7.9.5.2 and ODI" Open World Presentation

If you didn't make it to Open World but you were interested in my presentation on ODI and the Oracle BI Applications 7.9.5.2, I just noticed that "aortabisolutions" on Youtube recorded some of the highlights and uploaded the video [http://www.youtube.com/

Technical

Code Templates in OWB11gR2 Part 3 : Hybrid Code Template Mappings

If you've read my previous postings on how OWB11gR2 support access to non-Oracle databases [https://www.rittmanmead.com/blog/2009/09/21/code-templates-in-owb11gr2-part-1-introduction-and-support-for-heterogeneous-databases/] , and allows you to create mappings that use non-Oracle sources and targets [https://www.rittmanmead.com/blog/2009/09/21/code-templates-in-owb11gr2-part-2-introduction-to-code-template-mappings/] , you may we wondering