Rittman Mead Blog

Rittman Mead at Kscope 2017

Rittman Mead will be well represented in San Antonio, Texas next week for Kscope 17 with some of our best from both sides of the Atlantic! Our very own Francesco Tisiot and Jordan Meyer will present various topics as well as participate in the conference events. Also, the newly named

odi12c

Accelerating Your ODI Implementation, Rittman Mead Style

Introduction Over the years, at Rittman Mead, we've built up quite a collection of tooling for ODI. We have accelerators, scripts, reports, templates and even entire frameworks at our disposal for when the right use case arises. Many of these tools exploit the power of the excellent ODI SDK to

training

What's new in Training in 2017?

2016 - Thank you for a great year! Rittman Mead would like to thank everyone that attended or showed an interest in our Training courses in 2016. Since we started back in 2007, Training has been a mainstay of our service offerings. My personal opinion is that Q3 & Q4 saw

odi12c

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

odi12c

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

Creating Security Profiles in ODI 12c

As a newcomer to ODI I enjoy hearing from the more seasoned veterans about common situations they encounter on projects. One of these recurring situations (especially if the company has a very small dev team) is the lack of security. I will not discuss how Oracle improved security by usingpublic/

OOW16

Oracle OpenWorld 2016 - Data Integration Recap

I know it's been about a month since Oracle OpenWorld 2016 concluded, but I wanted to give a brief recap on a few things that I thought were interesting in the data integration space. During the week prior to OpenWorld, I had the privilege to attend the Oracle ACE Director

odi12c

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/

odi12c

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

odi12c

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

odi12c

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

Technical

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.

Technical

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

Technical

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

Technical

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

Technical

Oracle Data Integrator to load Oracle BICS and Oracle Storage Cloud Service

It is known that Oracle focuses its sales on cloud this year and in the BI world, we have seen the introduction of Oracle Business Intelligence Cloud Service [https://cloud.oracle.com/business_intelligence] – BICS – that we already covered on the blog [http://www.rittmanmead.com/tag/bics/]. Another great

Technical

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

Big Data

Oracle Data Integrator Enterprise Edition Advanced Big Data Option Part 1- Overview and 12.1.3.0.1 install

Oracle recently announced Oracle Data Integrator Enterprise Edition Advanced Big Data Options [https://www.oracle.com/middleware/data-integration/enterprise-edition-big-data/index.html] as part of the new 12.1.3.0.1 release of ODI. It includes various great new functionalities to work on an Hadoop ecosystem. Let's have a look

Technical

Data Integration Tips: ODI - Use Scenarios in packages

Here is another question I often hear during ODI Bootcamp [http://www.rittmanmead.com/training/training-trn405-oracle-data-integrator-12c-bootcamp/] or I often read in the ODI Space on OTN [https://community.oracle.com/community/business_intelligence/system_management_and_integration/data_integrator/] : In a package, should I directly use mappings (or interfaces prior

Technical

Data Integration Tips: ODI - One Data Server with several Physical Schemas

Yes, I'm hijacking the "Data Integration Tips" series [http://www.rittmanmead.com/tag/data-integration-tips/] of my colleague Michael Rainey [http://www.rittmanmead.com/author/michael-rainey/] (@mRainey [https://twitter.com/mRainey]) and I have no shame! DISCLAIMER This tip is intended for newcomers in the ODI world and is valid with

Technical

Adding Oracle Big Data SQL to ODI12c to Enhance Hive Data Transformations

An updated version of the Oracle BigDataLite VM [http://www.oracle.com/technetwork/database/bigdata-appliance/oracle-bigdatalite-2104726.html] came out a couple of weeks ago, and as well as updating the core Cloudera CDH software to the latest release it also included Oracle Big Data SQL [http://www.oracle.com/us/

Technical

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

Technical

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

Technical

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