Rittman Mead (Page 14)

Oracle Data Integrator 12c: Getting Started - Components and Architecture

I’ve decided that it’s time for a refresher on Oracle Data Integrator 12c. I’m writing a Getting Started series to help folks get interested in the product and maybe even teach a few old dogs (including myself) some new tricks. In my [last post](GHOST_URL/2016/

elasticsearch

Streaming data from Oracle using Oracle GoldenGate and Kafka Connect

This article was also posted on the Confluent blog [http://www.confluent.io/blog/streaming-data-oracle-using-oracle-goldengate-kafka-connect/] , head over there for more great Kafka-related content! -------------------------------------------------------------------------------- Kafka Connect [http://docs.confluent.io/3.0.0/connect/index.html] is part of the Confluent Platform [http://www.confluent.io/product], providing a set

obiee

OTN Appreciation Day : OBIEE's BI Server

Oracle Technology Network [http://www.oracle.com/technetwork/index.html] (OTN) is one you'll be familiar with if you do anything with Oracle software, from downloading the installers [http://www.oracle.com/technetwork/indexes/downloads/index.html], reading the documentation [http://www.oracle.com/technetwork/indexes/documentation/index.

obiee

OTN Appreciation Day: OBIEE's Export to Excel Functionality

Only kidding…. Do you know that almost any transformation doable in excel can be achieved in OBIEE, probably faster and with zero impact on your local workstation? Image credit https://twitter.com/fomin_andrew/status/749305992198881281Why bothering downloading data to Excel when you have pivot tables, conditional formatting and a

odi12c

OTN Appreciation Day: Oracle Data Integrator 12c - Flexibility

As you may already know by now, it’s [OTN Appreciation Day]( https://oracle-base.com/blog/2016/09/28/otn-appreciation-day/" target="_blank)! The idea was thought up by Oracle ACE Director Tim Hall to give thanks to the Oracle Technical Network that we all love and use on

Conferences

POUG

I've just attended my first user group in Poland, the very-excellent POUG [http://poug.org/en/]. This was the first international version of the conference, having been run previously just within Poland. Based on these two days, I would say it was a resounding success! There was a

odi12c

Oracle Data Integrator 12c: Getting Started - What is ODI?

There is something about sharing stories with others about the technology you love that gets the blood flowing. I have written blog posts and articles, presented sessions at conferences, and recorded podcasts and tech tips about [Oracle Data Integrator]( http://www.oracle.com/technetwork/middleware/data-integrator/overview/index.html "

obiee

All You Ever Wanted to Know About OBIEE Performance…but were too afraid to ask

At the Polish Oracle Users Group (POUG) conference [http://poug.org/en/timeline/] this week I'm presenting one of my favourite talks, [Still] No Silver Bullets - OBIEE Performance in the Real World [https://speakerdeck.com/rmoff/still-no-silver-bullets-obiee-12c-performance-in-the-real-world] . This presentation is based on the shared experiences of myself

OBIA

Becky's BI Apps Corner: OBIA 11.1.1.10.2 New Features Part 1 - Health Check & ETL Diagnostics

I have been working with BI Applications since OBIA switched to ODI in version 11.1.1.7.0. I have installed and worked with all of the 11.x versions using several different sources. This most recent version of OBIA may only be a Patch-Set release, but it has

Analysing Social Media Data for the Lightyear Foundation - Part 2

In my last post [https://www.rittmanmead.com/blog/2016/08/analysing-social-media-data-for-the-lightyear-foundation-part-1/] , I described the basics around connecting to social media data sources using Python. This is in aid of collating information for the Lightyear Foundation [http://www.lightyearfoundation.org/], a charity specialising in science education in the UK and

Rittman Mead Life

Rittman Mead at Oracle OpenWorld 2016

The big show is upon us and once again Rittman Mead will be actively participating at [Oracle OpenWorld 2016]( https://www.oracle.com/openworld/index.html" target="_blank). Oracle's premier conference runs September 18–22 at the Moscone Center in beautiful San Francisco, California. I'

Oracle GoldenGate

Using logdump to Troubleshoot the Oracle GoldenGate for Big Data Kafka Handler

Oracle GoldenGate [http://www.oracle.com/technetwork/middleware/goldengate/overview/index.html] for Big Data (OGG BD) supports sending transactions as messages to Kafka topics, both through the native Oracle handler [http://docs.oracle.com/goldengate/bd1221/gg-bd/GADBD/GUID-2561CA12-9BAC-454B-A2E3-2D36C5C60EE5.htm#GADBD449] as well as a connector into Confluent'

odi12c

Oracle Data Integrator: Upgrade to ODI 12c - A Case Study

We don’t often get a chance to share our customer success stories due to various reasons, such as required anonymity of the client or certain other legalities. But when we do, it sure feels great! Recently, Eurocontrol [www.eurocontrol.int] , a longtime Rittman Mead client in Brussels, Belgium, performed

Technical

Becky's BI Apps Corner: OBIA Back-to-Beginnings - Naming Conventions and Jargon

It's easy to talk about a technology using only jargon. It's much harder to talk about a technology without using jargon. I have seen many meetings between business and IT break down because of this communication barrier. I find it more discouraging when I see this

odbc

How To Poke Around OBIEE on Linux with strace (Working with Unsupported ODBC Sources in OBIEE 12c)

OBIEE 12c (and 11g and 10g before it) supports three primary ways [https://docs.oracle.com/middleware/1221/biee/BIEMG/deploy_rpd.htm#BIEMG1465] of connecting to data sources: 1. Native Gateway [https://docs.oracle.com/middleware/1221/biee/BIEMG/deploy_rpd.htm#BIEMG1179] , such as OCI for Oracle. This

open source

Analysing Social Media Data for the Lightyear Foundation - Part 1

Outside of my job at Rittman Mead, I'm fortunate enough to be involved with a project called the Lightyear Foundation [http://www.lightyearfoundation.org/]. We are a charitable organisation which aims [http://www.lightyearfoundation.org/what-we-do/] to promote the techniques and philosophies of science, working with children and

apache drill

Using Apache Drill with OBIEE 12c

Apache Drill [https://drill.apache.org/] enables querying with SQL against a multitude of datasources [https://drill.apache.org/docs/connect-a-data-source/] including things like JSON files, Parquet and Avro, Hive tables, RDBMS and more. MapR have released an ODBC driver [https://drill.apache.org/docs/installing-the-driver-on-linux/#step-1:-download-the-mapr-drill-odbc-driver] for it,

hdfs

An Introduction to Apache Drill

Apache Drill [https://drill.apache.org/] is an engine that can connect to many different data sources, and provide a SQL interface to them. It's not just a wanna-be SQL interface that trips over at anything complex - it's a hugely functional one [https://drill.apache.

Technical

OBIEE 12.2.1.1.0 - New Feature Guide

Oracle has recently released version 12.2.1.1.0 [http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/business-intelligence-3046226.html] for OBIEE 12c, which has a variety of exciting new features for Data Visualization, BI Publisher, Dashboards in OBIEE, and ODBC connections. It can be performed as an in-place upgrade

Technical

Stream Analytics and Processing with Kafka and Oracle Stream Analytics

In my previous post [http://www.rittmanmead.com/2016/07/introduction-oracle-stream-analytics/] I looked the latest release of Oracle Stream Analytics (OSA), and saw how it provided a graphical interface to "Fast Data". Users can analyse streaming data as it arrives based on conditions and rules. They can also

Technical

An Introduction to Oracle Stream Analytics

Oracle Stream Analytics (OSA) is a graphical tool that provides “Business Insight into Fast Data”. In layman terms, that translates into an intuitive web-based interface for exploring, analysing, and manipulating streaming data sources in realtime. These sources can include REST, JMS queues, as well as Kafka. The inclusion of Kafka

obiee

Announcing OBI Remote Training

Since the release of OBIEE 12c in 2015, we have received countless inquiries about how we would be offering our training. Our customers are familiar with our ability to provide on-site private training for a team and we are well known for hosting training classes in our offices in the

Technical

System Metrics Collectors

The need to monitor and control the system performances is not new. What is new is the trend of clever, lightweight, easy to setup, open source metric collectors in the market, along with timeseries databases to store these metrics, and user friendly front ends through which to display and analyse

Technical

Connecting Oracle Data Visualization Desktop to OBIEE

Recently at Rittman Mead we have been asked a lot of questions surrounding Oracle’s new Data Visualization Desktop tool and how it integrates with OBIEE. Rather than referring people to the Oracle docs on DVD, I decided to share with you my experience connecting to an OBIEE 12c instance

Big Data

Using R with Jupyter Notebooks and Oracle Big Data Discovery

Oracle's Big Data Discovery [https://www.oracle.com/big-data/big-data-discovery/index.html] encompasses a good amount of exploration, transformation, and visualisation capabilities for datasets residing in your organisation’s data reservoir. Even with this though, there may come a time when your data scientists want to unleash their