ODIExperts.com

The blog for Oracle Data Integrator ( ODI )

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
53 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
18 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

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


© Copyright 2024 | All Rights Reserved


Creative Commons License


Scroll to Top