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