Rittman Mead Blog - Oracle Data Integrator (ODI)

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

odi12c

Oracle Data Integrator 12c: Getting Started - Developer's Quickstart

I’ve decided that it’s time for a refresher on Oracle Data Integrator 12c. This week in the “[Oracle Data Integrator 12c: Getting Started]( http://ritt.md/odi12c-getting-started" target="_blank)” series: getting a quick start on mapping development. Several objects must be created before a single bit

odi12c

Oracle Data Integrator 12c: Getting Started - Installation and Configuration

I’ve decided that it’s time for a refresher on Oracle Data Integrator 12c. This week, I’m continuing the “[Oracle Data Integrator 12c: Getting Started]( http://ritt.md/odi12c-getting-started" target="_blank)” series with the next topic: Installation and Configuration. I don’t plan to dig into

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

odi12c

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/

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

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 "

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

Data Integration Tips: ODI 12c – Who Changed My Table Names?

It’s Sunday night (well, technically Monday morning now), and we have just enough time for another one of my Data Integration Tips. This one, revolving around Oracle Data Integrator 12c, has been on my mind for some time now, so I figured we better just get it out there.

Technical

Data Integration Tips: Oracle Data Integrator 12c Password

Hey, everyone. It's Sunday night, and we have just enough time for another Data Integration Tip from Rittman Mead. This one has originated from many years of Oracle Data Integrator experience—and a lost 12c password. Let me start first by stating there is never any blame placed

Big Data

Rittman Mead at Collaborate 16: Data Integration Focus

It’s that time of year again when Oracle technologists from around the world gather in Las Vegas, Nevada, to teach, learn, and, of course, network with their peers. TheCollaborate 16 [http://collaborate.ioug.org/]conference, running for 10 years now, has been a collaboration, if you will, between 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

Data Integration Tips: Oracle Data Integrator - Quotes in Variables

It's Sunday night, and we havejust enough time for another quick Data Integration Tip from Rittman Mead. In another recent, yet somewhat trivial, challenge I ran into this week was the ability to pass quotations through to a Scenario as a part of an ODI 11g Variable (this

Technical

Data Integration Tips: ODI 12c Repository Query - Find the Mapping Target Table

Well, it’s been awhile since I’ve posted one of our Rittman Mead Data Integration Tips, so I thought a recent challenge might be the next great candidate. I was working through the Kimball ETL Subsystems [http://www.kimballgroup.com/data-warehouse-business-intelligence-resources/kimball-techniques/etl-architecture-34-subsystems/] and the Error Event Schema, Subsystem

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

Kickstart Your 2016 with Rittman Mead's Data Integration Training

Happy Holidays and a Happy New Year to all! As you begin your 2016 this January, it’s time to start planning your team's data integration training. Look no further than Rittman Mead’s Oracle Data Integrator training course! We offer a 4 day Oracle Data Integrator 12c

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

Technical

Rittman Mead at UKOUG Tech'15 Conference, Birmingham

This week Rittman Mead are very pleased to be presenting at the UK Oracle User Group’s Tech’15 Conference [http://tech15.ukoug.org] in Birmingham, delivering a number of sessions around OBIEE, Data Integration, Cloud and Big Data. If you’re at the event and you see any of

Big Data

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

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

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