ODI11g: Integrating with Enterprise Manager and Using ODI Console

<Do not delete this text because it is a placeholder for the generated list of "main" topics when run in a browser>

Purpose

This tutorial walks you through the steps that are needed to deploy and configure Enterprise manager 11g plugin to an existing WebLogic server domain. You use Enterprise Manager 11g to access your ODI objects.

Time to Complete

Approximately 20 minutes

Overview

Oracle Data Integrator provides an extension integrated into the Fusion Middleware Control Console (Enterprise Manager) and ODI Console.. The Oracle Data Integrator components can be monitored as a domain through these consoles, and administrators can have a global view of these components, along with other Fusion Middleware components from a single administration console.

Scenario

Linda works as a database administrator for Global Enterprise. In Global Enterprise, Linda is responsible for performing database management and integration tasks on various resources within the organization. In particular, Linda is responsible for data loading, transformation, and validation. To begin working on her projects, Linda created the new Master repository and Work repository. Linda also created the project and the procedure to create a relational table and populate it with data. Linda created the Web Logic Server (WLS) domain, ODI-DOMAIN and configured the ODI Java EE Agent with the existing WLS domain. Now Linda needs to deploy and configure the ODI Enterprise Manager Plug-in with WLS.

Software and Hardware Requirements

The following is a list of software requirements:

Prerequisites

Before you start the tasks, make sure that your system environment meets the following requirements:

.

Have installed Oracle Database 11g. If not done before, start the services and components for Oracle Database 11g

.

Have installed Oracle Data Integrator 11gR1

.

Before attempting this OBE, you should have successfully completed the following OBEs:

  • ODI11g: Creating and Connecting to ODI Master and Work Repositories
  • ODI11g: Deploying and Configuring the ODI Agent as Java EE Application
  • ODI11g: Creating an ODI procedure to Create and Populate RDBMS Table.
    Note: Alternatively you may have your own ODI object created and used for testing ODI JEE agent . In this case you don't have complete this OBE.

To access these OBEs, click HERE.

 

Deploy and configure the Enterprise Manager Plugin on the existing WebLogic domain, ODI-DOMAIN.


You should have created the WebLogic server domain ODI-DOMAIN, deployed and configured ODI JEE agent with this domain. Now you need to deply and configure the Enterprise Manager plugin on this existing WebLogic server domain, ODI-DOMAIN.

.

Open the Command Prompt window. Change directory to: <WLS-HOME>\common\bin (for example: C:\oracle\Middleware\Oracle_ODI1\common\bin). Execute config command. The Configuration Wizard starts.


 

.

In the Welcome screen, select: Extend an existing WebLogic domain. Click Next. In the screen that follows, select the domain ODI-DOMAIN, as shown on the screenshot. Click Next.





.

In the screen that follows, select the Oracle Enterprise Manger Plugin For ODI – 11.1.1.0, which will also include the Oracle Enterprise Manager – 11.1.1.0. Also select Oracle Data Integrator-Console-11.1.1.0. Click Next. In the screen that follows, click OK to replace the existing component. Click Next. In the screen that follows, click OK to replace the existing component odi_server1, that was created earlier.




.

In the next screen, accept the default application location. Click Next.



.

The wizard will set up the ODI repository connection within the domain server. During the wizard configuration, the repository connection information must be supplied. Click the check boxes next to ODI Master schema, and next to ODI Work schema. Configure the JDBC component schema as shown in the following table. Click Next. Verify that the test was successful (if not, correct any connectivity settings). Click Next.

Database Connection (Master Repository)

Parameter

Value

Vendor

Oracle

Driver

Oracle’s driver (Thin) for Instance connections

Master Schema Owner

snpm1

Master Schema Password

oracle1

Work Schema Owner snpw1
Work Schema Password oracle1

DBMS/Service

orcl

Host Name

localhost

Port

1521



.

In the next screen, select Managed Servers, Clusters and Machines. Click Next. Verify that Listen port is set to 8001 for managed server odi_server1. Click Next. In the Configure Clusters screen, click Next.





.

In the Configure Machines screen, click Next. The Assign Servers to Machines screen will already have the odi_server1 assigned to localODImachine. Click Next. Review the Configuration Summary, and then click Extend. When the domain is created, click Done.








Connecting to the WebLogic server and managed server odi_server1.

Now that you have created and extended the WebLogic domain with the Enterprise Manager, you need to connect to WebLogic server and managed server odi_serevr1.

.

In the command shell, change directory to the directory of the WLS Home - C:\Oracle\Middleware\user_projects\domains\ODI-DOMAIN\bin . Execute the startweblogic command.


 

.

To start managed server odi_server_1, 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.

Note: You created the credential store for ODI Supervisor and for the domain ODI-DOMAIN in the OBE: Deploying and Configuring the ODI Agent as Java EE Application.
Note: All commands are case-sensitive! You can copy commands from the text file provided HERE.






.

If not started, start ODI Designer and connect to ODI Work repository (WORKREP1). For user SUPERVISOR, eneter password: SUNOPSIS. Open Topology Navigator, open Physical architecture and then open ODI JEE agent OracleDIAgent. Click Test icon to test connectivity of your ODI Java EE agent. Click OK. Close OracleDIAgent tab.





Use Enterprise Manager to Administer ODI

With Enterprise manager, explore your ODI environment and resources.

.

Start the browser and enter URL: http://localhost:7001/em . Log in to Enterprise Manager. For the user, enter weblogic . For the password, enter welcome1 . On the screen that follows, click Continue.



 

.

With Enterprise Manager, a process and resources can be monitored and managed. You can explore the deployed application by clicking on each link. You can see running processes, workload, log file information, and more. Drill down into ODI objects by expanding ODI > odiconsole > MASTER REPOSITORY in the left panel, as shown in the following screen.

Note: Your information may differ from the information provided on these screens.

 


.

Click MASTER REPOSITORY to view more details. Click the OracleDIAgent to see the Java EE agent information.


.

Click the localagent node to see details for the standalone agent.

 


.

Expand the Application Deployment node, and then click oraclediagent . View the WebLogic server application deployment information.



Use ODI Console to Explore ODI Environment

With ODI Console, explore your ODI environment.

.

Start the browser and enter URL: http://localhost:8001/odiconsole to start the Oracle Data Integrator Console. To log in Work reposotory, enter SUPERVISOR for the user ID, and enter SUNOPSIS for the password. Expand the Design Time tab and then expand Projects, Models , and Topology as shown on the screenshot below.

Note: Your projects may differ from the information provided on these screens.



.

Select the Procedure-CRT-TBL project, and then click the View icon.


.

Click the First Folder link. Click the Procedures tab. Scroll-down, and then select procedure PRD-create-populate-table.



.

Scroll-down and view details for this procedure.


.

Expand: Runtime > Sessions > All Sessions. Select session PRD-create-populate table- 1001, and then click View icon . Scroll-down and view execution information for selected session. Similarly, expand Topology > Agents > Physical Agents. View information for your agents. You may wish to continue exploration of your ODI environment.

Note: To view information for each selected node, click icon.




.

To stop managed WebLogic server odi_server1 and then WebLogic server, change directory to WLS Home - C:\Oracle\Middleware\user_projects\domains\ODI-DOMAIN\bin, and then execute the following command: stopManagedWebLogic odi_server1. For Username, enter weblogic . For the password, enter welcome1 .

To stop WebLogic server, execute the command: stopWebLogic.





Summary

In this tutorial, you have learned how to:

Resources

 

Hardware and Software Engineered to Work Together About Oracle |Oracle and Sun | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Your Privacy Rights