Complete Installation and configuration of Oracle Data Integrator (ODI), ODI Web Services with JDeveloper, BPEL

(From http://blogs.oracle.com/kavinmehta/entry/complete_installation_and_conf)

Installing Oracle Data Integrator, Oracle Data Profiling, Oracle Data Quality

• Click on setup.exe . Click Next

• Check "Oracle Data Integrator, Oracle Data Profiling, Oracle Data Quality 10.1.3.5.0" and click next

• Check "Complete" and Click next

• Specify ODI Home name and location. Click Next

• Specify port, click Next

• Specify host name and ports, I left them at default ones.

• Again left at default one

• Check summary and click Install

Configuring Repository

• After install is finished execute the script to create master and work repository user. You can use the one I did

-- tablespace for master repository
create tablespace ts_odim
  logging
  datafile 'C:\oracle\ora10g\database\oradata\orcl\ts_odim.dbf'
  size 32m
  autoextend on;
-- tablespace for work repository
create tablespace ts_odiw
  logging
  datafile 'C:\oracle\ora10g\database\oradata\orcl\ts_odiw.dbf'
  size 32m
  autoextend on;
create temporary tablespace tmp_odi
  tempfile 'C:\oracle\ora10g\database\oradata\orcl\tmp_odi.dbf'
  size 32m
  autoextend on ;
-- USER SQL
CREATE USER snpm IDENTIFIED BY snpm123
DEFAULT TABLESPACE TS_ODIM
TEMPORARY TABLESPACE TMP_ODI;
GRANT CONNECT, RESOURCE TO snpm;
CREATE USER snpw IDENTIFIED BY snpw123
DEFAULT TABLESPACE TS_ODIW
TEMPORARY TABLESPACE TMP_ODI;
GRANT CONNECT, RESOURCE TO snpw;

• Launch bin/repcreate.bat or bin/repcreate.sh to create Master Repository. Complete fields and click OK

 

• When prompted, click OK

• To connect to the Master repository launch the Topology Manager script (bin/topology.bat or bin/topology.sh)
• Click on the button New

• Click on Test to check the connection is working. Validate by OK, then OK. Topology Manager opens.

• The default password of the SUPERVISOR is SUNOPSIS.

• In the icon list Topology -> Repositories -> Work repositories, click with the right button,
  then choose Insert work repository.

• In the connection window, complete the parameters and click OK

• Click JDBC tab

• New Work Repository can be seen in topology manager now

• To connect to a work repository and launch the Designer module

• Click on the button New

• Complete the fields, test connection and click ok

• Now connect to work rep using SUPERVISOR/SUNOPSIS

• New Designer window will open up for current repository

Deploying ODI Web Applications - Lightweight Designer

• Open Enterprise Manager console
• Click oc4j_odi - Applications - Deploy
• Browse to location <ODI_DOWNLOAD_DIR>\setup\Manual and select oracledilwd.war file (Lightweight Designer)

 

• Click Next

• Accept default values, click Next

• Click Deploy

• Check deployment report for any errors and click Return.

• Test Application at http://oc4j_host:oc4j_port/oracledilwd/

Configuring Repository Connections

• Lightweight Designer connects the repositories though JDBC datasource. Update data-sources.xml to have connection pool and datasources configured as below.

<managed-data-source user="snpm" password="snpm123" connection-pool-name="ODI_CONNECTION_POOL" jndi-name="jdbc/ORACLE_MASTER" name="ODI_MASTER_DS"/>
<managed-data-source user="snpw" password="snpw123" connection-pool-name="ODI_CONNECTION_POOL" jndi-name="jdbc/ORACLE_WORK" name="ODI_WORK_DS"/>
<connection-pool name="ODI_CONNECTION_POOL">
   <connection-factory factory-class="oracle.jdbc.pool.OracleDataSource" url="jdbc:oracle:thin:@//localhost:1521/orcl"/>
</connection-pool>

• Add the entries to link the datasource in the application context. Edit web.xml located under <OC4J_ODI>\applications\oracledilwd\oracledilwd\WEB-INF\web.xml

<resource-ref>
    <description>Oracle Datasource for the Master Repository</description>
    <res-ref-name>jdbc/ORACLE_MASTER</res-ref-name>
    <res-type>javax.sql.DataSource</res-type>
    <res-auth>Container</res-auth>
    <res-sharing-scope>Unshareable</res-sharing-scope>
</resource-ref>
<resource-ref>
    <description>Oracle Datasource for the Work Repository</description>
    <res-ref-name>jdbc/ORACLE_WORK</res-ref-name>
    <res-type>javax.sql.DataSource</res-type>
    <res-auth>Container</res-auth>
    <res-sharing-scope>Unshareable</res-sharing-scope>
</resource-ref>

• Define the Lightweight Designer login information to the work repositories. Edit repositories.xml located under <OC4J_ODI\applications\oracledilwd\oracledilwd\

<login name="My Work Repository">     <master name="jdbc/ORACLE_MASTER" masterDriver="oracle.jdbc.OracleDriver"/>
    <work name="jdbc/ORACLE_WORK" workName="WORKREP"/>
</login>

Deploying ODI Web Applications - Metadata Navigator

• Click oc4j_odi - Applications - Deploy

 

• Browse to location <ODI_DOWNLOAD_DIR>\setup\Manual and select oracledimn.war file (Metadata Navigator). Click Next

• Accept defaults, click Next

• Click Deploy

• Check deployment report for any errors and click Return.

• Test Application at http://oc4j_host:oc4j_port/oracledimn/

Configuring Repository Connections

To configure the connections to your repositories in the web application, we need to follow two steps.

• Configure the connection to the work repository in Designer.
• Copy the snps_login_work.xml file from <ODI_HOME>\oracledi\bin directory into <OC4J_ODI>\applications\oracledimn\oracledimn\WEB-INF/WEB_INF

Configuring Apache Axis 2 (ver 1.2)

• Download Axis 1.2 WAR file from http://ws.apache.org/axis2/download/1_2/download.cgi. It would be a zip file download, simply rename it to axis2.war
• Click oc4j_odi - Applications - Deploy

• Provide WAR file location and click next

• Provide WAR file location and click next

• Provide WAR file location and click next

• Provide WAR file location and click next

• Provide WAR file location and click next

• Access Axis application at http://oc4j_host:oc4j_port/axis2/axis2-web/index.jsp

• Click on the Validate button, the happy axis page will appear: http://oc4j_host:oc4j_port/axis2/axis2-web/HappyAxis.js
• Click on the Administration link will take you to http://oc4j_host:oc4j_port/axis2/axis2-admin the default username/password are: admin/axis2 

• Deploy odi-public-ws.aar located under <ODI_DOWNLOAD_DIR>\oracledi\tools\web_services using the "Upload Service" link or drop into webapps/axis2/web-inf/services directory

• Deployment confirmation page showing success (or in cases will show errors)

• Copy odiInvoke.wsil from  <ODI_DOWNLOAD_DIR>\oracledi\tools\web_services to <OC4J_ODI>\applications\axis2\axis2\axis2-web\OdiInvoke.wsil

Change Location attribute from
location="./services/OdiInvoke?wsdl"
to
location="/axis2/services/OdiInvoke?wsdl"

Configuring JDeveloper

• To show local WSIL registry uncomment External Source for WSIL lcoated under <JDEV_HOME>\integration\bpm\designer\config\serviceexplorer_plugin.xml

• Create inspection.wsil  manually to the same directory where serviceexplorer_plugin.xml is located. <JDEV_HOME>\integration\bpm\designer\config\inspection.wsil

<?xml version="1.0"?>
<inspection xmlns="http://schemas.xmlsoap.org/ws/2001/10/inspection/"
            xmlns:wsilwsdl="http://schemas.xmlsoap.org/ws/2001/10/inspection/wsdl/">
    <link referencedNamespace="http://schemas.xmlsoap.org/ws/2001/10/inspection/"
                location=:/axis2/axis2-web/OdiInvoke.wsil">:/axis2/axis2-web/OdiInvoke.wsil">:/axis2/axis2-web/OdiInvoke.wsil">:/axis2/axis2-web/OdiInvoke.wsil">:/axis2/axis2-web/OdiInvoke.wsil">:/axis2/axis2-web/OdiInvoke.wsil">http://<host>:<port>/axis2/axis2-web/OdiInvoke.wsil>
            <abstract>Oracle Data Integrator Public Web Service</abstract>
    </link>
</inspection>

• Restart JDeveloper and you should be able to see service in "Service Explorer". You can now use it with BPEL, AIA, OSB or any other service aware application.