Michael Rainey

Michael is the Data Integration Lead at Rittman Mead and an Oracle ACE Director. His Oracle data integration expertise enables him to provide technical direction and leadership to the DI team.

📍 Pasco, WA

Oracle Data Integrator 12c: Getting Started - Developer's Quickstart

I’ve decided that it’s time for a refresher on Oracle Data Integrator 12c. This week in the “[Oracle Data Integrator 12c: Getting Started]( http://ritt.md/odi12c-getting-started" target="_blank)” series: getting a quick start on mapping development. Several objects must be created before a single bit of ETL

Oracle Data Integrator 12c: Getting Started - Installation and Configuration

I’ve decided that it’s time for a refresher on Oracle Data Integrator 12c. This week, I’m continuing the “[Oracle Data Integrator 12c: Getting Started]( http://ritt.md/odi12c-getting-started" target="_blank)” series with the next topic: Installation and Configuration. I don’t plan to dig into all of

Oracle Data Integrator 12c: Getting Started - Components and Architecture

I’ve decided that it’s time for a refresher on Oracle Data Integrator 12c. I’m writing a Getting Started series to help folks get interested in the product and maybe even teach a few old dogs (including myself) some new tricks. In my [last post](GHOST_URL/2016/

OTN Appreciation Day: Oracle Data Integrator 12c - Flexibility

As you may already know by now, it’s [OTN Appreciation Day]( https://oracle-base.com/blog/2016/09/28/otn-appreciation-day/" target="_blank)! The idea was thought up by Oracle ACE Director Tim Hall to give thanks to the Oracle Technical Network that we all love and use on a daily

Oracle Data Integrator 12c: Getting Started - What is ODI?

There is something about sharing stories with others about the technology you love that gets the blood flowing. I have written blog posts and articles, presented sessions at conferences, and recorded podcasts and tech tips about [Oracle Data Integrator]( http://www.oracle.com/technetwork/middleware/data-integrator/overview/index.html " target=

Rittman Mead Life

Rittman Mead at Oracle OpenWorld 2016

The big show is upon us and once again Rittman Mead will be actively participating at [Oracle OpenWorld 2016]( https://www.oracle.com/openworld/index.html" target="_blank). Oracle's premier conference runs September 18–22 at the Moscone Center in beautiful San Francisco, California. I'm looking forward to another great

Oracle Data Integrator: Upgrade to ODI 12c - A Case Study

We don’t often get a chance to share our customer success stories due to various reasons, such as required anonymity of the client or certain other legalities. But when we do, it sure feels great! Recently, Eurocontrol [www.eurocontrol.int] , a longtime Rittman Mead client in Brussels, Belgium, performed

Rittman Mead at KScope16

June is the perfect month: summer begins, major football [http://www.uefa.com/uefaeuro/] (andfutbol [http://www.ca2016.com/]) tournaments are in full swing, and of course, KScope16 [http://kscope16.com/] is on! Rittman Mead have participated in many of the past KScope conferences and will continue that tradition this

Data Integration Tips: ODI 12c – Who Changed My Table Names?

Data Integration Tips: ODI 12c – Who Changed My Table Names?

It’s Sunday night (well, technically Monday morning now), and we have just enough time for another one of my Data Integration Tips. This one, revolving around Oracle Data Integrator 12c, has been on my mind for some time now, so I figured we better just get it out there.

Data Integration Tips: Oracle Data Integrator 12c Password

Data Integration Tips: Oracle Data Integrator 12c Password

Hey, everyone. It's Sunday night, and we have just enough time for another Data Integration Tip from Rittman Mead. This one has originated from many years of Oracle Data Integrator experience—and a lost 12c password. Let me start first by stating there is never any blame placed when a

Rittman Mead at Collaborate 16: Data Integration Focus

It’s that time of year again when Oracle technologists from around the world gather in Las Vegas, Nevada, to teach, learn, and, of course, network with their peers. TheCollaborate 16 [http://collaborate.ioug.org/]conference, running for 10 years now, has been a collaboration, if you will, between the

Data Integration Tips: Oracle Data Integrator - Quotes in Variables

Data Integration Tips: Oracle Data Integrator - Quotes in Variables

It's Sunday night, and we havejust enough time for another quick Data Integration Tip from Rittman Mead. In another recent, yet somewhat trivial, challenge I ran into this week was the ability to pass quotations through to a Scenario as a part of an ODI 11g Variable (this is also

Data Integration Tips: ODI 12c Repository Query - Find the Mapping Target Table

Data Integration Tips: ODI 12c Repository Query - Find the Mapping Target Table

Well, it’s been awhile since I’ve posted one of our Rittman Mead Data Integration Tips, so I thought a recent challenge might be the next great candidate. I was working through the Kimball ETL Subsystems [http://www.kimballgroup.com/data-warehouse-business-intelligence-resources/kimball-techniques/etl-architecture-34-subsystems/] and the Error Event Schema, Subsystem

Kickstart Your 2016 with Rittman Mead's Data Integration Training

Happy Holidays and a Happy New Year to all! As you begin your 2016 this January, it’s time to start planning your team's data integration training. Look no further than Rittman Mead’s Oracle Data Integrator training course! We offer a 4 day Oracle Data Integrator 12c Bootcamp [http:

Practical Tips for Oracle BI Applications 11g Implementations

Practical Tips for Oracle BI Applications 11g Implementations

As with any product or technology, the more you use it the more you learn about the "right" way to do things. Some of my experiences implementing Oracle Business Intelligence Applications 11g have led me to compile a few tips that will improve the overall process for installation and configuration

Data Integration Tips: ODI 12.1.3 - Convert to Flow

Data Integration Tips: ODI 12.1.3 - Convert to Flow

The many who have already upgraded Oracle Data Integrator from the 11g version to 12c probably know about this great feature called “convert to flow". If not, well…here you go! First, a little background on why I think this is an excellent bit of functionality. The ODI Upgrade Assistant

Six Months an ACE…”Boy, that escalated quickly"

Boy, that escalated quickly [http://youtu.be/FONN-0uoTHI]. I mean, my path to becoming an Oracle ACE since joining Rittman Mead! When I began with Rittman Mead back in March 2012, I wasn't planning on joining the ACE program. In fact, I really wasn't sure what an Oracle ACE even

GoldenGate and Oracle Data Integrator - A Perfect Match in 12c... Part 4: Start Journalizing!

In this post, the finale of the four-part series "GoldenGate and Oracle Data Integrator - A Perfect Match in 12c", I'll walk through the setup of the ODI Models and start journalizing in "online" mode. This will utilize our customized JKM to build the GoldenGate parameter files based on the

GoldenGate and Oracle Data Integrator - A Perfect Match in 12c... Part 3: Setup Journalizing

After a short vacation, some exciting news [https://twitter.com/oracleace/status/476771642883203073], and a busy few weeks (including KScope14 in Seattle, WA [https://www.rittmanmead.com/blog/2014/06/rittman-mead-at-odtug-kscope14-seattle/]), it's time to get the "GoldenGate and Oracle Data Integrator - A Perfect Match in 12c" blog series rolling

Data Integration Tips: GoldenGate on RAC - Action Script for Windows

I want to briefly interrupt my blog series on GoldenGate and ODI - A Perfect Match in 12c... [https://www.rittmanmead.com/blog/2014/05/goldengate-odi-perfect-match-12c-1/] to provide another Data Integration Tip that was found during a recent client engagement. I was tasked with installing GoldenGate 11g into a 2-node

GoldenGate and Oracle Data Integrator - A Perfect Match in 12c... Part 2: Journalizing Knowledge Module

This is the second post in a blog series on the integration between Oracle Data Integrator (ODI) 12c and GoldenGate 12c. Thefirst post [https://www.rittmanmead.com/blog/2014/05/goldengate-odi-perfect-match-12c-1/] focused on the latest, yet-to-be-released, Oracle Information Management Reference Architecture and some high-level features new to the 12c versions

GoldenGate and Oracle Data Integrator - A Perfect Match in 12c... Part 1: Getting Started

Over the years, I've blogged quite a bit about integration between Oracle Data Integrator and GoldenGate, and how to make it all work with the Oracle Reference Architecture. With the release of the 12c versions of ODI [https://www.rittmanmead.com/blog/2013/10/oracle-data-integrator-12c-release-part-1/] and GoldenGate [https://www.rittmanmead.

Data Integration Tips: ODI 12c - Varchar2 (CHAR or BYTE)

Continuing with our Data Integration Tips series, here's one that applies to both Oracle Data Integrator 11g and 12c. This "tip" was actually discovered as a part of a larger issue involving GoldenGate, Oracle Datapump, and ODI. Maybe a future post will dive deeper into those challenges, but here I'm

Data Integration Tips: ODI 12c - Substitution API GUIDs

With the release of Oracle Data Integrator 12c [https://www.rittmanmead.com/blog/2013/10/oracle-data-integrator-12c-release-part-1/] and Oracle GoldenGate 12c [https://www.rittmanmead.com/blog/2013/10/oracle-goldengate-12c-new-release-new-features/] still fresh in our minds, I thought I would start an ongoing series focused on Data Integration Tips - specifically around the