goldengate - Rittman Mead

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'

Technical

Rittman Mead at KScope16

June is the perfect month: summer begins, major football [http://www.uefa.com/uefaeuro/] (andfutbol [http://www.ca2016.com/]) tournaments are in full swing, and of course, KScope16 [http://kscope16.com/] is on! Rittman Mead have participated in many of the past KScope conferences and will continue that tradition this

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

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

Technical

Practical Tips for Oracle BI Applications 11g Implementations

As with any product or technology, the more you use it the more you learn about the "right" way to do things. Some of my experiences implementing Oracle Business Intelligence Applications 11g have led me to compile a few tips that will improve the overall process for installation

Technical

GoldenGate and Oracle Data Integrator - A Perfect Match in 12c... Part 4: Start Journalizing!

In this post, the finale of the four-part series "GoldenGate and Oracle Data Integrator - A Perfect Match in 12c", I'll walk through the setup of the ODI Models and start journalizing in "online" mode. This will utilize our customized JKM to build the

Technical

GoldenGate and Oracle Data Integrator - A Perfect Match in 12c... Part 3: Setup Journalizing

After a short vacation, some exciting news [https://twitter.com/oracleace/status/476771642883203073], and a busy few weeks (including KScope14 in Seattle, WA [https://www.rittmanmead.com/blog/2014/06/rittman-mead-at-odtug-kscope14-seattle/]), it's time to get the "GoldenGate and Oracle Data Integrator - A Perfect Match in 12c&

Technical

Data Integration Tips: GoldenGate on RAC - Action Script for Windows

I want to briefly interrupt my blog series on GoldenGate and ODI - A Perfect Match in 12c... [https://www.rittmanmead.com/blog/2014/05/goldengate-odi-perfect-match-12c-1/] to provide another Data Integration Tip that was found during a recent client engagement. I was tasked with installing GoldenGate 11g into a 2-node

Technical

GoldenGate and Oracle Data Integrator - A Perfect Match in 12c... Part 2: Journalizing Knowledge Module

This is the second post in a blog series on the integration between Oracle Data Integrator (ODI) 12c and GoldenGate 12c. Thefirst post [https://www.rittmanmead.com/blog/2014/05/goldengate-odi-perfect-match-12c-1/] focused on the latest, yet-to-be-released, Oracle Information Management Reference Architecture and some high-level features new to the 12c versions

Technical

GoldenGate and Oracle Data Integrator - A Perfect Match in 12c... Part 1: Getting Started

Over the years, I've blogged quite a bit about integration between Oracle Data Integrator and GoldenGate, and how to make it all work with the Oracle Reference Architecture. With the release of the 12c versions of ODI [https://www.rittmanmead.com/blog/2013/10/oracle-data-integrator-12c-release-part-1/] and GoldenGate [https:

Technical

Oracle BI Apps 11.1.1.7.1 – GoldenGate Integration - Part 4: Initial Load and Replication

This is the final post in my series on Oracle BI Apps 11.1.1.7.1 and GoldenGate Integration. If you have been following along up to this point, we have the Source Dependent Data Store schema setup and ready to accept data from the OLTP source via replication,

Technical

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

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]

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 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

GoldenGate and Oracle Data Integrator - A Perfect Match... Part 3: Real-time ETL Challenges

I've finally had the chance to sit down and properly closeout this series on GoldenGate and Oracle Data Integrator. Since the last post, I’ve actually presented this topic on three different occasions. Once at each of the Rittman Mead BI Forums [https://www.rittmanmead.com/blog/2013/

Technical

GoldenGate and Oracle Data Integrator - A Perfect Match... Part 2: Replicate to Staging and Foundation

It has been quite a hectic month since my last post, GoldenGate and Oracle Data Integrator – A Perfect Match Part 1: Introduction [https://www.rittmanmead.com/blog/2013/02/goldengate-and-oracle-data-integrator-a-perfect-match-part-1/] . Plenty of client work and delivery of two ODI 11g Bootcamp training [http://www.rittmanmead.com/training/trn-403-odi-11g-bootcamp/] courses have

Technical

GoldenGate and Oracle Data Integrator - A Perfect Match... Part 1: Introduction

Last week, I was in Denver, Colorado presenting at the Rocky Mountain Oracle Users Group Training Days conference. This was my first time at the RMOUG [http://www.rmoug.org/] conference and I have to say, with the number of great topics being presented during any given session time, I

Technical

Alternatives to the Summary Advisor for Refreshing Exalytics Aggregates

One of the several elements of Exalytics' power comes from it holding pre-calculated (aggregated) data in the TimesTen for Exalytics In-Memory Database. Exalytics comes with a tool called the Summary Advisor (which Mark Rittman has written about previously here) [https://www.rittmanmead.com/blog/2012/03/oracle-exalytics-week-the-summary-advisor/] which suggests