ODI Archives - Page 5 of 6

October 19, 2009
by Cezar Santos
12 Comments

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

Tags: ODI , ODI Adminstration , ODI connection , ODI Context , ODI Data Server , ODI Experts , ODI Logical Schema , ODI Physical Schema , ODI repository , ODI Scenario , Oracle Data Integrator , repositories , repository , Sunopsis

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: IN OUT Parameters , ODI , ODI connection , ODI Experts , ODI PL/SQL , ODI variable , Oracle Data Integrator , PL/SQ Functions , PL/SQL Parameters , PL/SQL Procedures , Sunopsis , sysdate

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: ODI , ODI connection , ODI Context , ODI Data Server , ODI Experts , ODI Logical Schema , ODI Physical Schema , ODI repository , ODI Scenario , Oracle Data Integrator , repositories , repository , Sunopsis

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: ODI , ODI connection , ODI Experts , ODI repository , Oracle Data Integrator , repositories , repository , Sunopsis

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
16 Comments

Categories: Architecture , Logic , ODI , Tips and Tricks

Tags: Informix , ODI

AUTOMIZE ODI REPOSITORY EXPORTS

This Post defines the simple process on how to setup automatic daily backup of ODI Master and Work Repository. This process is especially important where there is no backup or improper schedule backup is carried out by DBAs. Steps Export … Continue reading →

September 23, 2009
by kdevendr
1 Comment

Categories: ODI

Tags: Informix , ODI

Informix Connection

To download the Latest driver for Informix, please visit here http://www14.software.ibm.com/webapp/download/search.jsp?go=y&rs=ifxjdbc There is also a driver present for Informix in ODI Driver Name – IBM Informix JDBC Driver JDBC Driver – com.informix.jdbc.IfxDriver JDBC URL -jdbc:informix-sqli://165.202.560. 369:1576:informixserver=infxdw;database=ftp URL Parameters: <host>: server … Continue reading →

September 23, 2009
by Cezar Santos
2 Comments

Categories: Architecture , ODI

Tags: ODI , ODI Experts , ODI repository , Oracle Data Integrator , repository , Sunopsis

Repository Architecture – Two or more Masters – Part 3

Hi Friends, I got some emails and comments asking for publish about how to work with more then one Master Repository and, you will see, it isn’t so complicated. I will use, as base, the post Repository Architecture – Just one … Continue reading →

September 20, 2009
by Cezar Santos
9 Comments

Categories: Architecture , Logic , ODI , Tips and Tricks

Tags: ODI , ODI Experts , ODI Web Services , Oracle Data Integrator , Sunopsis

How to call a Web Service that start an ODI Scenario and waits its complete execution

Hi friends, I just created this technique because I was in a POC (Prove of Concept) and needed to call a WS (Web Service) but the WS must wait the scenario execution until the end and, too, receives a return … Continue reading →

September 10, 2009
by kdevendr
15 Comments

Categories: ODI

Tags: ODI , ODI sequence

Sequence

Database Sequence Create a database Sequence in Oracle. create sequence test_sequence minvalue 2 maxvalue 999 start with 2 increment by 2 Map your interface Call the sequence in the respective column using this format <SCHEMA_NAME>.<SEQUENCE_NAME>.NEXTVAL TEMP.TEST_SEQUENCE.NEXTVAL TEMP – SCHEMA_NAME TEST_SEQUENCE … Continue reading →

September 9, 2009
by Cezar Santos
3 Comments

Categories: Common Errors , ODI , Tips and Tricks

Tags: constant source , ODI , ODI Experts , ODI sequence , Oracle Data Integrator , Sunopsis , sysdate , sysdate source

How to get a constant or pseudo-column from source mapping

Hi, Let me show you a small trick when is necesary to obtain some psedo-column (like rowid) or database function (like sysdate) . If a direct mapping of those values is done, a error like this will happens: For bypass … Continue reading →

ODIExperts.com

The blog for Oracle Data Integrator ( ODI )

Tag Archives: ODI