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
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
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
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 space. Each vulnerability is given
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
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 communication breakdown happen between
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.
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’
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
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
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 22.214.171.124.1 release of ODI. It includes various great new functionalities to work on an Hadoop ecosystem. Let's have a look
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?
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
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