Data Integration Tips: ODI – Use Scenarios in packages

Tuesday, February 10th, 2015 by

  Here is another question I often hear during ODI Bootcamp or I often read in the ODI Space on OTN : In a package, should I directly use mappings (or interfaces prior to 12c) or is it better to use the scenarios generated from these mappings? An ODI package is a workflow used to sequence the different steps of […]

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

Tuesday, December 30th, 2014 by

Yes, I’m hijacking the “Data Integration Tips” series of my colleague Michael Rainey (@mRainey) and I have no shame! DISCLAIMER This tip is intended for newcomers in the ODI world and is valid with all the versions of ODI. It’s nothing new, it has been posted by other authors on different blogs. But I see […]

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

Sunday, October 5th, 2014 by

An updated version of the Oracle BigDataLite VM 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, the SQL access layer over Hadoop that I covered on the blog a few months ago (here and here). […]

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

Thursday, July 10th, 2014 by

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 ODI Metadata and deploy them to both the source […]

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

Thursday, July 3rd, 2014 by

After a short vacation, some exciting news, and a busy few weeks (including KScope14 in Seattle, WA), it’s time to get the “GoldenGate and Oracle Data Integrator – A Perfect Match in 12c” blog series rolling again. Hopefully readers can find some time between World Cup matches to try integrating ODI and GoldenGate on their […]

Website Design & Build: tymedia.co.uk