What are the open source tools and techniques to build a complete data warehouse platform?

open-source data-warehouse
understack picture understack · Jul 22, 2010 · Viewed 47k times · Source

I'm looking for these open source tools possibly free or with free trial version to set up complete data warehouse stack.

I know about few like Pentaho open source Mondrian server, but couldn't get any google result to setup complete platform. I'm not sure whether these components are compatible with each other? Could someone please list them along with their position in the chain?

Answer

Pascal Thivent picture Pascal Thivent · Jul 28, 2010

The Open Source Data Warehousing does a great job at identifying OSS components that could be used to build a Data Warehouse stack: Infrastructure (servers, OS, databases), Integration Management (ETL, EAI, etc), Information Management (DW/Mart/ODS, OLap Servers, etc), Information Delivery (Portal, Dashboard, Analytics/OLAP Client, etc). Here is a summary:

Open Source BI/DW Projects

BI and Analytics

Databases

Integration

I recommend browsing the presentation. Good stuff.

Related questions

open source business intelligence solutions

which open source business intelligence solution would you recommend? All I need is to build some cubes and let the end user play with dimensions, filter data, sort, etc, and once it's done being able to export it to excel... …

Read More
What is the best open XML parser for C++?

I am looking for a simple, clean, correct XML parser to use in my C++ project. Should I write my own?

Read More
Open source PDF library for C/C++ application?

I want to be able to generate PDF output from my (native) C++ Windows application. Are there any free/open source libraries available to do this? I looked at the answers to this question, but they mostly relate to .Net.

Read More