Rittman Mead Blog

Taking a Look at Oracle Big Data Preparation Cloud Service - Spark-Based Data Transformation in the Cloud

One of the sessions I’m delivering at the upcoming Oracle Openworld 2015 in San Francisco is entitled "Oracle Business Intelligence Cloud Service—Moving Your Complete BI Platform to the Cloud [UGF4906]”, and looks at how you can now migrate your entire OBIEE11g platform into Oracle Public Cloud including

Big Data

Oracle Big Data Discovery 1.1 now GA, and Available as part of BigDataLite 4.2.1

The new Oracle Big Data Discovery 1.1 release went GA [https://blogs.oracle.com/proactivesupportEPM/entry/bdd_v11] a couple of weeks ago, and came with a bunch of features that addressed show-stoppers in the original 1.0 release; the ability to refresh and reload datasets from Hive, compatibility

Big Data

Combining Spark Streaming and Data Frames for Near-Real Time Log Analysis & Enrichment

A few months ago I posted an article on the blog around using Apache Spark to analyse activity on our website [https://www.rittmanmead.com/blog/2014/12/going-beyond-mapreduce-for-hadoop-etl-pt-3-introducing-apache-spark/] , using Spark to join the site activity to some reference tables for some one-off analysis. In this article I’ll be

Big Data

Rittman Mead at ODTUG KScope'15, Hollywood Florida

ODTUG KScope’15 [http://kscope15.com] is running in Hollywood, Florida next week and Rittman Mead are running a number of sessions during the week on OBIEE, Essbase, ODI and Big Data. I’ve personally been attending ODTUG KScope (or “Kaleidoscope”, as it used to be known) for many years

Big Data

Replicating Hive Data Into Oracle BI Cloud Service for Visual Analyzer using BICS Data Sync

In yesterday’s post on using Oracle Big Data Discovery with Oracle Visual Analyzer in Oracle BI Cloud Service [https://www.rittmanmead.com/blog/2015/06/combining-oracle-big-data-discovery-and-oracle-visual-analyzer-on-bics/] , I said mid-way through the article that I had to copy the Hadoop data into BI Cloud Service so that Visual Analyzer could

Big Data

Combining Oracle Big Data Discovery and Oracle Visual Analyzer on BICS

So now that Oracle Visual Analyzer is out as part of Oracle BI Cloud Service [https://www.rittmanmead.com/blog/2015/06/new-in-oracle-bi-cloud-service-oracle-visual-analyzer-and-data-mashups-in-va/] , and Visual Analyzer (VA) is due to ship on-premise as part of OBIEE12c sometime in the next twelve months, several of our customers have asked us if

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

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

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

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.

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

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

Big Data

More on the Rittman Mead BI Forum 2015 Masterclass : "Delivering the Oracle Big Data and Information Management Reference Architecture"

Each year at the Rittman Mead BI Forum [http://www.rittmanmead.com/biforum2015] we host an optional one-day masterclass before the event opens properly on Wednesday evening, with guest speakers over the year including Kurt Wolff [https://twitter.com/markrittman/status/14286589858], Kevin McGinley [https://obibb.wordpress.com/2012/05/

Big Data

Announcing the Special Guest Speakers for Brighton & Atlanta BI Forum 2015

As well as a great line-up of speakers and sessions at each of the Brighton & Atlanta Rittman Mead BI Forum 2015 [http://www.rittmanmead.com/biforum2015/] events in May, I’m very pleased to announce our two guest speakers who’ll give the second keynotes, on the Thursday evening

Big Data

Rittman Mead BI Forum 2015 Now Open for Registration!

I’m very pleased to announce that the Rittman Mead BI Forum 2015, running in Brighton and Atlanta in May 2015, is now open for registration [http://www.rittmanmead.com/biforum2015/]. Back for its seventh successful year, the Rittman Mead BI Forum once again will be showcasing the best speakers

Big Data

Creating Real-Time Search Dashboards using Apache Solr, Hue, Flume and Cloudera Morphlines

Late last week Cloudera published a blog post on their developer site on building a real-time log analytics dashboard using Apache Kafka, Cloudera Search and Hue [http://blog.cloudera.com/blog/2015/02/how-to-do-real-time-log-analytics-with-apache-kafka-cloudera-search-and-hue/] . As I’d recently been playing around with Oracle Big Data Discovery with our website log

Technical

Introducing Oracle Big Data Discovery Part 3: Data Exploration and Visualization

In the first two posts in this series, we looked at what Oracle Big Data Discovery is [https://www.rittmanmead.com/blog/2015/02/introducing-oracle-big-data-discovery-part-1-the-visual-face-of-hadoop/] and how you can use it to sample, cleanse and then catalog data in your Hadoop-based data reservoir [https://www.rittmanmead.com/blog/2015/02/

Technical

Introducing Oracle Big Data Discovery Part 2: Data Transformation, Wrangling and Exploration

In yesterday’s post I looked at Oracle Big Data Discovery and how it brought the search and analytic capabilities of Endeca to Hadoop [https://www.rittmanmead.com/blog/2015/02/introducing-oracle-big-data-discovery-part-1-the-visual-face-of-hadoop/] . We looked at how the Oracle Endeca Information Discovery Studio application works with a version of the Endeca

Technical

Introducing Oracle Big Data Discovery Part 1: "The Visual Face of Hadoop"

Oracle Big Data Discovery [https://www.oracle.com/bigdata/big-data-discovery/index.html] was released last week, the latest addition to Oracle's big data tools suite that includes Oracle Big Data SQL [http://www.rittmanmead.com/tag/big-data-sql/], ODI and it’s Hadoop capabilities [https://www.rittmanmead.com/blog/