Tuesday, September 27, 2011

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
image
  • Check "Oracle Data Integrator, Oracle Data Profiling, Oracle Data Quality 10.1.3.5.0" and click next
image
  • Check "Complete" and Click next
image
  • Specify ODI Home name and location. Click Next
image
  • Specify port, click Next
image
  • Specify host name and ports, I left them at default ones.
image
  • Again left at default one
image
  • Check summary and click Install
image

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
image 
  • When prompted, click OK
image
  • To connect to the Master repository launch the Topology Manager script (bin/topology.bat or bin/topology.sh)
  • Click on the button New
image
  • Click on Test to check the connection is working. Validate by OK, then OK. Topology Manager opens.
image

image
  • The default password of the SUPERVISOR is SUNOPSIS.
image
  • In the icon list Topology -> Repositories -> Work repositories, click with the right button,
    then choose Insert work repository.
image
  • In the connection window, complete the parameters and click OK
image
  • Click JDBC tab
image
image
image
image
  • New Work Repository can be seen in topology manager now
image
  • To connect to a work repository and launch the Designer module
image
  • Click on the button New
image
  • Complete the fields, test connection and click ok
image
  • Now connect to work rep using SUPERVISOR/SUNOPSIS
image
  • New Designer window will open up for current repository
image

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)
 
image
  • Click Next
image
  • Accept default values, click Next
image
  • Click Deploy
image
  • Check deployment report for any errors and click Return.
image
  • Test Application at http://oc4j_host:oc4j_port/oracledilwd/
image

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
 image
  • Browse to location <ODI_DOWNLOAD_DIR>\setup\Manual and select oracledimn.war file (Metadata Navigator). Click Next
image
  • Accept defaults, click Next
image
  • Click Deploy
image
  • Check deployment report for any errors and click Return.
image
  • Test Application at http://oc4j_host:oc4j_port/oracledimn/
image

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)

image
  • Provide WAR file location and click next
image
  • Provide WAR file location and click next
image
  • Provide WAR file location and click next
image
  • Provide WAR file location and click next
image
  • Provide WAR file location and click next
image
image
image
  • 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
image
  • Deployment confirmation page showing success (or in cases will show errors)
image
  • 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"
image

Configuring JDeveloper

  • To show local WSIL registry uncomment External Source for WSIL lcoated under <JDEV_HOME>\integration\bpm\designer\config\serviceexplorer_plugin.xml
image
  • 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>
image
  • 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.

image

No comments: