In Oracle : Create an Oracle Warehouse Builder (OWB) workspace

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

Oracle Data Warehouse & BI

In-Oracle.com  -> Oracle Data Warehouse & BI  -> Oracle Data Warehouse

-> Create an Oracle Warehouse Builder (OWB) workspace

 

 Create an Oracle Warehouse Builder (OWB) workspace

 

 

First run the Repository assistant:

Start button -> All Programs -> Oracle 11g Installation (Name) -> Warehouse Builder -> Administration -> Repository Assistant

 

Create an Oracle Warehouse Builder (OWB) workspace

 

Click on "Next".

 

 

Create an Oracle Warehouse Builder (OWB) workspace

 

Choose the database information where the workspace will be created.  Click on "Next".

 

Create an Oracle Warehouse Builder (OWB) workspace

 

Choose the "Manage Warehouse Builder workspaces" option and click on "Next".

 

Create an Oracle Warehouse Builder (OWB) workspace

 

Choose the "Create a new Warehouse Builder workspace" option and click on "Next".

Create an Oracle Warehouse Builder (OWB) workspace

Choose the "Create a workspace with a new user as workspace owner" option and click on "Next".

 

Create an Oracle Warehouse Builder (OWB) workspace

I will use the default "system" user name. However, in the real life we can use another DBA user. Click on "Next".

 

Create an Oracle Warehouse Builder (OWB) workspace

The user (paul_DW in my case) must not exist. The workspace named paul_DW_WS will be created. Click on "Next".

 

Create an Oracle Warehouse Builder (OWB) workspace

 

I will not register a workspace user and I will click on "Next".

 

Create an Oracle Warehouse Builder (OWB) workspace

 

When the Summary page apears, click on "Finish". The following screen will apear at the end of the workspace creation:

 

Create an Oracle Warehouse Builder (OWB) workspace

 

Click on "OK".

 

At this time we are able to develop a data warehouse project, by connecting to this workspace:

Start button -> All Programs -> Oracle 11g Installation Name -> Warehouse Builder -> Design Center

 

Create an Oracle Warehouse Builder (OWB) workspace

 

The first time you are logging in, the "Recent Logon" line is not present and you must have more than 1 workspace to see that line.

 

You will see that a project is created automatically (MY_PROJECT). This name can be changed without problems. Here you are able to start designing a new data warehouse using OWB 11g !  Enjoy !

 

In-Oracle.com  -> Oracle Data Warehouse & BI  -> Oracle Data Warehouse

-> Create an Oracle Warehouse Builder (OWB) workspace

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

 

     Copyright (c) 2011-2015  www.in-oracle.com  |  Disclaimer: The views expressed on this web site are my own and do not reflect the views of Oracle Corporation. You may use the information from this site only at your risk.