ODIExperts.com

The blog for Oracle Data Integrator ( ODI )

November 16, 2010
by Cezar Santos
0 comments

Categories: Administration , Architecture , Drivers , How to , Logic , ODI , Tips and Tricks

Tags: , , , , ,

Single Post View


11g Oracle Data Integrator – Part 7/11g – SUNOPSIS MEMORY ENGINE

Hello everyone. As this is a feature that comes from 10g but still present at 11g and pretty useful, we decide to discuss it as “11g part”. You will see that it’s really useful in several situations. We all have … Continue reading

September 29, 2010
by kdevendr
21 Comments

Categories: Administration , Architecture , Drivers , How to , Logic , ODI , Tips and Tricks

Tags: , ,

Single Post View


Drivers Location in ODI 11g

Hi…. A small but very helpful tip! Initially when I was scrolling  the documentation there were two location where we would need to place the Drivers one in <WINDOWS_USER_HOME>AppDataRoamingodioraclediuserlib and the other will be the <ODI_HOME>/agent/oracledi/drivers  Folder. It confused me … Continue reading

August 25, 2010
by Cezar Santos
19 Comments

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

Tags: , , , , , ,

Single Post View


Calling OdiSqlUnload using ODI Procedure with no hardcoded password

Hello all, OdiSqlUnload is a great utility for unloading  but then we need to hardcoded and provide the parameters of the username and password which can change in the Other Environment in ( Testing , UAT or Prod ) . … Continue reading

April 9, 2010
by Cezar Santos
30 Comments

Categories: Administration , Architecture , How to , ODI , Tips and Tricks

Tags: , , , , , , , , , ,

Single Post View


Interface Parallel Execution – A new solution

Hi Friends, Two days ago Devendra talk to me about parallel executions in ODI and we are discussing the solution from Oracle Metalink that works but, at true, I never was stopped to analyse. In face of that, I decided … Continue reading

November 20, 2009
by Cezar Santos
22 Comments

Categories: Architecture , How to , Logic , ODI , Tips and Tricks

Tags: , , , , , , , , , , , , , , , , , , , , , ,

Single Post View


Procedures (or KM) Steps – Source and Target tab’s

Hi All, There is some time that I don’t write a post, it’s because of the amount of work… too much clients, too much process… but all is perfect! I mean, work needs to exists because then it’s necessary people … Continue reading

October 30, 2009
by Cezar Santos
7 Comments

Categories: Architecture , Common Errors , Logic , ODI , Tips and Tricks

Tags: , , , , , , , , , , , , , , ,

Single Post View


Subscribers – An example of how to use

Hi friends, I was helping in a thread at ODI Forum, from Oracle page (http://forums.oracle.com/forums/forum.jspa?forumID=374) and I decided to describe the situation here once several people ask me similar questions What is a Subscriber and how to use it? A … Continue reading

October 22, 2009
by Cezar Santos
13 Comments

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

Tags: , , , , , , , , , , , , , , , ,

Single Post View


How to show Business Messages on Operator and, too, debug variables…

Hi Guys, I frequently got emails asking how to do show Business messages on OD and, as there isn’t such feature until version 10.1.3.5, I created a way to have it. It’s just like a magic trick! We will need … Continue reading

October 19, 2009
by Cezar Santos
12 Comments

Categories: Administration , Architecture , How to , ODI , Tips and Tricks

Tags: , , , , , , , , , , , , ,

Single Post View


Topology – Data Server – Which user should be used to connect?

Hi All, Today we will discuss about which database user can be used at Data Server (Topology) and why. As usual, Oracle database will be used in the example. When you start with ODI, one of the firsts things to learn is … Continue reading

October 16, 2009
by Cezar Santos
52 Comments

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

Tags: , , , , , , , , , , ,

Single Post View


How to use PL/SQL procedures and functions in ODI

Hi people, It’s very frequent I got emails asking me how to use PL/SQL function and procedures in ODI. For that, all you need is an Anonymous blocks of PL/SQL. That is all. A single example is: 1 – Situation: … Continue reading

October 12, 2009
by Cezar Santos
17 Comments

Categories: Architecture , ODI

Tags: , , , , , , , , , , , ,

Single Post View


Context, Logical And Physical Schema – How does it work?

Hi people, Let me try to explain a subject that I already got a lot of emails asking me about how it works: Data Server Physical Schema Logical Schema Context It’s very common doubts raises from this combination because it is … Continue reading


© Copyright 2017 | All Rights Reserved


Creative Commons License


Scroll to Top