Oracle Warehouse Builder 11gR2

The Oracle Warehouse Builder (OWB) is what this topic is all about, so let’s start discussing it by looking at it from a high level. We’ll talk about some installation topics and the various components that compose this application. Oracle provides some detailed installation documentation and user guides that give you step-by-step instructions on how […]

Introduction to data warehousing (Oracle Warehouse Builder 11gR2)

Although you may not be familiar with data warehousing, you have probably at least heard the term. Data warehouses are becoming increasingly common as businesses have realized the need to be able to mine the information they have stored in the electronic form in order to provide a valuable insight into the operation of their […]

Installation of the database and OWB Part 1 (Oracle Warehouse Builder 11gR2)

We’ll be using the latest version of the database as of this writing—Oracle Database 11g Release 2 — and the corresponding version of OWB that (as of this release) is included with the database install. If you have that version of the database installed already, you can skip this section and move right on to […]

Installation of the database and OWB Part 2 (Oracle Warehouse Builder 11gR2)

Installing the OWB standalone software If we are going to run the OWB client on the same computer as we just installed the Oracle database on, we don’t need any more installations. That is the configuration used in this topic. The OWB client software is now installed by default with the main database installation. We […]

Installation of the database and OWB Part 3 (Oracle Warehouse Builder 11gR2)

Configuring the repository and workspaces We have talked about the OWBSYS schema that is created for us automatically during the Oracle 11g installation, and we have also looked at unlocking it and assigning a password to it. However, if we were to connect to the database right now as that user, we would find that […]

Defining and Importing Source Data Structures (Oracle Warehouse Builder 11gR2)

The Warehouse Builder software and Oracle database have been installed, and we’re ready to begin building our data warehouse. The first thing we have to do is define what our sources of data will be. If we are going to build a useful data warehouse, we have to know what kinds of information our users […]

Preliminary analysis (Oracle Warehouse Builder 11gR2)

In any data warehouse project, we are going to need to do some up-front analysis to determine what data will need to be captured into our warehouse. The analysis will tell us where the data is located, and in what format, so that we can begin to define our source data structures in the Warehouse […]

An overview of Warehouse Builder Design Center

The Design Center is the main graphical interface that we will be using to design our data warehouse, but we also use it to define our data sources. So let’s take some time at this point to go over the user interface and familiarize ourselves with it. Release 11gR2 of the Warehouse Builder has a […]

Importing/defining source database object metadata Part 1 (Oracle Warehouse Builder 11gR2)

Now that we’ve been introduced to the Design Center, it’s time to make use of it to import or define the metadata about our source database objects. Metadata is data that describes our data. We are going to tell the Warehouse Builder what our source database objects look like and where they are located, so […]

Importing/defining source database object metadata Part 2 (Oracle Warehouse Builder 11gR2)

Creating a SQL Server database connection The first step that is required in making use of Oracle Heterogeneous Services to access a non-Oracle database using the generic connectivity agent is to create an ODBC connection. We do that by setting up a system DSN (Data Source Name). A DSN is the name you give to […]