Rittman Mead Blog - Technical Insights

Oracle BI Apps 11.1.1.7.1 – GoldenGate Integration - Part 3: SDS and Parameter File Setup

This is the third post in the four part series on Oracle BI Applications 11.1.1.7.1 and Oracle GoldenGate 11g. Last time, we made it through the initial setup of GoldenGate and created the necessary schemas for the Source Dependent Data Store (SDS) and GoldenGate on the

Technical

My Journey to ODI 12c

Most readers of this blog probably know me for my time spent with OBIEE (especially my work in repository development), but I'm guessing some of you long-time readers know that I grew up working with the Oracle Database. Many and many a year ago, I was a fledging

Technical

Oracle GoldenGate 12c - New Release, New Features

The latest release of Oracle's data replication tool, GoldenGate 12c, has many improvements. The release coincided with the Oracle Data Integrator 12c release [https://www.rittmanmead.com/blog/2013/10/oracle-data-integrator-12c-release-part-1/] - and I wasn't about to let my colleague Jérôme Françoisse [https://twitter.com/JeromeFr]

Oracle BI Suite EE

Rittman Mead / ODTUG India BI Masterclass Tour Roundup

Over the past week Venkat, myself and the Rittman Mead India team have been running a series of BI Masterclasses [http://www.rittmanmead.com/indiabimasterclass2013/] at locations in India, in conjunction with ODTUG, the Oracle Development Tools User Group. Starting off in Bangalore, then traveling to Hyderabad and Mumbai, we

Technical

Oracle BI Apps 11.1.1.7.1 – GoldenGate Integration - Part 2: Setup and Configuration

In my previous post, I introduced the steps necessary for integrating Oracle BI Applications 11.1.1.7.1 and GoldenGate (OGG). Now, I'm going to dive into the details and describe how to complete the setup and configuration of GoldenGate and the Source Dependent Data Store schema.

Technical

Oracle Data Integrator 12c release : Part 1

That's it! The long awaited Oracle Data Integrator 12c is out! You can find the 12.1.2 version on the ODI Downloads [http://www.oracle.com/technetwork/middleware/data-integrator/downloads/index.html] page and discover the new features here while it gets downloaded. The main news is

Oracle BI Suite EE

OBIEE "Act As" (ActAs) vs "Impersonate"

There will come a point in the lifecycle of an OBIEE deployment when one user will need to access another user’s account. This may be to cover whilst a colleague is on leave, or a support staff trying to reproduce a reported error. Password sharing aside (it's

Technical

Oracle BI Apps 11.1.1.7.1 – GoldenGate Integration - Part 1: Introduction

The release of Oracle Business Intelligence Applications 11.1.1.7.1 [http://www.oracle.com/technetwork/middleware/bi-applications/overview/default-458073.html] includes a major change in components, with Oracle Data Integrator replacing Informatica as the ETL application. The next logical step was to integrate Oracle’s data replication tool,

Technical

Oracle Endeca Information Discovery, Text Enrichment and Customer-Defined Lists

One of the data visualisations that you can use with Oracle Endeca Information Discovery is the “tag cloud”. You’ve probably seen tag clouds used in newspaper articles and other publications to show the most commonly found words or phrases in a document, the screenshot below shows a tag cloud

Oracle BI Suite EE

Tips and Tricks for the OBIEE linux sysadmin

As well as industry-leading solution architecture, consultancy and training on Oracle BI, here at Rittman Mead we also provide expert services in implementation and support of such systems. In this blog I want to share some of the things I find useful when working with OBIEE on a Linux system.

Technical

Interview with Stewart Bryson - Our New Chief Innovation Officer

Regular readers of this blog will know Stewart Bryson, our US Managing Director and in his spare time, Oracle ACE, writer and presenter on Oracle BI &DW development topics. Those of you who've met Stewart will know that his first love has always been technology and how

Oracle BI Suite EE

Openworld is Over - Now We're Coming to India..!

Oracle Openworld 2013 is now over [https://www.rittmanmead.com/blog/2013/09/oracle-openworld-2013-reflections-on-product-announcements-and-strategy/] , but no sooner have we unpacked from that trip, we're packing again for our next one - our BI Masterclass Tour for India [http://www.rittmanmead.com/indiabimasterclass2013/], starting in a few week'

Oracle BI Suite EE

Oracle Openworld 2013 : Reflections on Product Announcements and Strategy

I'm sitting writing this at my desk back home, with a steaming mug of tea next to me and the kids pleased to see me after having been away for eight days (or at least my wifepleased to hand them over to me after looking after them for

Oracle BI Suite EE

Oracle Openworld 2013 Days 3 & 4 : Oracle Cloud, OBIEE and ODI Futures

It's getting to the end of day 4 of Oracle Openworld, with Team Oracle USA coming back from 8-1 down and pulling-off the unlikeliest of comeback victories [http://www.bbc.co.uk/sport/0/sailing/24274103], and Openworld sessions covering OBIEE, ODI and Oracle Cloud futures. Here'

Oracle BI Suite EE

Oracle Openworld 2013 Day 2: Exalytics, TimesTen and Essbase Futures

Monday's almost over at Oracle Openworld 2013 in San Francisco, and it started for me today with a presentation on Enterprise Manager 12c and the BI Management Pack, alongside Henrik Blixt (PM for the BI Management Pack) andDhananjay Papde [http://dhananjaypapde.blogspot.co.uk], author of a book

Technical

Oracle Openworld 2013 Day 1 : User Group Forum, News on Oracle Database In-Memory Option

The Sunday before Oracle Openworld proper is "User Group Forum Sunday", with each of the major user groups and councils having dedicated tracks for topics such as BI&DW, Fusion Development, Database and so on. Stewart, myself and Venkat were honoured to be presenting on behalf of

Technical

Oracle Openworld 2013 Day 0: Previewing the Week Ahead

It's the Saturday afternoon before the start of Oracle Openworld 2013 [http://www.oracle.com/openworld], and whilst I've been here since last Wednesday, my colleagues from Rittman Mead in the Europe, the USA and India are arriving today and tomorrow ready for their sessions later

Oracle BI Suite EE

Create a Mobile BI App for iOS, Android or BlackBerry within 5 Days!

A few weeks ago I posted an article on the blog about the new Oracle BI Mobile App Designer [http://www.rittmanmead.com/blog/2013/08/a-first-look-at-the-obiee11g-mobile-app-designer/] , an HTML5-based mobile app builder for OBIEE 11.1.1.7.1. BI Mobile App Designer differs from Oracle BI Mobile HD in

Hyperion Essbase

Installing Essbase Analytics Link for HFM 11.1.2.3

If your requirement is to install EAL for HFM, then this post is for you. Oracle has not yet released a new version of EAL that is certified with HFM 11.1.2.3 and hence you will not be able to find one in the edelivery. The question is

Oracle BI Suite EE

OBIEE as a Data Source for Qlikview, and the New "Direct Discovery" Feature: Part 2

In my last post [https://www.rittmanmead.com/blog/2013/09/obiee-qlikview-dd1/] I explored how to use Qlikview, an in-memory query tool similar in concept to Endeca Information Discovery, to connect to OBIEE's BI Repository and use it as a data source. The conclusion was that a Qlikview

Oracle BI Suite EE

OBIEE as a Data Source for Qlikview, and the New "Direct Discovery" Feature: Part 1

A recent release of Qlikview [www.qlikview.com] added a new feature called "Direct Discovery" [http://bi-review.blogspot.co.uk/2013/04/first-look-at-qlikview-direct-discovery.html] , that allows Qlikview reports to directly access a database datasource on-demand . Qlikview, by default, loads all required data up-front into its own in-memory column-store

Oracle BI Suite EE

Using DAC11g to Replicate BI Apps DW Tables into TimesTen

A couple of months ago Peter Scott and I wrote a series [https://www.rittmanmead.com/blog/2013/06/using-oracle-timesten-with-oracle-bi-applications-part-1/] of [https://www.rittmanmead.com/blog/2013/06/using-oracle-timesten-with-oracle-bi-applications-part-2/] posts [https://www.rittmanmead.com/blog/2013/07/using-oracle-timesten-with-oracle-bi-applications-part-3/] on using Exalytics with the Oracle BI Apps, with the idea begin

Technical

Diving Deeper into BI Apps 11.1.1.7.1 use of ODI11g for Data Loading

A few months ago I posted a series of articles on the new BI Apps 11.1.1.7.1 release [http://www.rittmanmead.com/biapps11g/], which used ODI11g in the background to perform data loads, rather than Informatica PowerCenter. Since then, I've collaborated with Accenture's

Oracle BI Suite EE

New Feature in OEM Cloud Control 12cR3 - Exalytics Server Management

A few months ago a wrote a series [https://www.rittmanmead.com/blog/2013/04/obiee-oem12cr2-and-the-bi-management-pack-part-1-introduction-to-oem12cr2/] of [https://www.rittmanmead.com/blog/2013/04/obiee-oem12cr2-and-the-bi-management-pack-part-2-installation-and-configuration/] posts [https://www.rittmanmead.com/blog/2013/04/obiee-oem12cr2-and-the-bi-management-pack-part-3-but-what-does-it-do/] about the new 12cR2 release of Oracle Enterprise Manager Cloud Control, which re-instated the BI

Oracle BI Suite EE

Using Non-Oracle, and Cloud-Hosted Databases with OBIEE 11g

The vast majority of our customers use Oracle Database [http://www.oracle.com/us/products/database/overview/index.html] as the underlying data source for OBIEE 11g, sometimes on Exadata but almost always the Enterprise Edition [http://www.oracle.com/us/products/database/enterprise-edition/overview/index.html] of the database.