Re:Top Reasons I like Postgres Over SQL Server
by endersshadow on Tuesday April 09, 2013 @09:44AM
(#5517973)
For my money, there's no better multidimensional database I've used for operational analytics than SSAS. JasperSoft, Pentaho, Essbase, Cognos, etc all just don't cut it. Essbase if you're doing GL (SSAS doesn't aggregate Parent-Child very well), but SSAS is an incredibly powerful tool. You can use Postgres with it, so you don't need SQL Server RDBMS to go with it, and you can just pay the license for your SSAS server (which needs more memory than CPU, anyway).
[ Parent
| on HN ]
Re:Top Reasons I like Postgres Over SQL Server
by ucee054 on Tuesday April 09, 2013 @12:19PM
(#5519141)
But if you've already got SQL Server for the SSAS, would you go through the bother of installing Postgres?
I think that's Microsoft's advantage in the database market: their system has all the tools out-of-the-box.
And the licensing's really not that expensive - especially compared to the heart-attack inducing prices coming out of Oracle, IBM, SAS, Teradata, Kx etc etc etc