Search Postgresql Archives

Re: BI tools and postgresql

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 source version of the old Business Objects drag-n-drop
> interface would be great.

It's quite easy to build an exporting function with a web server, if you
can use that. 

You can see one in action here :

https://as-pro.biz/clients/login?nom_utilisateur=demo-mfp&mot_de_passe=demo-mfp

Go into 'Statistiques' from the left menu.
Check any checkbox next to 'Tableaux' (Menu 1, Menu 2...)
Click on 'Envoyer'

You can download the data in csv format for each table displayed by
clicking into its header.

This is an Apache web server using mod_perl to connect to a postgresql
database. The module can be written in a day if you know the language
(you can use others), the apache web server has a learning curve at
first.

-- 
Vincent Veyron
http://marica.fr/
Logiciel de gestion des sinistres assurances et des dossiers contentieux pour le service juridique


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux