Re: [GENERAL] BI tools and postgresql

2012-07-29 Thread Vincent Veyron
Le dimanche 29 juillet 2012 à 12:47 +0200, Alban Hertroys a écrit : > On 29 Jul 2012, at 11:56, Vincent Veyron wrote: > If upper management is any good, they'll be happy to have a chat about the > situation and keep an eye out and a direct line to your people open, so that > they can hear both s

Re: [GENERAL] BI tools and postgresql

2012-07-29 Thread Jacqui Caren
On 29/07/2012 10:56, Vincent Veyron wrote: New manager comes in and starts talking about a bidding procedure for an application for the combined team. Hmm - I wonder... All sorts of perks/backhanders for some types of management when this is undertaken. I suspect this is an attempt to either ge

Re: [GENERAL] BI tools and postgresql

2012-07-29 Thread Alban Hertroys
On 29 Jul 2012, at 11:56, Vincent Veyron wrote: > New manager comes in and starts talking about a bidding procedure for an > application for the combined team. > > The guy is stopped by my 3 person team, who threatens to _strike_ if > 'their' application is removed : they simply refused to work w

Re: [GENERAL] BI tools and postgresql

2012-07-29 Thread Vincent Veyron
Le samedi 28 juillet 2012 à 09:39 -0700, Mark Phillips a écrit : > Thanks to all who have posted. Your comments are very helpful. > > On Jul 26, 2012, at 11:04 AM, Vincent Veyron wrote: > > > I had assumed the OP _was_ > > using Postgres already, and that this was being challenged by the > > new

Re: [GENERAL] BI tools and postgresql

2012-07-28 Thread Mark Phillips
Thanks to all who have posted. Your comments are very helpful. On Jul 26, 2012, at 11:04 AM, Vincent Veyron wrote: > I had assumed the OP _was_ > using Postgres already, and that this was being challenged by the new > manager. Yes, that is accurate. The new manager is not familiar with OSS and P

Re: [GENERAL] BI tools and postgresql

2012-07-27 Thread Daoud Abdelmonem Faleh
SpagoBI provides extensive and integrated tools for BI/Reporting/Data mining/Realtime BI/ Mobile BI/BAM all under Mozilla Public Licence. The downside is that it's too big for simple reporting/dashboard needs and a quite long learning curve. http://www.spagoworld.org/xwiki/bin/view/SpagoBI/ HTH, -

Re: [GENERAL] BI tools and postgresql

2012-07-27 Thread Jacqui Caren
On 26/07/2012 15:04, Vincent Veyron wrote: The money spent in licences alone would pay for scores of developpers to produce any kind of reporting you will need many times over (the data and its structure is what counts, reporting is easy if you have that) I disagree that licences will cover rep

Re: [GENERAL] BI tools and postgresql

2012-07-26 Thread Vincent Veyron
Le jeudi 26 juillet 2012 à 10:02 -0500, Merlin Moncure a écrit : > job, heh). For an end to end BI stack microsoft is a decent choice > if (and only if) you're already heavily invested in the microsoft > platform; You're right. Because he posted on the list, I had assumed the OP _was_ using Po

Re: [GENERAL] BI tools and postgresql

2012-07-26 Thread Merlin Moncure
On Thu, Jul 26, 2012 at 9:04 AM, Vincent Veyron wrote: > Le mercredi 25 juillet 2012 à 10:41 -0700, Mark Phillips a écrit : >> I am seeking suggestions for business intelligence and data mining tools >> compatible with postgresql. >> A new manager at a client's shop is leaning toward the MS offer

Re: [GENERAL] BI tools and postgresql

2012-07-26 Thread Vincent Veyron
Le jeudi 26 juillet 2012 à 08:17 -0400, Chris Curvey a écrit : > 1) a tool for power users to be able to get their own data. There are > a few folks here who are smart enough to be trusted with direct access > to the database, but I don't want to ask them to learn SQL. Something > like an open s

Re: [GENERAL] BI tools and postgresql

2012-07-26 Thread Vincent Veyron
Le mercredi 25 juillet 2012 à 10:41 -0700, Mark Phillips a écrit : > I am seeking suggestions for business intelligence and data mining tools > compatible with postgresql. > A new manager at a client's shop is leaning toward the MS offerings. I would > like to be able to speak to the issue. mmm

Re: [GENERAL] BI tools and postgresql

2012-07-26 Thread Gabriele Bartolini
Hi there, I've looked at Pentaho and Jasper, but I have not had much success. (Can't remember exactly the issue right now, but I recall that they seemed to be huge products and I could never quite figure out how to do something simple with them.) My advice here is to analyse the requirements a

Re: [GENERAL] BI tools and postgresql

2012-07-26 Thread Peter Bex
On Thu, Jul 26, 2012 at 08:17:19AM -0400, Chris Curvey wrote: > 1) a tool for power users to be able to get their own data. There are > a few folks here who are smart enough to be trusted with direct access > to the database, but I don't want to ask them to learn SQL. Something > like an open sou

Re: [GENERAL] BI tools and postgresql

2012-07-26 Thread Seref Arikan
I think simple requirements would fit reporting tools space better. Another alternative worth looking into may be Eclipse BIRT On 26 Jul 2012, at 13:18, Chris Curvey wrote: > On Wed, Jul 25, 2012 at 1:41 PM, Mark Phillips > wrote: >> I am seeking suggestions for business intelligence and da

Re: [GENERAL] BI tools and postgresql

2012-07-26 Thread Chris Curvey
On Wed, Jul 25, 2012 at 1:41 PM, Mark Phillips wrote: > I am seeking suggestions for business intelligence and data mining tools > compatible with postgresql. A new manager at a client's shop is leaning > toward the MS offerings. I would like to be able to speak to the issue. > I'm in the same

Re: [GENERAL] BI tools and postgresql

2012-07-25 Thread Seref Arikan
Hi Mark, For me, Pentaho has delivered quite good results in the past, and being an open source offering it would probably work OK with postgresql. Jasper reports also seems to have made it into BI space, and I would assume it'd work with postgresql too or so I recall. Both are open source project

Re: [GENERAL] BI tools and postgresql

2012-07-25 Thread Mark Phillips
Thank you. I will look into those projects. The initiative is at the earliest stage so there is not a lot of detail available at the moment. On Jul 25, 2012, at 11:07 AM, Henry Drexler wrote: > The combination of pandas ipython and psycopg2 work wonders for pulling data > from db and manipula

Re: [GENERAL] BI tools and postgresql

2012-07-25 Thread Henry Drexler
The combination of pandas ipython and psycopg2 work wonders for pulling data from db and manipulating/plotting, although I don't know in more detail of what the client's use cases are. On Wed, Jul 25, 2012 at 1:41 PM, Mark Phillips wrote: > I am seeking suggestions for business intelligence and