Michael Rainey - Rittman Mead (Page 2)

Oracle Data Integrator 12c Patch - Missing Components

While working with a client this week, I came across an interesting issue, and ultimately a workaround, when patching Oracle Data Integrator 12c. But first, a little background... The client was working through the OWB to ODI 12c migration process, detailed nicely by Stewart Bryson in his OTN article, "

Technical

Oracle BI Apps 11.1.1.7.1 – GoldenGate Integration - Part 4: Initial Load and Replication

This is the final post in my series on Oracle BI Apps 11.1.1.7.1 and GoldenGate Integration. If you have been following along up to this point, we have the Source Dependent Data Store schema setup and ready to accept data from the OLTP source via replication,

Technical

Oracle BI Apps 11.1.1.7.1 – GoldenGate Integration - Part 3: SDS and Parameter File Setup

This is the third post in the four part series on Oracle BI Applications 11.1.1.7.1 and Oracle GoldenGate 11g. Last time, we made it through the initial setup of GoldenGate and created the necessary schemas for the Source Dependent Data Store (SDS) and GoldenGate on the

Technical

Oracle GoldenGate 12c - New Release, New Features

The latest release of Oracle's data replication tool, GoldenGate 12c, has many improvements. The release coincided with the Oracle Data Integrator 12c release [https://www.rittmanmead.com/blog/2013/10/oracle-data-integrator-12c-release-part-1/] - and I wasn't about to let my colleague Jérôme Françoisse [https://twitter.com/JeromeFr]

Technical

Oracle BI Apps 11.1.1.7.1 – GoldenGate Integration - Part 2: Setup and Configuration

In my previous post, I introduced the steps necessary for integrating Oracle BI Applications 11.1.1.7.1 and GoldenGate (OGG). Now, I'm going to dive into the details and describe how to complete the setup and configuration of GoldenGate and the Source Dependent Data Store schema.

Technical

Oracle BI Apps 11.1.1.7.1 – GoldenGate Integration - Part 1: Introduction

The release of Oracle Business Intelligence Applications 11.1.1.7.1 [http://www.oracle.com/technetwork/middleware/bi-applications/overview/default-458073.html] includes a major change in components, with Oracle Data Integrator replacing Informatica as the ETL application. The next logical step was to integrate Oracle’s data replication tool,

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/

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

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