PHI-Integration - Articles

Change Data Capture (CDC)

Salah satu kendala di dalam implementasi data warehouse adalah mengambil data-data transaksi yang mengalami perubahan dari pengambilan terakhir saat proses data warehousing. Hal ini dikenal dengan nama proses pengambilan data yang berubah atau Change Data Capture (CDC).

JPivot + MS Analysis 2000

JPivot is one of rich features OLAP clients in the market that comes up with web based interface. Its capability to run in multiple platform and compliant with XMLA standard as its data source make JPivot a viable and affordable solution for every organizations that already implemented XMLA OLAP server but needed more robust client solution.

MS SQL Server 2000 and MS 2000 Analysis Server is one of the mostly wide used database and OLAP server in enterprise market. And since Microsoft is also the initiator in this XMLA technology, it is not surprising that MS Analysis Server also support the standard.

But the drawback is both products don't come out with any OLAP client. Hence, since JPivot is XMLA compliant we can use it nicely to fill the gap.

This article will show you how to setup JPivot to consume MS Analysis Server 2000.

Simple Cube with Sakila database

Sakila is a movie rental sample database provided by MySQL. This database is very suitable to demonstrate the use of Pentaho's tools in various way.

This article show the use of Sakila as a Mondrian cube.

Running Halogen SVN source from Eclipse

Halogen is an olap client viewer based primarily on OLAP4J and Google Web Tookit (GWT). Halogen is designed to fill a void in the availability of web based olap tools and as such was written in GWT. Although Halogen is not officially a Pentaho product, but several key Pentaho developers are the initiators of the project.

This article will show you how to setup Halogen SVN repository in Eclipse, build and run the project.

Mondrian + MySQL Setup

Mondrian (Pentaho Analysis) is an open source OLAP server which is very popular and can be combined perfectly with JPivot and other XMLA OLAP client.

In this article, I will try to guide step by step on how to get Mondrian installed and configured using MySQL community as its backend database server.

[ Back ]