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

Tuesday, April 1st, 2014 by

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 going to focus just on […]

Data Integration Tips: ODI 12c – Substitution API GUIDs

Thursday, March 27th, 2014 by

With the release of Oracle Data Integrator 12c and Oracle GoldenGate 12c still fresh in our minds, I thought I would start an ongoing series focused on Data Integration Tips – specifically around the latest version of Oracle’s data integration tools. The goal is to provide insight into some of the hidden, undocumented, or lesser […]

Rittman Mead BI Forum 2014 Registration Now Open – Don’t Miss Out!

Tuesday, March 25th, 2014 by

Just a quick reminder to say that registration for the Rittman Mead BI Forum 2014 is now open, with the speaker and presentation list now up on the event website. As with previous years, the BI Forum runs in Brighton on the first week, and then moves over to Atlanta on the second, with the […]

Using Sqoop for Loading Oracle Data into Hadoop on the BigDataLite VM

Saturday, March 22nd, 2014 by

This is old-hat for most Hadoop veterans, but I’ve been meaning to note it on the blog for a while, for anyone who’s first encounter with Hadoop is Oracle’s BigDataLite VM. Most people looking to bring external data into Hadoop, do so through flat-file exports that they then import into HDFS, using the “hadoop fs” […]

Oracle Data Integrator 12c Patch – Missing Components

Wednesday, March 12th, 2014 by

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, “Making the Move from Oracle Warehouse […]

Website Design & Build: tymedia.co.uk