Rittman Mead Blog - Oracle Data Integrator (ODI)

Migration from Informatica PowerCenter to ODI: accelerated with Sql2Odi

Streamlining ETL Migrations with Sql2Odi I have previously blogged about Rittman Mead's Sql2Odi tool, which translates SQL statements (SELECT or WITH) into Oracle Data Integrator (ODI) Mappings. After years of use, we recently put Sql2Odi to the test during a large ETL migration project. Our goal was to

odi

Assessing the Performance of Looping ODI Package Tasks

Our SQL query extracts data from ODI Repository log tables and can be used to find performance bottlenecks in ODI Load Plans that execute Packages with loops by identifying the most time-consuming Package tasks. ODI Packages often use loops, especially to load CSV files or query APIs that have limits

Oracle Data Integrator

The Case for ETL in the Cloud - CAPEX vs OPEX

Recently Oracle announced [https://www.oracle.com/corporate/pressrelease/launches-integration-cloud-service-021317.html] a new cloud service for Oracle Data Integrator. Because I was helping our sales team by doing some estimates and statements of work, I was already thinking of costs, ROI, use cases, and the questions behind making a decision

odi

ETL Offload with Spark and Amazon EMR - Part 5 - Summary

This is the final article in a series documenting an exercise that we undertook for a client recently. Currently running an Oracle-based datawarehouse platform, the client asked for our help in understanding what a future ETL and reporting platform could look like, given the current landscape of tools available. You

How to Use Versioning in ODI 12c

How many times have you been working on a project and something goes wrong, or the power shuts off, or you go on vacation and someone has messed with your code or somehow your work is lost? Well, now you have an alternative to safe proof your project work. Versioning

odi

OBIEE, Big Data Discovery, and ODI security updates - October 2016

Oracle release their "Critical Patch Update" (CPU) notices every quarter, bundling together details of vulnerabilities and associated patches across their entire product line. October's was released yesterday [http://www.oracle.com/technetwork/security-advisory/cpuoct2016-2881722.html], with a few entries of note in the analytics & DI

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

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

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

Becky's BI Apps Corner: Incrementals and Future Dated Employee Records

During the last few posts, we have delved into a few of the many interesting aspects of a BI Apps installation. Today I wanted to change gears a bit and talk about what starts to happen when you are past installation and configuration and begin running load plans. On a

Technical

Becky’s BI Apps Corner: OBIA install Perl Script Patching and troubleshooting when they fail

During a recent project installing Oracle BI Applications, I became much better acquainted with OPatch, Oracle’s standard tool for managing application patches. By acquainted, I mean how to troubleshoot when OPatch patching fails. Since, at last count, there are around 50 patches total for Oracle BI Applications 11.1.

Big Data

Upgrade to ODI 12c: Repository and Standalone Agent

This is my first post, and I hope to have many more to come. My name is Brian Sauer, and I am fairly new here at Rittman Mead and proud to be here. I have close to 5 years of experience with Oracle Data Integrator, both 10g and 11c. I

Technical

Becky’s BI Apps Corner: Oracle BI Applications, where art thou?

Hello! I would like to take a moment to introduce myself. My name is Becky Wagner and I’ve been working with Rittman Mead America since the beginning of the year. I have a background in data warehousing and ETL with a state government agency, where I was part of

Big Data

Oracle OpenWorld 2015 Roundup Part 2 : Data Integration, and Big Data (in the Cloud...)

In yesterdays part one of our three-part Oracle Openworld 2015 round-up [https://www.rittmanmead.com/blog/2015/11/oracle-openworld-2015-roundup-part-1-obiee12c-and-data-visualisation-cloud-service/] , we looked at the launch of OBIEE12c just before Openworld itself, and the new Data Visualisation Cloud Service that Thomas Kurian demo’d in his mid-week keynote. In part two we’

Technical

Managing the OBIEE BI Server Cache from ODI 12c

I wrote recently about the OBIEE BI Server Cache and how useful it can be [https://www.rittmanmead.com/blog/2015/09/obiee-bi-server-cache-management-strategies/], but how important it is to manage it properly, both in the purging of stale data and seeding of new. In this article I want to show

Technical

OBIEE BI Server Cache Management Strategies

The OBIEE BI Server cache can be one of the most effective ways of improving response times of OBIEE dashboards. By using data already in the cache it reduces load on the database, the network, and the BI Server. Should you be using it? I always describe it as the

Technical

Oracle Data Integrator to load Oracle BICS and Oracle Storage Cloud Service

It is known that Oracle focuses its sales on cloud this year and in the BI world, we have seen the introduction of Oracle Business Intelligence Cloud Service [https://cloud.oracle.com/business_intelligence] – BICS – that we already covered on the blog [http://www.rittmanmead.com/tag/bics/]. Another great

Technical

Using Streams with ODI12c for Oracle-to-Oracle Change Data Capture

Although Oracle GoldenGate replaced Oracle Streams a couple of years ago as the recommended data replication and change data capture technology for Oracle databases, many customers still on Oracle Database 11gR2 or earlier still use Streams for Oracle-to-Oracle change data capture as it works and compared to GoldenGate doesn’t

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

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?

Technical

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

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

Technical

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

Technical

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/