Home  >  Oracle Data Warehouse & Business Intelligence > Create a workspace in Oracle Warehouse Builder (OWB)

Note: This article ( named Create a workspace in Oracle Warehouse Builder (OWB) - Oracle 11g ) was taken from www.in-oracle.com.

First run the Repository assistant:

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

Click on "Next".

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

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

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

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

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

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

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

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

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

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.

Note: This article ( named Create a workspace in Oracle Warehouse Builder (OWB) - Oracle 11g ) was taken from www.in-oracle.com.