Oracle Data Integrator Cloud Service is a new-ish cloud service from Oracle that allows us to run ODI as a platform in the Oracle Cloud. There are a lot of moving parts to this cloud service, so the first part of this article will cover creating the Oracle Cloud Database, The Java Cloud Service, and
Installing Oracle Data integrator Cloud Service (ODICS) Read More »
Cloud, ODI, Red Pill Analytics Tips, TipsLast time I went through some of the basics about getting the latest patch-set of ODI to connect to a GitHub.com VCS repository. Today I will talk a little about versioning our ODI development in Git. Navigator The first point to make is that we can select the objects we wish to version-track in Git,
Using ODI with Git Versioning — Part 1: The Basics Read More »
GitHub, ODIOne of the features of Oracle Data Integrator that sets it apart from other data integration tools is the use of Knowledge Modules to define how parts of the data integration process occur. The developer creates a data load mapping from sources, joins, filters and targets (and in ODI 12 even more components are available).
Modules of Knowledge Read More »
Big Data, ODI, SnowflakeAt work last week I lifted the covers on the Red Pill Analytics Slowly Changing Dimension ODI IKM for Oracle. If you haven’t heard about this knowledge module, it was specifically written to take a dimension source table and transform it to a slowly changing dimension target table. Unlike other similar IKMs, this module uses
Mind the Gap — Getting the Number on ODI Sequences Read More »
ODI, TipsIn the depths of time before ODI 12c, ODI Studio had a fairly simple canvas to design our interfaces. We dropped on our datastores (tables) and then dragged columns between tables to create joins, and columns to the canvas to make filters. If we needed to use expressions we just typed them on the target
ODI 12 LOOKUP Components Read More »
ODI, TipsThis is my first contribution on Medium under the Red Pill Analytics brand. I hope I will keep up the high standards of my co-workers. One of the projects I have been working on recently had a requirement to enrich some data by bringing back additional information from a legacy system, For various reasons they
A Thought on ODI Variables Read More »
ODIIf you’ve ever looked at the ODI Menu Bar or File menu, you’ve seen that there are two separate save options: Save and Save All. Big deal, right? Everyone knows the difference between Save and Save All. (If you don’t, Save will save only one object at a time, the active object you have open/are
ODI Save vs. Save All Read More »
ODI, TipsODI 12c Studio slow to respond? Receiving low or out of memory warnings? ODI 12c Studio crashing? With an out-of-the-box ODI 12c installation, the memory allocated to ODI Studio is generally too low to handle complex tasks — multiple modifications on a complex mapping, regenerating multiple scenarios, prolonged development sessions, etc. When completing such complex tasks over
Having ODI 12c Studio Performance & Memory Issues? Read More »
ODI, Tips