DRM 11.1.2.4 Application Creation

Now that we’ve finished the DRM install, it’s time to create a new DRM application. This process is pretty straight-forward as well. As usual, let’s look at some of the pre-requisites. Pre-requisites Create a new repository (ensure you have the database rights to do this). Alternatively, you can choose to run……

Continue reading

Blank Hyperion Workspace Homepage

Sometimes when connecting to Workspace, you will get a message saying the start up document couldn’t load, resulting in a blank Hyperion Workspace homepage. This is because most of the time users have not been granted access to the location where the homepage is stored or sometimes it’s because the homepage file is……

Continue reading

ODI 12c Installation (Standalone install)

PREREQUISITES Download the ODI install file http://www.oracle.com/technetwork/middleware/data-integrator/downloads/index.html. Make sure you have a Java JDK installed. I used the version seen below. The Oracle support matrix shows any version greater than 1.7.0_55 as supported. I’m not sure if 1.8 is supported though so I stuck with version 7. Note that support……

Continue reading

Real World Case Example for ODI Yellow Interface (w/ Dynamic Source and Target)

Until recently, I never encountered a situation where I needed a “yellow interface” in ODI (Oracle Data Integrator). Typical ODI interfaces leverage models that are manually created and point to static objects such as tables or files. On a recent project, I took to ODI to create an automation process……

Continue reading