Oracle Data Integrator (ODI)/Sunopsis – Architecture & Installation overview

hi
i am begginer
i am put in the project where odi is used to integrate the data

i have no idea how to use this tool

i have just downloaded the software thats it

can u tell me how to use the tool and how to integrate data

kindly let me with understable examples pls

thanks

@ Shakir
Check this user guide for Oracle Data Integrator

http://www.oracle.com/technology/products/oracle-data-integrator/10.1.3/htdocs/documentation/oracledi_users.pdf

Hi Atul,
Thanks for the useful information.
I am doing a proof of Concept(POC) on ODI for our organisation.
I have to validate ODI(data profiling and data quality also) in our LAB environment.

Could you please let me know all the hardware i have to request for installation.

1) Graphical modules, i will be installing on my system.
2) For repository,i will request my DBA for DB space.
3) scheduler Agent — ? what i need .
4) Metadata navigator/lightweight Des — ?
5) data profiling and data quality —- ?

Please throw some light
Thanks
Siddhart.

[…] from Trillium and Oracle ship it as part of Oracle Data Integrator (ODI) software. More on ODI here and […]

Hi Atul,

An initial question:
Oracle Data Integrator 10g (10.1.3.5.0) is incorpored by Fusion Middleware or is there a new ODI version called 11g (what number)?

The ODI has the Operator tool to handle its environment incidents (error handling), and we actually use Operator for ODI implementations. However, considering that ODI is not a component of SOA Suite 11g, there is a specific question regarding its Architecture of Operation:

Is it possible monitor and manage ODI E-TL instances through Oracle Enterprise Manager 11g Fusion Middleware Control (FMC)?

If yes, do you have any material about?

Thanks,
Mauricio.

@ Mauricio,
In theory ODI is part of FMW (Fusion Middleware) but it ois still
Standalone product. Hopefully with ODI 11g (not yet out) we should see
and next version of FMW 11g R2 (not yet out) We should see more tight integration.

About monitoring using EM grid control or FMC – I don’t think it is possible to monitor
However it is better to raise support call with oracle support EM grid control or FMW control team

Hi Atul,

i am installing odi on vista, after giving the master repository details i am getting error
“java.io.FileNotFoundException: .\snps_login_work.xml(Access denied)”.

Pls help me in resolving this issue.

thanks,
Sateesh.

@ Sateesh,

Do you see this file in $ODI_HOME\oracledi\bin and if yes do you have write permission

[…] Upgrade Oracle Data Integrator 10.1.3.5 to 10.1.3.6 (9377717) Posted in March 24th, 2010 byAtul Kumar in odi, odq  Print This Post If you are new to ODI (Oracle Data Integrator) then first look at ODI Architecture and Installation here […]

Particularly, I didnt understand KMs. How can we create steps in DETAIL tab in creating a KM? and need what is meant by KM in simple terms.

Hi Atul,

Do we need root for installing ODI on Linux or any normal account would do? what groups should ODI user belong to ?

@ Mani,
You would install ODI using non-root account like oracle database but in the end you will have to run root.sh from root account

hi Atul

Do u know when ODI 11 is coming out? or is it already out?

Thanks

ODI 11g is released and waiting for the free download as status says ‘comming soon’

Hi,

Is there any difference between Oracle Data Integrator 10.1.3.5 and ODIEE? Is ODIEE a separate software?

Thanks

hi,
i have install odi 11g software in windows as client and unix platform as server.In odi 11g how can i know which is client and which is server .

./root.sh

WARNING: NIS Detected.
Please ensure that the services entry uses files,
otherwise this installation of the Metabase may not
function correctly.
ERROR: This port number is in use.
ERROR: Invalid port id.
while executing
“if { [catch {

#—————————-
# Handle command-line options

set optlist [list {
nochecks “Don’t do checks”} {
version …”
(file “setup.tcl” line 1027)

🙁

@ lesly_natasha@hotmail.com

Which version of ODI you are installing ?

Your issue is that port is in USE.

To find port it is trying to use, open root.sh and see if port is mentioned in this file . If not open any other sh filw which root.sh is invoking

Works!

root.sh

#!/bin/sh
/usr/lib/oracle/ODI/install/Metabase_Manager/unix/Linux/setup -root -user yair -home /home/yair -instdir /usr/lib/oracle/ODI/oracledq/metabase_server -clientPort 7610 -schedPort 7611

./root.sh

Writing installation log to: /usr/lib/oracle/ODI/oracledq/metabase_server/metabase/etc/setup.log
calculating service labels…
installing services…
restarting inetd…
Root installation finished.

thank you very much friend!

Hi all,

We are doing POC on ODI

The requirement like this : Need to connect ODI with Siebel.

Earl response please

Reg
Srinivas.N

@ Srinivas,

Check this for Oracle Siebel CRM Knowledge Modules in Oracle Data Integrator http://download.oracle.com/docs/cd/E17904_01/doc.1111/e17466/oracle_siebel.htm#BEICCFEB

can you share me the how to integrate ODI with siebel EIM

Early response appreciated.

Reg
Srinivas.n
snarava@gmail.com

@ Srinivas,
I don;t think you looked at link given by me in previous update.

Is your integration requirement not covered in

http://download.oracle.com/docs/cd/E17904_01/doc.1111/e17466/oracle_siebel.htm#sthref32 ?

Hi Atul,

Thanks for replying.. I have seen the document.it’s a good one.

I have Installed ODI 11 version i.e. latest one. in Red Hat Linux

For this i have installed the below softwares

—Oracle Database 11.2.0.1.0
—RCU
—ODI 11g
—Weblogic application server 10.3.5.0.
—Linux OS version : Red Hat Enterprise Linux Server release 5.5

The above software are perfectly installed and all are up and running.

Queries :

1 . Is it Data quality and Data profile are mandatory to install in linux ?

As per my knowledge these two s/w’s are available for the windows OS only.

Note : I am very new to the O D I.

2. Topology.sh file was not created in the oracle home directory in which ODI was installed.

How to we create the above file in Oracle home directory if it was not created.

3. Could you share me some ideas about how to integrate the ODI with EIM.

Could you please clarify my doubts and get back to me soon.

Regards
Srinivas

[…] Oracle Data Integrator (ODI) is an E-LT (Extract – Load & Transform) based data transformation and integration tool. This post covers overview (and architecture) of ODI 11g, for ODI 10g (earlier Sunopsis) click here […]

Hi

I installed the ODI 10.1.3.5 and applied the patch 10.1.3.6. Lauched the designer and created the connection. The test connection was successful. I clicked OK , the window is not closing. can anyone plz help.

Thanks
Srini

Hi Atul – I have read through 4-5 of your articles , need some help and pointers regarding how to install ODI 11g (11.1.1.5.0) on Linux environment. We need High Availability feature as well, so we have a Linux box where Weblogic is installed – which steps should be followed to install ODI on Linux box, what are the options we need to select during installation. Can you please guide me and send me an email.

Thanks

Really appreciate your help.

Regards

I am having trouble while connecting installed Oracle Data Int.

I installed Oracle weblogic 10.3.6 and create domain and Installed ODI and include it with the domain.
I installed Java EE installtion type for ODI.

Installation goes OK.
But later on i try to connect agent from ODI studio to the server. and the test failed.

I also figure out there is no directory with name “agent” inside oracle_common in the server. I am not able to open ODI console also (only admin console ; admin server and odi_server is running).

I think Missing agent directory is the key thing i am not able to connect with server.
I don’t know how come this directory is not inside oracle_common in the server.
Please, anyone tell me the process and suggestion.
I already cross deadline so it’s giving so much stress.

Thank you very much,

Hi. Mr. Atul.
Iam basically an Oracle Certified DBA
Having interest in Data Mining / Warehouseing and Data Integration.
Started setting up the Environment for Oracle Data Integrator with the following options.
Operating System: Redhat Linux 5.4 32bit
1. Oracle Database 11gR2 (11.2.0.1)
2. Used RCU to create ODI Master and Work Repositories
3. Installed Oracle WebLogic Server 11g using wls1030_linux32.bin
Created AdminServer. Able the Start and Stop
4. JDK is jdk160_29. located in MW_HOME
5. Installed Oracle ODI 11.1.1.6 32 bit

Issue: $ODI_HOME/oracledi/agent/bin/encode.sh utility fails with the following errors.

infact encode.sh was edited for odiparams.sh
(original content is $ODI_HOME/bin/odiparams.sh)
. “$ODI_HOME”/oracledi/agent/bin/odiparams.sh

$ ./encode.sh oracle1 fails
Exception in thread “Main Thread” java.lang.NoClassDefFoundError: oracle/odi/Encode
Caused by: java.lang.ClassNotFoundException: oracle.odi.Encode
at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
Could not find the main class: oracle.odi.Encode. Program will exit.

Could not understand what was the Issue and what settings i have been missing with.

Grateful if you can help in this regard. This really makes me MAD and struggling for more that 1 week

Thanks in Advance.

please send me odi interview questions and answers,

with answers

Hi Atul,

we are planning to set Oracle ResultSetCache for OID. we are using Oracle 11gR2. Can you guide us to how to set this using Console/Unix commands.