Rittman Mead Blog - Technical Insights

OBIEE 11.1.1.9: New Features for Front-End Developers and Business Users

OBIEE 11.1.1.9 [https://blogs.oracle.com/proactivesupportEPM/entry/obiee_111190] was released this May and Robin and Mark wrote great posts about New Features from System Administrators [https://www.rittmanmead.com/blog/2015/05/whats-new-in-obiee-11-1-1-9-for-systems-administrators-and-developers/] and the new support for HiveServer2 and Cloudera Impala [https://www.rittmanmead.

Technical

Deploying Oracle BI Mobile HD within Good, Oracle OMSS and Other Secure MDM Containers

A few months ago ODTUG announced their ODTUG Mobile Day in Utrecht, Netherlands [http://www.odtug.com/mobile_day_utrecht] and asked if I’d like to put forward an abstract for a presentation. Something that’s been on my mind for a while is the issues some of our

Technical

New Oracle Magazine article on Oracle BI Cloud Service

The May/June 2015 edition of Oracle Magazine is now out, and my Business Intelligence article in this edition is on Oracle BI Cloud Service (BICS). In “Upload, Model, Analyze and Report” [http://www.oracle.com/technetwork/issue-archive/2015/15-may/o35ba-2541604.html] I focus on the “departmental power-user” use-case where

Big Data

Connecting OBIEE 11.1.1.9 to Hive, HBase and Impala Tables for a DW-Offloading Project

In two previous posts this week I talk about a client request to offload part of their data warehouse top Hadoop, taking data from a source application and loading it into Hive tables on Hadoop for subsequent reporting-on by OBIEE11g. In the first post [https://www.rittmanmead.com/blog/2015/

Big Data

Using HBase and Impala to Add Update and Delete Capability to Hive DW Tables, and Improve Query Response Times

One of our customers is looking to offload part of their data warehouse platform to Hadoop, extracting data out of a source system and loading it into Apache Hive tables for subsequent querying using OBIEE11g. One of the challenges that the project faces though is how to handle updates to

Big Data

OBIEE 11.1.1.9 Now Supports HiveServer2 and Cloudera Impala

As you all probably know I’m a big fan of Oracle’s BI and Big Data products [http://www.rittmanmead.com/biforum2015/optional-masterclass-delivering-the-oracle-information-management-big-data-reference-architecture/] , but something I’ve been critical of [https://www.rittmanmead.com/blog/2014/12/connecting-obiee11g-on-windows-to-a-kerberos-secured-cdh5-hadoop-cluster-using-cloudera-hiveserver2-odbc-drivers/] is OBIEE11g’s lack of support for HiveServer2 connections to Hadoop

Big Data

Presentation Slides and Photos from the Rittman Mead BI Forum 2015, Brighton and Atlanta

It’s now the Saturday after the two Rittman Mead BI Forum 2015 [http://www.rittmanmead.com/biforum2015/] events, last week in Atlanta, GA and the week before in Brighton, UK. Both events were a great success and I’d like to say thanks to the speakers, attendees, our friends

Technical

What's New in OBIEE 11.1.1.9 for Systems Administrators and Developers

After over two years since the last major release of OBIEE, Oracle released version 11.1.1.9 in May 2015. You can find the installers here [http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bi-downloads-2537285.html] and documentation here [https://docs.oracle.com/middleware/11119/biee/docs.htm]. 11.

Technical

Some Oracle Big Data Discovery Tips and Techniques

I’ve been using Oracle Big Data Discovery for a couple of months now, and one of the sessions I’m delivering at this week’s Rittman Mead BI Forum 2015 in Atlanta [http://www.rittmanmead.com/biforum2015] is on Big Data Discovery Examples from the Field, co-presented with Tim

Big Data

So What's the Real Point of ODI12c for Big Data Generating Pig and Spark Mappings?

Oracle ODI12c for Big Data [https://www.oracle.com/middleware/data-integration/enterprise-edition-big-data/index.html] came out the other week, and my colleague Jérôme Françoisse put together an introductory post on the new features [https://www.rittmanmead.com/blog/2015/04/odi12c-advanced-big-data-option-overview-install/] shortly after, covering ODI’s new ability to generate

Big Data

Setting up Security and Access Control on a Big Data Appliance

Like all Oracle Engineered Systems, Oracle’s field servicing and Advanced Customer Services (ACS) teams go on-site once a BDA has been sold to a customer and do the racking, installation and initial setup. They will usually ask the customer a set of questions such as “do you want to

Technical

Last Chance to Register for the Brighton Rittman Mead BI Forum 2015!

It’s just a week to go until the start of the Brighton Rittman Mead BI Forum 2015 [http://www.rittmanmead.com/biforum2015/], with the optional one-day masterclass starting on Wednesday, May 6th at 10am and the event opening with a reception and Oracle keynote later in the evening. Spaces

Big Data

Using the ELK Stack to Analyse Donor's Choose Data

Donor’s Choose [http://www.donorschoose.org/about] is an online charity in America through which teachers can post details of projects that need funding and donors can give money towards them. The data from the charity [http://data.donorschoose.org/]since it began in 2000 is available to download

Technical

BI Forum 2015 Preview -- OBIEE Regression Testing, and Data Discovery with the ELK stack

I’m pleased to be presenting at both of the Rittman Mead BI Forums [https://www.rittmanmead.com/blog/biforum2015/] this year; in Brighton it’ll be my fourth time, whilst Atlanta will be my first, and my first trip to the city too. I’ve heard great things about

Technical

Data Integration Tips: ODI 12.1.3 - Convert to Flow

The many who have already upgraded Oracle Data Integrator from the 11g version to 12c probably know about this great feature called “convert to flow". If not, well…here you go! First, a little background on why I think this is an excellent bit of functionality. The ODI Upgrade

Big Data

Oracle Data Integrator Enterprise Edition Advanced Big Data Option Part 1- Overview and 12.1.3.0.1 install

Oracle recently announced Oracle Data Integrator Enterprise Edition Advanced Big Data Options [https://www.oracle.com/middleware/data-integration/enterprise-edition-big-data/index.html] as part of the new 12.1.3.0.1 release of ODI. It includes various great new functionalities to work on an Hadoop ecosystem. Let's have

Big Data

Previewing Four Sessions at the Atlanta Rittman Mead BI Forum 2015

In a post earlier this week I previewed three sessions at the upcoming Brighton Rittman Mead BI Forum 2015 [https://www.rittmanmead.com/blog/2015/04/previewing-three-sessions-at-the-brighton-rittman-mead-bi-forum-2015/] ; in this post I’m going to look at four particularly interesting sessions at the Atlanta Rittman Mead BI Forum 2015 [http://www.

Technical

OBIEE and the Oracle Database 12c In-Memory Option - Article and New Services from Rittman Mead

My latest Business Intelligence column for Oracle Magazine is on the In-Memory Option for Oracle Database 12c [http://www.oracle.com/technetwork/issue-archive/2015/15-jan/o15ba-2398995.html] , and using it to speed-up dashboards and reports in OBIEE11g. In the article I go through the basics of the in-memory option explaining

Technical

Take Part in the BI Survey 15, and Have Your Voice Heard!

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

Technical

Previewing Three Sessions at the Brighton Rittman Mead BI Forum 2015

As well as a one-day masterclass by myself and Jordan Meyer [http://www.rittmanmead.com/biforum2015/optional-masterclass-delivering-the-oracle-information-management-big-data-reference-architecture/] , a data visualisation challenge [http://www.rittmanmead.com/biforum2015/bi-forum-2015-data-visualization-challenge/] , keynotes and product update sessions from Oracle and our guest speaker [https://www.rittmanmead.com/blog/2015/03/announcing-the-special-guest-speakers-for-brighton-atlanta-bi-forum

Big Data

Realtime BI Show with Kevin and Stewart - BI Forum 2015 Special!

Jordan Meyer and I were very pleased to be invited onto the Realtime BI Show podcast last week, run by Kevin McGinley and Stewart Bryson, to talk about the upcoming Rittman Mead BI Forum running in Brighton and Atlanta in May 2015 [http://www.rittmanmead.com/biforum2015]. Stewart and Kevin

Technical

Analysing ODI performance with Flame Graphs

Flame Graphs [http://www.brendangregg.com/flamegraphs.html] are a visualisation that I learnt about through the excellent Linux systems performance work of Brendan Gregg [http://www.brendangregg.com/], and saw Luca Canali [https://twitter.com/lucacanalidb] talk about recently at UKOUG Tech 14 [http://tech14.ukoug.org/default.asp?

Big Data

Announcing Oracle E-Business Suite for Hadoop and MongoDB

Rittman Mead are very pleased today to announce our special edition of Oracle E-Business Suite R12 running on Apache Hadoop [https://hadoop.apache.org]and MongoDB [https://www.mongodb.org], for customers looking for the ultimate in scalability, flexible data storage and lower cost-of-ownership. Powered by Hadoop technologies such as

Big Data

Oracle GoldenGate, MySQL and Flume

Back in September Mark blogged about Oracle GoldenGate (OGG) and HDFS [https://www.rittmanmead.com/blog/2014/09/using-oracle-goldengate-for-trickle-feeding-rdbms-transactions-into-hive-and-hdfs] . In this short followup post I'm going to look at configuring the OGG Big Data Adapter for Flume, to trickle feed blog posts and comments from our site to

Technical

Lifting the Lid on OBIEE Internals with Linux Diagnostics Tools

There comes the point in any sufficiently complex or difficult problem diagnosis that the log files in OBIEE alone are not sufficient for building up a complete picture of what’s going on. Even with the debug/trace data that Presentation Services [https://www.rittmanmead.com/blog/2014/11/auditing-obiee-presentation-catalog-activity-with-custom-log-filters/