Welcome to Part 2 of the Pentaho Video Tutorial Series. In Part 1, we covered the installation of the Pentaho BI Suite on an Ubuntu Linux O/S using the Pentaho BI Suite Installer. Many have already experienced how easy it was to download and install, thanks for your comments. (You can obtain the installer from the Pentaho KB or from http://www.pentaho.com/download/.)
In this part we will cover configuring Pentaho server side data connections that can access your traditional RDBMS data sources. In this example I demonstrate adding connections to Oracle and Microsoft SQL Server 2008. It is important to note that the Pentaho design tools, such as Report Designer, Schema Workbench, Data Integration and the Metadata Editor can publish content using these server side data source connections that have been configured. (We will cover this in Part 3 of the series) To prepare for this configuration, please have the appropriate vendor specific JDBC Type 4 driver available for the data source you want to connect to. You can obtain them from the database vendor’s web site, your DBA, or perhaps the installation location of the RDBMS.
You can view the video inline in this blog, or download the higher quality .wmv (Windows Media Video) to your workstation for local viewing.
To see all related Tutorials in this series posted by me, click on my pic on the bottom right under Authors.