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">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.
