Today we will learn how to create a Java EE agent in Oracle Data Integrator. In one of my previous tutorials I had explained how to create a stand-alone agent in ODI. The only difference in this case is that we would require to install Weblogic server in order to configure our Java EE agent.
Pre-requisites: Oracle Data Integrator 11gR1 (build version 18.104.22.168.0), Oracle WebLogic Server 10.3.6 (x86 for 32 bit JVM)
Step 1: Download Oracle weblogic server
Go to the Oracle software downloads page and download a previous release 10.3.6 of Oracle Weblogic server.
Note: I assume while installing Oracle Data Integrator, you have selected the option to install Java EE agent as well. If not, I would recommend carrying out a fresh installation before proceeding with this tutorial.
Step 2: Deploy and configure new domain with Weblogic server
Open command prompt and change directory to \common\bin, for example: C:\oracle\Middleware\Oracle_ODI2\common\bin. Execute config command.
Follow the screenshots below and enter the information required for various fields as shown in the screenshots!
Click on the Create button and let the installation take place!
Note: Don’t start Admin Server now
Step 3: Create ODI Java EE agent for deployment on domain ODI-DOMAIN
Step 4: Connect to Weblogic server and managed server odi_server1
Change directory to the directory of the WLS Home –> C:\Oracle\Middleware\user_projects\domains\ODI_DOMAIN\bin. Execute the startweblogic command.
Security must be set up for the JAVA EE application to have access to the ODI repository. The entry will be created within the credential store, which will allow the JAVA EE Agent to authenticate itself to be able to use the required resources. This user should be a user that is already set up in the ODI Security.
Change directory to the WLS_HOME common bin –> C:\Oracle\Middleware\oracle_common\common\bin, and then execute the command wlst.
To connect to the running Admin server, execute the following command: connect(‘weblogic’,’welcome1′,’t3://localhost:7001′)
Note: Here welcome1 is my weblogic password.
Execute the following command to add the correct credential store for ODI Supervisor : createCred (map=”oracle.odi.credmap”, key=”SUPERVISOR”, user=”SUPERVISOR”, password=”SUNOPSIS”, desc=”ODI SUPERVISOR Credential”).
Note: All commands are case-sensitive! You can copy commands from the text file provided here.
Also execute the command to add the correct credential store for the domain ODI-DOMAIN: createCred (map=”oracle.odi.credmap”, key=”ODI-DOMAIN”, user=”weblogic”, password=”welcome1″, desc=”ODI-DOMAIN Credential”). To exit WLST, execute the command exit() .
To start managed server odi_server1, change directory to WLS Home –> C:\Oracle\Middleware\user_projects\domains\ODI-DOMAIN\bin , and use the execute command.
StartManagedWeblogic odi_server1. For Username, enter weblogic. For the password, enter welcome1. Verify that your managed server is started in RUNNING mode.
Finally, when the weblogic server is up and running, test the connection to the ODI agent created previously. A successful connection indicates that you have configured the Java EE agent correctly. That’s it for this tutorial. Have a nice day! 🙂
Source: Deploying and configuring Java EE Agent