Category Archives: Data Warehouse Using Pentaho

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

 

 

Advertisements

Getting Started Learning Data Warehouse

In my university (trunojoyo) Data Warehouse is one of choice subject for computer sains, if we learn about data warehouse, first of all, you need to know about the basic of Database and everything about it. i really confused when first time learning about data warehouse it self. Basically the meaning of data warehouse is a collection of data from many kinds of sources that is used to be analyzed and getting decision from that analyzes. For example, a company which has several branches in some places. The manager wants to get the result of transactional process quickly and making good decision for the future of the company. So, the data of transactional process is a kind of history data that is collected about 3 until 5 years in the past. By this kind of analyze the manager is able to get information quickly and correctly without typing query into database before.

Basically here is the process of data warehouse :

OLTP (collection of database)  –> Data Staging /ETL (Extraction – transformation – loading) –> OLAP (analize data warehouse).

Alright, i will explain  one by one the whole process. first, OLTP (OnLine Transactional Processing) means collection of several data from a company. this is not a common data but, this is transactional data that is always increase everyday/ every times.

Next process is Data Staging. It means process to bring OLTP into Data Warehouse. This proces contains of Extraction, transformation and Loading. Extraction is process to extract database into used tools. Transformation means process to transform data that is different from several database in order to be same. And Loading means process to pick database into data warehouse. In ETL process we can use many kinds of avaible tools.

Last Process is  Analyze process. In this step we need to use OLAP (Online Analytical Processing) tools to do. In this step we can get the result of data warehouse and what do we want on it.

That’s all a little bit about Data Warehouse. If you would like to learn more, you can see the following links

  1. http://en.wikipedia.org/wiki/Data_warehouse
  2. http://www.pentaho.com/explore/pentaho-data-integration/
  3. http://www.dwinfocenter.org/
  4. http://www.oracle.com/us/solutions/datawarehousing/index.html
  5. http://www-01.ibm.com/software/data/infosphere/warehouse/
  6. and many more….