Data Warehousing With Pentaho

Pentaho is one of many business intelligent software that is free to use. By using pentaho we can make Data Warehouse from OLTP into OLAP. There are several steps that we need to do in order to make data warehouse. In this case, we are not going to use pentaho BI suite Enterprise Edition. But, we will use pentaho community edition even though it is more difficult.Well, i will tell you all of them in the simple way to understand about it.

Required Tools :

Download kettle/ pentaho data integration as out ETL tool here.

Download mondrian/ pentaho data analysis as our OLAP tool here.

Download pentaho Bi server here.

Download Apache Tomcat here.

Download Apache Ant here.

If you already have all of them, the next step is you need to install them one by one. start from apache tomcat.

installing apache tomcat on windows :

extract the file on C:\ –> Ex :C:\apache-tomcat-6.0.35

Copy the address of bin folder

 

 

Tagged: , , , ,

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

%d bloggers like this: