Oracle GoldenGate Using logdump to Troubleshoot the Oracle GoldenGate for Big Data Kafka Handler Oracle GoldenGate for Big Data (OGG BD) supports sending transactions as messages to Kafka topics, both through the native Oracle handler as well as a connector into Confluent's Kafka Connect. In some research that I was doing with it I found an interesting problem that I am going to demonstrate
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 when a
Technical Data Integration Tips: Oracle Data Integrator - Quotes in Variables It's Sunday night, and we have just 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 is
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 and the Error Event Schema, Subsystem 5 if you’re familiar with the
Technical Data Integration Tips: ODI 12.1.3 - Convert to Flow The many who have already upgraded Oracle Data Integrator from the 11g version to 12c probably know about this great feature called “convert to flow". If not, well…here you go! First, a little background on why I think this is an excellent bit of functionality. The ODI Upgrade
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... 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 RAC, which is a pretty straight-forward process and
Technical Data Integration Tips: ODI 12c - Varchar2 (CHAR or BYTE) Continuing with our Data Integration Tips series, here's one that applies to both Oracle Data Integrator 11g and 12c. This "tip" was actually discovered as a part of a larger issue involving GoldenGate, Oracle Datapump, and ODI. Maybe a future post will dive deeper into those challenges, but
Technical Data Integration Tips: ODI 12c - Substitution API GUIDs With the release of Oracle Data Integrator 12c and Oracle GoldenGate 12c still fresh in our minds, I thought I would start an ongoing series focused on Data Integration Tips - specifically around the latest version of Oracle's data integration tools. The goal is to provide insight into some of
Technical Oracle Data Integrator 12c Patch - Missing Components While working with a client this week, I came across an interesting issue, and ultimately a workaround, when patching Oracle Data Integrator 12c. But first, a little background... The client was working through the OWB to ODI 12c migration process, detailed nicely by Stewart Bryson in his OTN article, "
Technical Oracle Data Integrator 11g Groovy: Add Columns to a Datastore One of the great new features in Oracle Data Integrator 11.1.1.6 is the integration of the scripting language Groovy right within the ODI user interface. David Allan has written several blog posts on the subject, showing how easy it is to create a project and describing how
