Part 2: Configuring Server Side Data Connections – even easier!

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.

Mike Tarallo
Pre-Sales Director
Pentaho Corporation

Para ver esta entrada en español chasque aquí here
Pour regarder cette entrée en français cliquez sur ici
Um diese Eintragung auf deutsch anzusehen klicken Sie hier

One Response to Part 2: Configuring Server Side Data Connections – even easier!

  1. […] Designer and its Data Access component. Part 3 picks up after we have configured our server side Pentaho Data Connections to connect to Oracle and MS SQL Server. In this tutorial I will also cover the Pentaho BI Server […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 103 other followers

%d bloggers like this: