November 15th, 2003, 12:12 PM
PostgreSQL / OLAP / Windows
I'm about to port a SQL Server database to postgreSQL but I have some questions first :
- How is PostgreSQL performing on a Windows platform ?
- Is it possible to do some OLAP on postgreSQL ?
- Or are there any tools that can do OLAP through ODBC ?
- Are there free tools that can automatically import table/views and stored procedures from SQL Server to Windows native postgreSQL ?
Thanks in advance
November 15th, 2003, 12:24 PM
- Not really well, there is limited support for windows
- Not in the sense someone would expect after working with Analysis Services (but you can build a cube in AS with data coming from PostgreSQL)
- I would take a look at Mondrian (on Sourceforge) which uses JDBC, for straight reporting look at my sig.
- Partially, look at my sig for pgAdminIII (or version II), but you can export from SQLServer with DTS.
Hope this helps!!!
Last edited by pabloj; November 15th, 2003 at 12:29 PM.
November 15th, 2003, 12:52 PM
It does help a lot, thanks.
I would like to know if you think it's a good idea to use postgreSQL on a windows platform for production purposes ?
November 15th, 2003, 01:02 PM
It's a "better" idea to do it off of a unix-based computer.
and some more stuff about cygwin:
Could you persuade your IT peeps to give you a machine (doesn't have to be that sweet) to host a unix version of the database?
You can still connect easily from a windows application through ODBC to postgresql, we are using both ODBC and JDBC and both work fine. I agree with the statements above about the overall stability of windows -- besides, then getting replication or something to combat your stability would be doubly confusing... I think you'd have to install other tricky stuff to get eRServer to work on Windows.
November 15th, 2003, 01:26 PM
Well, I could probably get a Linux machine but the thing is our windows machine is much faster and we don't want to port our ASP application to a PHP application because it would be to much work for us.
I know that you can make ASP work on linux but I know too that it's not really complete and reliable, so we are stuck with windows.
And my boss really wants to use OLAP on the database so I think I'll look for another DBMS...
Thanks anyway for your help, I appreciate.
November 15th, 2003, 01:34 PM
I would look at Firebird or SAPDB, they have good Windows support.
If you need OLAP then stick to M$, Analysis Services have the best price/performance ratio on the market.