Rittman Mead Blog - Technical Insights

Tagged

Technical

A collection of 878 posts

New Oracle Big Data Quick-Start Packages from Rittman Mead

Many organisations using Oracle’s business intelligence and data warehousing tools are now looking to extend their capabilities using “big data” technologies. Customers running their data warehouses on Oracle Databases are now looking to use Hadoop to extend their storage capacity whilst offloading initial data loading and ETL to this

OBIEE nqcmd Tidbits

nqcmd is the ODBC command line tool that always has, and hopefully always will, shipped with OBIEE. It enables you to manually fire queries directly at the BI Server, rather than through the usual way of Presentation Services generating Logical SQL and sending it to BI Server. This can be

Announcing the BI Forum 2015 Data Visualisation Challenge

The Rittman Mead BI Forum 2015 [http://www.rittmanmead.com/biforum2015]is running in Brighton from May 6th-8th 2015, and Atlanta from May 13th - 15th 2015. At this year’s events we’re introducing our first “data visualization challenge” [http://www.rittmanmead.com/biforum2015/bi-forum-2015-data-visualization-challenge/] , open to all attendees

Instrumenting OBIEE Database Connections For Improved Performance Diagnostics

Nearly four years ago I wrote a blog post entitled “Instrumenting OBIEE - The Final Chapter” [https://rnm1978.wordpress.com/2011/10/10/instrumenting-obiee-the-final-chapter/] . With hindsight, that title suffix (“The Final Chapter”) may have been a tad presumptuous and naïve of me (or perhaps I can just pretend to be

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/

An Introduction to Analysing ODI Runtime Data Through Elasticsearch and Kibana 4

An important part of working with ODI is analysing the performance when it runs, and identifying steps that might be inefficient as well as variations in runtime against a baseline trend. The Operator tool in ODI itself is great for digging down into individual sessions and load plan executions, but

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

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

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

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/

Why and How to use Oracle Metadata Management 12c. Part 2: Importing and Relating Metadata

In the first post [https://www.rittmanmead.com/blog/2015/01/why-and-how-to-use-oracle-metadata-management-12c-part-1-getting-started/] of this series we have seen how to install and configure OEEM to start working with it. In this new post we are going to see how we import the metadata into OEMM from different sources like Oracle

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

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/

Data Integration Tips: ODI - Use Scenarios in packages

Here is another question I often hear during ODI Bootcamp [http://www.rittmanmead.com/training/training-trn405-oracle-data-integrator-12c-bootcamp/] or I often read in the ODI Space on OTN [https://community.oracle.com/community/business_intelligence/system_management_and_integration/data_integrator/] : In a package, should I directly use mappings (or interfaces prior

OBIEE Monitoring and Diagnostics with InfluxDB and Grafana

In this article I’m going to look at collecting time-series metrics into the InfluxDB database and visualising them in snazzy Grafana dashboards. The datasets I’m going to use are OS metrics (CPU, Disk, etc) and the DMS metrics from OBIEE, both of which are collected using the support

Endeca Information Discovery Integration with Oracle BI Apps 11.1.1.8.1

One of the new features that made its way into Oracle BI Apps 11.1.1.8.1 [https://blogs.oracle.com/proactivesupportEPM/entry/biapps_111181_whatsnew], and that completely passed me by at the time, was integration with Oracle Endeca Information Discovery 3.1 [http://www.oracle.com/us/

Rittman Mead's Development Cluster, EM12c and the Blue Mendora VMware EM Plugin

For development and testing purposes, Rittman Mead run a VMWare VSphere cluster made up of a number of bare-metal servers hosting Linux, Windows and other VMs. Our setup has grown over the years from a bunch of VMs running on Mac Mini servers [https://www.rittmanmead.com/blog/2013/08/

Enable Your Dashboard Designers to Concentrate on User Experience Rather Than Syntax (or How to Add a Treemap in Two Lines)

JavaScript is a powerful tool that can be used to add functionality to OBIEE dashboards. However, for many whose wheelhouses are more naturally aligned with Stephen Few [http://www.amazon.com/Stephen-Few/e/B001H6IQ5M] rather than John Resig [http://ejohn.org/about/], adding JavaScript to a dashboard can be intimidating.

Why and How to use Oracle Metadata Management 12c. Part 1: Getting Started

At OOW 2014, Oracle announced the new Oracle Metadata Management solution and later in the middle of October released its first version - OMM 12.1.3.0.0 [http://www.oracle.com/us/corporate/press/2340462?rssid=rss_ocom_pr] At the end of November of 2014, the second

Concurrent RPD Development in OBIEE

OBIEE is a well established product, having been around in various incarnations for well over a decade [https://www.rittmanmead.com/blog/2007/09/a-potted-history-of-oracle-bi-suite-enterprise-edition/]. The latest version, OBIEE 11g, was released 3.5 years ago, and there are mutterings of OBIEE 12c already [https://www.rittmanmead.com/blog/2014/

Using Oracle Big Data SQL to Add Dimensions and Attributes to Hadoop Reporting

In a previous post I looked at using Oracle’s new Big Data SQL product with ODI12c [https://www.rittmanmead.com/blog/2014/10/using-oracle-big-data-sql-odi12c-hive/], where I used Big Data SQL [http://www.oracle.com/us/products/database/big-data-sql/overview/index.html] to expose two Hive tables as Oracle external

Data Integration Tips: ODI - One Data Server with several Physical Schemas

Yes, I'm hijacking the "Data Integration Tips" series [http://www.rittmanmead.com/tag/data-integration-tips/] of my colleague Michael Rainey [http://www.rittmanmead.com/author/michael-rainey/] (@mRainey [https://twitter.com/mRainey]) and I have no shame! DISCLAIMER This tip is intended for newcomers in the ODI world

Connecting OBIEE11g on Windows to a Kerberos-Secured CDH5 Hadoop Cluster using Cloudera HiveServer2 ODBC Drivers

In a few previous posts and magazine articles [http://www.oracle.com/technetwork/issue-archive/2014/14-sep/o54ba-2279189.html] I’ve covered connecting OBIEE11g to a Hadoop cluster [https://www.rittmanmead.com/blog/2014/01/obiee-11-1-1-7-cloudera-hadoop-hiveimpala-part-2-load-data-into-hivehcatalog-analyze-using-impala/] , using OBIEE 11.1.1.7 and Cloudera CDH4 and CDH5 as the examples. Things

TIMESTAMPS and Presentation Variables

TIMESTAMPS and Presentation Variables can be some of the most useful tools a report creator can use to invent robust, repeatable reports while maximizing user flexibility. I intend to transform you into an expert with these functions and by the end of this page you will certainly be able to