ODI(Oracle Data Integrator) Knowledge Modules

Hi All,
          Please check the below link to understand the KM's for better understanding.

          https://www.youtube.com/watch?v=VzHgbFyjwHA&t=7s

ODI 12c Installation Steps

Hello All,
Here we will see how to install ODI 12c, It include's Oracle 11G Express Edition and configuring the RCU.

Installing Oracle 11G Express Edition

Note down the password for the later use

Installing ODI 12C

Make sure that you have already installed the compatible JDK

If you wish to provide email else click on Yes button.

Once  installation done successfully then go to the location, where you installed the ODI.

For example- Oracle\Middleware\Oracle_Home\odi\studio                                              

When you start the ODI studio first time then it will ask you for the JDK location.         

             Now we installed the Oracle Express Edition and ODI 12c, Now we will set up the RCU.

             Here you need not install the separate RCU utility, as it comes with ODI 12c.
         
             To start the RCU installation go to the below location and click on rcu.bat
             and follow the given below screenshots.

                  Better to use the sys user name and the same password which you provided at the time of XE installation.                                                                                

                    Note down the password.

Here we are configuring the ODI repositories. Note down the below details

        
                Configuring repositories in ODI studio

                 Note down the password because every time ODI will ask you this password before                              logging into the repositories

                 Use the details which you provided at the time of creation of the RCU.

                Once you test this connection successful then you will be able to see the work repository.
                Now you can connect to the work repository and see the designer tab, which ODI                                 developer uses for the development.

ORACLE DATA INTEGRATOR DATA SERVICE 11G

Prerequisite:-

Bellow components should be installed on your system:-

1)      Oracle Data Integrator 11g

2)    Oracle Weblogic 10.3.6

About this project:-

One of the most striking features in ODI is its ability to fully integrate into a SOA (Service Oriented Architecture) environment. Data services expose the enterprise data and make it available to users in the form of a web service. Using ODI, you can both create data services and then consume them via web services. I will explain to how to create and deploy a data service in Oracle Data Integrator.

Connect to ODI_STAGE schema by using sqldeveloper

Create table

create table KSTUDENT(

studentid int primary key,

studentname varchar(20)

);

Then create physical and logical schema for oracle technology in ODI.

Under Technologies in the topology navigator, select JAX-WS and create a new data server, physical and logical schema as follows

 

Create new JDBC data source for schema

Start the weblogic server and make sure it is in Running mode. Log on to the Weblogic console

Start the weblogic server and make sure it is in Running mode. Log on to the Weblogic console (the default URL for the Weblogic console is http://localhost:7001/console) and navigate to Services –>  Data Sources

Create a new Generic Data Source and name it JDBC KE. AS JNDI name we mention jdbc/KE

Click on both server

Now you can see your Data Source you just created(JDBC KE)

Then import knowledge module as shown in given image.

Click on ODI_STAGE model folder

Go to the service tab and add the following details.

Finally, click the Generate and deploy option and your data service will be successfully deployed in the autodeploy folder!

Click on the Deployment options in EM console of weblogic.

 

Click on below lick

By clicking first link you can see WSDL file for your Data Service & By using second link you can test your service.

Add Operation

  

Add Operation

Update operation

 

Delete Operation