.

.

.

.

Using the Object Browser

Go To Database Home Page shortcut takes you to the Oracle 10G XE database. Using this HTML page, you will be able to administer, as well as use, its various tools discussed in the link provided at the beginning of this section. You can find links to a number of tutorials all dealing with this database at the author's blog (http://hodentek.blogspot.com/2006/11/links-to-my-oracle-10g-xearticles.html). When the browser opens up, as shown in the next screenshot, you need to provide the username and password, which are hr and hr.

When you click on the button Login, you will open the Home page as shown in the next screenshot. You may click on the Object Browser component in the Home page.

The Object Browser is the user interface to do everything with the database objects. Here, you can review tables, views, stored procedures, etc. In the drop-down menu with the Tables chosen, you will be able to see the details of the Table, EMPLOYEES, as shown in the next screenshot.

Step 1: Creating a BI Project and Adding a Data Flow Task

This process has been described a number of times in the previous chapters.

1. Create a BI project Ch13. Change the name of the default package name to OraTo2k5.dtsx. Drag and drop a Data Flow Task from the Control Flow Items group in the Toolbox to the Control Flow page on the Canvas. An instance of the Data Flow Task will be added to the Canvas to the Control Flow page.

Step 2: Adding an OLE DB Source and Configuring it to Connect to a Local Oracle 10G XE Server

1. Drag and drop a OLE DB Source from the Data Flow Sources group in the Toolbox to the Data Flow page of the Canvas.

2. Right-click an empty area in the Connection Managers' page in the Canvas, and from the pop-up menu choose New OLE DB Connection… (The detailing of what to do next is abbreviated as this has been dealt in an earlier chapter). This opens the Configure OLE DB Connection Manager's window. The left-hand area shows all existing data connections under Data Connections: label and the right-hand area shows the details of the data connection you choose on the left under the label Data connection properties. On the right side, below you will find the New… button to create a new OLE DB Connection.

3. Click on the New… button. This opens the Connection Manager's window that opens as a default connection to the SQL Server 2005 using the SQL Native Client provider, and as such this window has controls suitable to connect to an SQL Server. However, to connect to an Oracle database we need to use a Provider for Oracle, which is chosen using the drop-down menu item corresponding to the Provider label on this page.

4. Click on the drop-down menu and choose the Microsoft OLE DB Provider for Oracle, as shown in the next screenshot.

The next figure shows the Connection Manager's page as well as the result of clicking the Test Connection button in the mini-step 5 to follow.

5. Enter Xe for the Server name, hr for username, and hr for password. Also place a check mark for the Save my password check box.. Click on the Test Connection button.

As the information supplied is correct, the connection to the Oracle 10G XE was successful.

6. Click on the OK button on the Test Connection button generated message as well as the Connection Manager window.

This will bring you back to the Configure OLE DB Connection Manager's window. A new OLE DB Connection xe.hr gets added to the Data Connections area in the left.

7. Click on the OK button on this window.

This completes the connection manager setup for the Oracle 10G XE. A connection manager xe.hr appears in the Connection Managers' page on the Canvas.