This article talk about the installation and configuration of OWB in a Single Computer Topology architecture.
It's the standard installation that you will find on a laptop.
This architecture is composed of three parts :
- The “Design Client” permit to design the data integration process (mappings) (source, target, data transformation,…)
- The OWB Control Center Service is the part of the software which deploy the mappings (program) and execute them.
- The OWB Browser which permit to browse the metadata (table,column, mapping, …)
- OS Windows
Oracle Warehouse Builder is part of every database installation on hosts running Oracle Database 11g Release 2. It's why you can read in the download page of OWB :
Oracle Warehouse Builder 11g Release 2 (18.104.22.168.0) Standalone Software This software is automatically installed when you install Oracle Database 11g Release 2. IMPORTANT: It is not necessary to download this standalone software unless you have any of the following needs: * You are installing OWB 11.2 and hosting an OWB Repository on one of: Oracle Database 10g Release 1, Oracle Database 10g Release 2, or Oracle Database 11g Release 1. * You are running the OWB 11.2 Design Client on a developer's computer. * You are installing OWB 11.2 on a computer that runs the Control Center Agent.
As we are not in one of this case, we don't need to download it. The software installation is embedded in the database installation.
To confirm that you have Oracle Warehouse Builder installed, check that OWBSYS schema exists, log in to the Database as DBA and issue the following statements:
SELECT COUNT(*) FROM DBA_USERS WHERE USERNAME='OWBSYS';
If this query returns a value larger than zero (0), OWBSYS schema exists.
If the OWBSYS schema does not exist, take the following steps:
- Go to the ORACLE_HOME/owb/UnifiedRepos directory.
- Login to the Database as SYSDBA.
- Execute the following SQL statement.
- When prompted to enter a tablespace name, input USERS
Once Oracle Database 11g Release 2 is installed, you only have to unlock two accounts:
- and OWBSYS_AUDIT.
At the command prompt, start SQL*Plus:
C:\>sqlplus SQL*Plus: Release 11.2 - Production on Mon Jul 27 11:34:06 2009 Copyright (c) 1982, 2009, Oracle. All rights reserved. Enter user-name: sys as sysdba Enter password: password Connected to: Oracle Database 11g Enterprise Edition Release 11.2 - Production With the Partitioning, OLAP and Data Mining options SQL> alter user owbsys identified by password account unlock; User altered. SQL> alter user owbsys_audit identified by password account unlock; User altered.
Creating a standard Workspace in the Repository
Install the Workflow Server
Create a Workflow Proxy User.
When the Workflow instance is not on the same computer that hosts the Warehouse Builder repository, you need to create a proxy user.
Within the database hosting the repository, use SQL Plus to create a user and grant it the OWB_USER role as a default. This enables the remote Oracle Workflow instance to connect to the services provided by the Control Center.
Right on the File System Directory
To ensure that all objects are valid, log in to the database with a DBA id and password and recompile all objects in the OWB owner schema:
exec utl_recomp.recomp_serial('OWBSYS'); exec utl_recomp.recomp_serial('OWBSYS_AUDIT');