Monthly Archives: March 2011

Oracle Data Integrator 11g Knowledge Modules Description

RKM Oracle Reverse-engineers tables, views, columns, primary keys, non unique indexes and foreign keys. JKM Oracle 10g Consistent (Streams) Creates the journalizing infrastructure for consistent set journalizing on Oracle 10g tables, using Oracle Streams. JKM Oracle 11g Consistent (Streams) Creates … Continue reading

Posted in Uncategorized | 1 Comment

Extracting Hyperion Financial Management Metadata to Oracle Data Integrator

Step: 1) Go to Start—>Program Files—>Oracle—>Oracle Data Integrator explore ODI and login to work repository. Step: 2) After successfully login to work repository go to Topology Navigator select Physical Architecture Tab and select Technology and expand it. Go to the … Continue reading

Posted in Uncategorized | Leave a comment

Configuring ODI for integrating with Hyperion Financial Management Application

I will be using Single-machine architecture; machine will be hosting ODI and hosting HFM and EPM foundation (Workspace and shared services). I have created a FM application named SAMPLE that is based on the “Simple Demo” information that can be … Continue reading

Posted in Uncategorized | Leave a comment

Creating and Connecting to ODI Master and Work Repositories

The first steps to setting up Oracle Data Integrator are to create the Master repository, connect to the Master repository, create the Work repository, and then connect to the Work repository Step:1) Connecting to the RDBMS (Oracle 10g XE) Step:2) … Continue reading

Posted in Uncategorized | 2 Comments

Oracle Data Integrator 11 Installtion Guide

Oracle Data Integrator Installation Guide { var scribd = document.createElement(“script”); scribd.type = “text/javascript”; scribd.async = true; scribd.src = “”; var s = document.getElementsByTagName(“script”)[0]; s.parentNode.insertBefore(scribd, s); })();e

Posted in Uncategorized | 1 Comment