Rittman Mead Blog - Oracle Data Integrator (ODI)

How We Deliver Agile OBIEE Projects - Introducing ExtremeBI

Most OBIEE projects that we see are delivered through some sort of “waterfall” method, where requirements are defined up-front, there’s several stages of development, one or more major releases at the end, and any revision to requirements takes the form of a change request. These work well where requirements

Technical

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:

Technical

RM BI Forum 2014 Brighton is a Wrap - Now on to Atlanta!

I’m writing this sitting in my hotel room in Atlanta, having flown over from the UK on Saturday following the end of the Rittman Mead BI Forum 2014 [http://www.rittmanmead.com/biforum2014] in Brighton. I think it’s probably true to say that this year was our best

Technical

New ODI12c Article, and Details of our Inaugural ODI12c Course in Brighton, May 12th-14th 2014

[http://www.oracle.com/technetwork/issue-archive/2014/14-may/o34ba-2193422.html] Oracle have just published the May/June 2014 edition of Oracle Magazine [http://www.oracle.com/technetwork/issue-archive/2014/14-may/index.html], and my business analytics column this time round is on the new 12c release of Oracle Data Integrator.

Technical

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

Technical

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

Technical

Rittman Mead BI Forum 2014 Registration Now Open - Don't Miss Out!

Just a quick reminder to say that registration for the Rittman Mead BI Forum 2014 [http://www.rittmanmead.com/biforum2014] 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

Technical

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

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 [https://www.rittmanmead.com/blog/2014/01/oracle-bigdatalite-vm-now-available-for-download-on-otn/] . Most people looking to bring external data into

Technical

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 Enterprise Data Quality Revisited

Recently I have be working with Oracle Enterprise Data Quality (EDQ) combined with Oracle Data Integrator (ODI), we will tell you more about exactly what we have been doing in another blog, but for now I would like to revisit our earlier EDQ blogs. I am going to keep to

Oracle BI Suite EE

Rittman Mead BI Forum 2014 Now Open for Registration!

I’m very pleased to announce that the Rittman Mead BI Forum 2014 running in Brighton and Atlanta, May 2014, is now open for registration [http://www.rittmanmead.com/biforum2014/]. Keeping the format as before - a single stream at each event, world-class speakers and expert-level presentations, and a strictly-limited

Oracle BI Suite EE

Rittman Mead BI Forum 2014 Abstract Scoring Now Live - For 1 Week Only!

The call for papers for the Rittman Mead BI Forum 2014 closed at the end of January, and we’ve had some excellent submissions on topics ranging from OBIEE, Visualizations and data discovery through to in-memory analytics, big data and data integration. As always, we’re now opening up the

Technical

New OTN Article: Making the Move from Oracle Warehouse Builder to Oracle Data Integrator 12c

One of the reasons I've been silent on the blog lately regarding new Oracle Data Integrator 12c content (even though I promised it some months ago [https://www.rittmanmead.com/blog/2013/10/odi-12c-journey/]) is because I've been writing an article focused on migration options from

Oracle BI Suite EE

Rittman Mead BI Forum 2014 Call for Papers Closing Soon - And News on This Year's Masterclass

Its a couple of days to go until the call for papers for the Rittman Mead BI Forum 2014 closes [https://docs.google.com/a/rittmanmead.com/spreadsheet/viewform?formkey=dEdBdDNJb0JUTVBrNTJhaS00MmFjRXc6MA] , with suggested topics this year including OBIEE (of course), Essbase, Endeca, Big Data, Visualizations, In-Memory analysis and data integration.

Technical

Looking at the ODI12c Hadoop Demos in the New Oracle BigDataLite VM

In a post earlier today on the blog I took a look at the new Oracle BigDataLite virtual machine [http://www.rittmanmead.com/blog/2014/01/oracle-bigdatalite-vm-now-available-for-download-on-otn/] that’s now downloadable from OTN, and walked-through some of the Cloudera Hadoop tools that come with the VM. At the end of

Technical

Thoughts on ETL in the Cloud

In a few week’s time I’m presenting at the BIWA Summit 2014 [http://www.biwasummit.com] on running OBIEE in the Cloud, with the idea being that I’ll go through the various options for deploying OBIEE in public clouds, including Amazon EC2 and Oracle’s own cloud

Oracle BI Suite EE

Rittman Mead BI Forum 2014 Call for Papers Now Open!

It’s that time of year again when we start planning out next year’s BI Forum, which like this year’s event will be running in May 2014 in Brighton and Atlanta. This will be our sixth annual event, and as with previous year’s the most important part

Technical

Rittman Mead Video Interview on ODI12c New Features

If you’re a user of Oracle’s data integration products, you’re probably aware that ODI12c came out last month, with some of the new features covered in posts on the blog here [http://www.rittmanmead.com/blog/2013/10/oracle-data-integrator-12c-release-part-1/] , here [http://www.rittmanmead.com/blog/2013/11/

Oracle BI Suite EE

Thoughts on Running OBIEE in the Cloud : Part 2 - Data Sources and ETL

In yesterday’s post on running OBIEE in the cloud [https://www.rittmanmead.com/blog/2013/11/thoughts-on-running-obiee-in-the-cloud-part-1-the-bi-platform/] , I looked at a number of options for hosting the actual OBIEE element; hosting it in a public cloud service such as Amazon EC2, using Oracle’s upcoming BI-as-a-Service offering, or partner

Oracle BI Suite EE

Why ODI, DW and OBIEE Developers Should Be Interested in Hadoop

Over the past few months I’ve been posting a number of articles about Hadoop, and how you can connect to it from ODI and OBIEE. From an ODI perspective, I covered Hadoop as one of a number of new data sources ODI11g could connect to [https://www.rittmanmead.com/

Technical

Oracle Data Integrator 12c release : Part 2

In the first part of this article [https://www.rittmanmead.com/blog/2013/10/oracle-data-integrator-12c-release-part-1], we discovered the new mappings and reusable mappings, the debugger and the support of OWB jobs in the freshly released ODI 12c. Let's continue to cover the new features in ODI 12c with

Technical

My Journey to ODI 12c

Most readers of this blog probably know me for my time spent with OBIEE (especially my work in repository development), but I'm guessing some of you long-time readers know that I grew up working with the Oracle Database. Many and many a year ago, I was a fledging

Oracle BI Suite EE

Rittman Mead / ODTUG India BI Masterclass Tour Roundup

Over the past week Venkat, myself and the Rittman Mead India team have been running a series of BI Masterclasses [http://www.rittmanmead.com/indiabimasterclass2013/] at locations in India, in conjunction with ODTUG, the Oracle Development Tools User Group. Starting off in Bangalore, then traveling to Hyderabad and Mumbai, we

Technical

Oracle Data Integrator 12c release : Part 1

That's it! The long awaited Oracle Data Integrator 12c is out! You can find the 12.1.2 version on the ODI Downloads [http://www.oracle.com/technetwork/middleware/data-integrator/downloads/index.html] page and discover the new features here while it gets downloaded. The main news is

Oracle BI Suite EE

Oracle Openworld 2013 : Reflections on Product Announcements and Strategy

I'm sitting writing this at my desk back home, with a steaming mug of tea next to me and the kids pleased to see me after having been away for eight days (or at least my wifepleased to hand them over to me after looking after them for