Rittman Mead Blog - Oracle Data Integrator (ODI)

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 [http://www.bbc.co.uk/sport/0/sailing/24274103], and Openworld sessions covering OBIEE, ODI and Oracle Cloud futures. Here'

Technical

Diving Deeper into BI Apps 11.1.1.7.1 use of ODI11g for Data Loading

A few months ago I posted a series of articles on the new BI Apps 11.1.1.7.1 release [http://www.rittmanmead.com/biapps11g/], which used ODI11g in the background to perform data loads, rather than Informatica PowerCenter. Since then, I've collaborated with Accenture's

Technical

New OTN Article: Installing and Configuring Oracle BI Apps 11.1.1.7.1

A few months ago I posted a series of articles [https://www.rittmanmead.com/blog/2013/05/introduction-to-the-bi-apps-11-1-1-7-1-release-overview/] on our blog about the new 11.1.1.7.1 release of the BI Applications [http://www.rittmanmead.com/biapps11g/], focusing on the new ODI 11g-based architecture and its supporting utilities.

Technical

GoldenGate and Oracle Data Integrator - A Perfect Match... Part 3: Real-time ETL Challenges

I've finally had the chance to sit down and properly closeout this series on GoldenGate and Oracle Data Integrator. Since the last post, I’ve actually presented this topic on three different occasions. Once at each of the Rittman Mead BI Forums [https://www.rittmanmead.com/blog/2013/

Oracle BI Suite EE

Rittman Mead BI Masterclass Tour: India, October 2013- Register Now!

I'm very pleased to announce a one-off Rittman Mead BI Masterclass Tour [http://www.rittmanmead.com/indiabimasterclass2013/] that we're organising, in partnership with ODTUG, to take place in India in October 2013. Along with the US and UK, India has the largest amount of readers of

Oracle BI Suite EE

The Rittman Mead scripts github repository

Here at RittmanMead we’re big fans of working smarter, not harder. One of the ways we do this is not re-inventing the wheel. There’s only so many ways that products such as OBI and ODI can be implemented, and we’ve probably seen most of them. The corollary

Oracle BI Suite EE

Photos and Presentation Downloads from the Rittman Mead BI Forum 2013, Brighton & Atlanta

Well, we're all back home now after two very successful Rittman Mead BI Forum events [http://www.rittmanmead.com/biforum2013] in Brighton [http://www.rittmanmead.com/blog/2013/05/previewing-the-brighton-bi-forum-2013/] , and then Atlanta [http://www.rittmanmead.com/blog/2013/05/agenda-and-details-for-the-atlanta-rm-bi-forum-2013/] , earlier this month in May 2013. Around

Technical

Introduction to the BI Apps 11.1.1.7.1 - Use of ODI11g for ETL

In the two previous postings in this series on the Oracle BI Apps 11.1.1.7.1, we looked at the release at a high-level [http://www.rittmanmead.com/blog/2013/05/introduction-to-the-bi-apps-11-1-1-7-1-release-overview/] , and then at the product architecture including the new configuration and functional setup tools [http://www.

Oracle BI Suite EE

Introduction to the BI Apps 11.1.1.7.1 - Product Architecture & New Configuration Tools

In my previous posting in this series [http://www.rittmanmead.com/blog/2013/05/introduction-to-the-bi-apps-11-1-1-7-1-release-overview/] , I looked at the new 11.1.1..7.1 release of the Oracle BI Applications at a high-level, and talked about how this new release uses ODI as the embedded ETL tool instead of

Oracle BI Suite EE

Introduction to the BI Apps 11.1.1.7.1 - Release Overview

The long-awaited and anticipated 11.1.1.7.1 (PS1) release of the Oracle BI Applications became available early last week, with thesoftware [http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bus-intelligence-11g-165436.html] anddocumentation [http://www.oracle.com/technetwork/middleware/bi-foundation/documentation/bi-apps-098545.html] available for download on OTN. Over

Oracle BI Suite EE

Agenda and Details for the Brighton RM BI Forum 2013

It's Tuesday morning, and later today delegates will be starting to arrive in Brighton for the 5th Annual Rittman Mead BI Forum [http://www.rittmanmead.com/biforum2013], running again at the Hotel Seattle [http://www.hotelseattlebrighton.com] down at Brighton Marina. Around seventy of Europe's most

Technical

Previewing the BI Forum 2013 Data Integration Masterclass

I guess it's a British thing to not blow our own trumpet (does that translate the same over in the US?), but something I'm particularly proud about with the upcoming Rittman Mead BI Forum 2013 events [http://www.rittmanmead.com/biforum2013] is our Oracle Data Integration

Oracle BI Suite EE

OBIEE, ODI and Hadoop Part 4: Hive Data Transformation & Integration via ODI 11g

In the previous three articles in this series (and well done for everyone that's still with us), we looked at how OBIEE 11.1.1.7 and ODI 11.1.1.6+ can access Hadoop data sources [https://www.rittmanmead.com/blog/2013/04/obiee-odi-and-hadoop-part-1-so-what-is-hadoop-mapreduce-and-hive/] via a related

Oracle BI Suite EE

OBIEE, ODI and Hadoop Part 3: A Closer Look at Hive, HFDS and Cloudera CDH3

In the first two parts in this series, I looked at the recently-added support for Apache Hadoop as a data source for OBIEE 11.1.1.7 and ODI 11.1.1.6 [https://www.rittmanmead.com/blog/2013/04/obiee-odi-and-hadoop-part-1-so-what-is-hadoop-mapreduce-and-hive/] , and explained how the Hadoop support was really enabled

Technical

OBIEE, ODI and Hadoop Part 1: So What Is Hadoop, MapReduce and Hive?

Recent releases of OBIEE and ODI have included support for Apache Hadoop [http://hadoop.apache.org] as a data source, probably the most well-recognised technology within the "big data" [http://www.oracle.com/us/technologies/big-data/index.html] movement. Most OBIEE and ODI developers have probably heard of

Technical

GoldenGate and Oracle Data Integrator - A Perfect Match... Part 2: Replicate to Staging and Foundation

It has been quite a hectic month since my last post, GoldenGate and Oracle Data Integrator – A Perfect Match Part 1: Introduction [https://www.rittmanmead.com/blog/2013/02/goldengate-and-oracle-data-integrator-a-perfect-match-part-1/] . Plenty of client work and delivery of two ODI 11g Bootcamp training [http://www.rittmanmead.com/training/trn-403-odi-11g-bootcamp/] courses have

Technical

GoldenGate and Oracle Data Integrator - A Perfect Match... Part 1: Introduction

Last week, I was in Denver, Colorado presenting at the Rocky Mountain Oracle Users Group Training Days conference. This was my first time at the RMOUG [http://www.rmoug.org/] conference and I have to say, with the number of great topics being presented during any given session time, I

Technical

Rittman Mead BI Forum 2013 Call for Papers now Open!

I'm pleased to announce that the call for papers for the 5th annual Rittman Mead BI Forum is now open, with abstracts being accepted through to January 31st, 2013. Last year's BI Forum was the biggest and best ever, running in Brighton, UK and Atlanta, GA

Technical

ODI11g in the Enterprise Part 2 : Data Integration using Essbase, Messaging, and Big Data Sources and Targets

In this five part series over the Christmas break, I'm taking a look at some of the lesser-known features in Oracle Data Integrator 11g, focusing on "enterprise" features such as build automation, scripting, data quality and middleware integration. If you've arrived at this post

Technical

ODI11g in the Enterprise Part 1: Beyond Data Warehouse Table Loading

Most developers who've used Oracle Data Integrator [http://www.oracle.com/technetwork/middleware/data-integrator/overview/index.html] in the past have used it to load data warehouse tables, typically from an Oracle or other relational source into a set of dimensional Oracle target tables. Some source data might

Technical

Oracle ACE Directors Nordic Tour 2012 : Venues and BI Presentations

Next week I'm honoured to be taking part in the Oracle ACE Directors Nordic Tour, taking in Copenhagen, Stockholm, Oslo and Helsinki over four days. Organized by Heli Helskyaho (Finnish Oracle Users Group) and Sten Vesterli (Danish Oracle Users Group) along with the leaders of the Norwegian and

Technical

Oracle Exalytics, Oracle R Enterprise and Endeca Part 3 : Flight Delays Analysis using OBIEE, Endeca and Oracle R Enterprise on Exalytics

So far in this series we've looked at Oracle's BI, Big Data and Advanced Analytics strategy and seen how Exalytics can benefit both Endeca Information Discovery and Oracle R Enterprise through its 40 CPU cores and 1TB of RAM. For a recap on the two earlier

Technical

Oracle Exalytics, Oracle R Enterprise and Endeca Part 2 : Oracle Endeca, the Advanced Analytics Option and Oracle Exalytics

In this week of postings we're going to look at Oracle Exalytics and how it enables "big data" and unstructured data analytics, using Oracle Endeca, Oracle Exadata, Oracle Big Data Appliance and the Oracle Database Advanced Analytics option. In case you've arrived via a

Technical

Oracle Exalytics, Oracle R Enterprise and Endeca Part 1 : Oracle's Analytics, Engineered Systems, and Big Data Strategy

One of the presentations Rittman Mead gave at last week's Oracle Openworld [http://www.rittmanmead.com/openworld2012/] was entitled "High Speed, Big Data Analysis using Oracle Exalytics" [http://www.rittmanmead.com/files/oow2012_rittman_exalytics_big_data.pdf][PDF]. Although it was the last of my

Technical

BI, Data Warehousing and Data Integration News from Oracle Openworld 2012

This week is Oracle Openworld week in San Francisco, USA [http://www.oracle.com/openworld], with around 50,000 attendees attending Openworld itself, Java One and fringe events such as Oaktable world. Rittman Mead have had ten sessions during the week, covering topics such as OBIEE, Endeca, data warehousing, Essbase