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-
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: ODI - Use Scenarios in packages Here is another question I often hear during ODI Bootcamp [http://www.rittmanmead.com/training/training-trn405-oracle-data-integrator-12c-bootcamp/] or I often read in the ODI Space on OTN [https://community.oracle.com/community/business_intelligence/system_management_and_integration/data_integrator/] : In a package, should I
Technical Data Integration Tips: ODI - One Data Server with several Physical Schemas Yes, I'm hijacking the "Data Integration Tips" series [http://www.rittmanmead.com/tag/data-integration-tips/] of my colleague Michael Rainey [http://www.rittmanmead.com/author/michael-rainey/] (@mRainey [https://twitter.com/mRainey]) and I have no shame! DISCLAIMER This tip is intended for newcomers in
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
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
Technical Data Integration Tips: ODI 12c - Substitution API GUIDs With the release of Oracle Data Integrator 12c [https://www.rittmanmead.com/blog/2013/10/oracle-data-integrator-12c-release-part-1/] and Oracle GoldenGate 12c [https://www.rittmanmead.com/blog/2013/10/oracle-goldengate-12c-new-release-new-features/] still fresh in our minds, I thought I would start
