ODIExperts.com

The blog for Oracle Data Integrator ( ODI )

January 19, 2010
by kdevendr
16 Comments

Categories: How to , Logic , ODI , Reports , Technology , Tips and Tricks

Single Post View


Interface Mapping Query

This query will show the interface  mapping  in the following order PROJECT_NAME  , FOLDER_NAME  ,  INTERFACE_NAME  , INTERFACE_TYPE , TARGET_SCHEMA , TARGET_TABLE , TARGET_COLUMN , TARGET_DATATYPE , SOURCE_SCHEMA , SOURCE_TABLE , SOURCE_COLUMN , SOURCE_DATATYPE , MAPPING  filtered by Interface , … Continue reading

November 23, 2009
by kdevendr
2 Comments

Categories: Administration , Architecture , Logic , ODI , Technology , Tips and Tricks

Tags: , , , ,

Single Post View


Export – Import DWR to DWR having same Master Repository

For this particular Example I am exporting Project, Models and all the other objects under it from ODI_DEV [ DWR ] environment to ODI_TEST [ DWR ] where DWR is Development Work Repository Step 1 – Export the Project Specify … Continue reading

October 5, 2009
by Cezar Santos
11 Comments

Categories: Architecture , ODI , Technology

Tags: , , , , , , ,

Single Post View


Repository Architecture – Work Repository, Development or Execution? When and why uses each one.

Hi Friends, I got a lot of emails asking me what is the difference between Development Work Repository (DWR) and Execution Work Repository (EWR) and too, why and when use each one. In this post, I will try to explain … Continue reading

September 23, 2009
by kdevendr
6 Comments

Categories: ODI , Technology

Tags: , , ,

Single Post View


SQL Server connection

Connecting Oracle Data Integrator and MS SQL Server 1. Refer to this Download link for Microsoft SQL Server 2005 JDBC Driver 1.2 http://www.microsoft.com/downloads/details.aspx?FamilyId=C47053EB-3B64-4794-950D-81E1EC91C1BA&displaylang=en and for Microsoft SQL Server JDBC Driver 2.0 here http://www.microsoft.com/downloads/details.aspx?familyid=99B21B65-E98F-4A61-B811-19912601FDC9&displaylang=en JDBC Driver 1.2 Extract the downloaded .exe … Continue reading

September 21, 2009
by kdevendr
9 Comments

Categories: ODI , Technology

Single Post View


Connecting openLDAP

In Hyperion EPM 11 , authentication information is stored in openLDAP . To get more information for the Hostname , port name , log into your Hyperion Shared Service console and under ‘ Administration ‘ click on ‘ Configure User … Continue reading

September 6, 2009
by kdevendr
5 Comments

Categories: Drivers , ODI , Technology

Single Post View


Oracle to Flat file

This is the Sample of source Table to be populated as Flat File. Target [Flat File – region.dat] 1. Go to the Physical architecture of the Topology and insert a New Data Server under File Technology 2. For the JDBC … Continue reading

August 16, 2009
by Cezar Santos
5 Comments

Categories: Drivers , Knowledge Modules , ODI , ODI Bug , Technology , Tips and Tricks

Tags: , , ,

Single Post View


Welcome to ODI Experts, this is Cezar Santos.

Hi everyone! I’m really glad to start this site to share knowledge and exchange experiences with everyone that wants! That is an old project that only comes true because I found a really good friend and a incredible professional guy … Continue reading


© Copyright 2018 | All Rights Reserved


Creative Commons License


Scroll to Top