Last month I have been attending the RittmanMead BI Forum 2014. In the wrap-up I mentioned a presentation by Andrew Bond & Stewart Bryson. They had a very nice presentation about the Oracle Information Management Reference Architecture. This needed some further investigation from my part. This blogpost is a first summary of the information I found online so far. There is […]
If you’ve thought about commenting on OBIEE dashboards or believe that users need a way to tell the story about their data, you are not alone. We’re putting on the first webinar discussing Collaborative BI in Oracle Business Intelligence this Friday June 20th at 2pm EST. We’d like you to sign up for the webinar […]
Those of you who subscribed the WebLogic Book Youtube Channel already know that I published 2 additional webcasts (the 2014 edition of WebLogic Distinctive Recipes Book references them). I). Per Domain Node Manager Note, that I keep receiving comments about the WebLogic 12c node manager bug. II). WebLogic Server Templates and Dynamic Cluster:
This post quickly looks at BITeamwork and Custom XML Template Configurations in order to give confidence that BITeamwork aligns with any existing configurations that your Oracle BI implementation currently has in place. Again, BITeamwork sits within the Oracle BI architecture and in no way interferes with normal system processes. It augments its features by aligning with the pages and HTML areas in which it OBIEE works.
We mentioned Cindy Howson‘s research findings on Improvements and Innovation Priorities for BI this year, 2014, in our BITeamwork 2.8 release blog post. We know that the idea of commenting and collaborating in BI has crossed everyone’s mind but currently there is no massive adoption across BI tools – more innovative companies are understanding the […]
One of the things at Rittman Mead that we’re really interested in, is the architecture of “information management” systems and how these evolve over time as thinking, and product capabilities, evolve. In fact we often collaborate with the Enterprise Architecture team within Oracle, giving input into the architecture designs they come up with, and more recently working on a full-blown collaboration with them to come up with a next-generation Information Management architecture.
All week I’ve been looking at what’s involved in moving data around Hadoop on the Oracle Big Data Appliance, using ODI12c to orchestrate the end-to-end process. Using web log data from the Rittman Mead website, I first landed the log data on HDFS using Apache Flume, then transformed the data in several stages using Hive transformations built using ODI mappings and knowledge modules. The links below give the previous articles in this series, where you can read how I transformed data using Hive, Sqoop and Python streaming:
This week I’m taking an in-depth look at ETL on the Oracle Big Data Appliance, using Oracle Data Integrator 12c to call the various bits of Hadoop functionality and orchestrate the whole process. So far, I’ve landed web log data into the Hadoop cluster using Flume, created a Hive table over the log data using Hive and the RegEx SerDe, then used further Hive transformations to join this data to other reference data, some of which came from an Oracle database via Sqoop. Here’s a complete listing of the posts so far, and the ones to come:
In the first two posts in this series, I used the software on the Oracle Big Data Appliance 3.0 to ingest web log data from the Rittman Mead blog server, parse and load that data into a Hive table, and then join that table to another to add details on post and author. Links to the post in this series are below, and I’ll complete them as the series is posted this week:
Long-term readers of this blog will know that we’ve supported for many years the BI Survey, an independent survey of BI tools customers and implementors. Rittman Mead have no (financial or other) interest in the BI Survey or its organisers, but we like the way it gathers in detailed data on which tools work best and when, and it’s been a useful set of data for companies such as Oracle when they prioritise their investment in tools such as OBIEE, Essbase and the BI Applications.
Here’s the invite text and link to the survey: