|
|
此文章由 henda 原创或转贴，不代表本站立场和观点，版权归 oursteps.com.au 和作者 henda 所有！转贴必须注明作者、出处和本声明，并保持内容完整
我没用过pentaho，貌似不错！
刚找了一些资料。
1.) Platform
SQL server doesn't run on Unix or Linux so they are automatically excluded from this market. Windows is about the same price as some versions or Unix now. Windows is pretty cheap and runs faily well now. It gives me about as much trouble as Linux.
2.) OLAP
Analysis services was reinvented in 2005 (current is 2008) over the 2000 version. It is an order of magnatude more powerful over 2000. The pentaho (Mondrian) is not as fast once you get big. It also has few features. It is pretty good but there are less in the way of tools. Both support Excel as the platform which is esscential. The MS version is more robust.
3.) ETL
MS - DTS has been replaced with SSIS. Again, order of magnatude increase in speed, power, and ability. It controls any and all data movement or program control. If it can't do it you can write a script in Powershell. On par with Informatica in the 2008 release. Pentaho - Much better than is used to be. Not as fast as I would like but I can do just about everything I want to do.
4.) dashboard
Pentaho has improved this. It is sort of uncomfortable and unfriendly to develop but there is really not a real equiv for MS.
5.) reports
MS reports is really powerful but not all that hard to use. I like it now but hated it at first, until I got to know it a little better. I had been using crystal reports and the MS report builder is much more powerful. It is easy to do hard things in MS, but a little harder to do easy things. Pentaho is a little clumsy. I didn't like it at all but you might. I found it to be overly complex. I wish it was either more like the Crystal report builder or the MS report builder but it is jasper like. I find is to be hard. That may be a preference.
6.) ad hoc
MS - this was the real winner for me. I tested it with my users an they instantly in love with the MS user report builder. What made the difference was how it was not just easy to use, but also productive. Pentaho - is good but pretty old school. It uses the more typical wizard based model and has powerful tools but I hate it. It is an excellent tool for what it is, but we have moved on from this style and no one wants to go back. Same problem I had with logiXML. The interface worked well for what it was but is not really much of a change from what we used 12 years. http://wiki.pentaho.com/display/ ... teractive+Reporting
其实什么 BI tool 都是大同小异。 在做决策时应该要考虑到几个因素：
（1） 最原始的 data 是在哪一个 platform 上。 比如： ERP 用的是 SQL，现在选择了 Pentaho BI tool，那以后决定换 BI tool的时候，是不是需要重新开始 build dw， 因为旧的 dw 只有 pentaho 能用。
（2） 这 dw / BI 是用来干嘛的，只是给 CEO 在 dashboard 上描一描，还是要推广到全企业都能够收益的层面，电脑上， ipad 上，smartphone 上。
（3） 成本， pentaho 肯定赢了， open source， 老板最喜欢。
[ 本帖最后由 henda 于 2012-7-3 16:13 编辑 ] |
|
参加活动--圣诞新年败家秀：罪恶的2010 (2010-12-18) 魅影妖瞳 
发表于 2012-7-3 13:04
