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 […]

OBIEE and ODI on Hadoop : Next-Generation Initiatives To Improve Hive Performance

Thursday, December 18th, 2014 by

The other week I posted a three-part series (part 1, part 2 and part 3) on going beyond MapReduce for Hadoop-based ETL, where I looked at a typical Apache Pig dataflow-style ETL process and showed how Apache Tez and Apache Spark can potentially make these processes run faster and make better use of in-memory processing. […]

Rittman Mead BI Forum 2015 Call for Papers Now Open!

Wednesday, December 17th, 2014 by

I’m very pleased to announce that the Call for Papers for the Rittman Mead BI Forum 2015 is now open, with abstract submissions open to January 18th 2015. As in previous years the BI Forum will run over consecutive weeks in Brighton, UK and Atlanta, GA, with the provisional dates and venues as below: Brighton, […]

Going Beyond MapReduce for Hadoop ETL Pt.1 : Why MapReduce Is Only for Batch Processing

Sunday, December 7th, 2014 by

Over the previous few months I’ve been looking at the various ways you can load data into Hadoop, process it and then report on it using Oracle tools. We’ve looked at Apache Hive and how it provides a SQL layer over Hadoop, making it possible for tools like ODI and OBIEE to use their usual […]

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). […]

Website Design & Build: tymedia.co.uk