simple reporting tools for postgres in aws
Hello,
We have a need to display some very simple reports generated from views in
an rds postgres database. We need little more functionality beyond simple
filtering, column hiding, sorting, grouping. Anything much beyond that
would be a strike against the tool.
i'm looking for something similar to oracle application
express's interactive reports (i come from an oracle background).
i took a look at what's available from amazon's aws marketplace but quickly
got overwhelmed. every application i saw was overkill.
users will not be tech savvy. we have a tentative fallback plan to use
excel with pages linked to views in the database but i'm looking for
something a little more targeted.
does anyone have any suggestions that fit the description above?
thanks for any input,
chris
LibreOffice Base?
I have used LibreOffice Base to spin up a quick data entry front end to
Postgresql. Has some basic reporting functionality as well, and can
integrate to other LIber\Office products.
Poor man's version of MS Access.
As for other tools, https://querytreeapp.com seems to have some of the
species you are looking for, but have never used it.
Postgres lists a variety of data reporting products :
https://www.postgresql.org/download/products/5-reporting-tools/
On Mon, 7 Dec 2020 at 17:53, Chris Stephens <cstephens16@gmail.com> wrote:
Show quoted text
Hello,
We have a need to display some very simple reports generated from views in
an rds postgres database. We need little more functionality beyond simple
filtering, column hiding, sorting, grouping. Anything much beyond that
would be a strike against the tool.i'm looking for something similar to oracle application
express's interactive reports (i come from an oracle background).i took a look at what's available from amazon's aws marketplace but
quickly got overwhelmed. every application i saw was overkill.users will not be tech savvy. we have a tentative fallback plan to use
excel with pages linked to views in the database but i'm looking for
something a little more targeted.does anyone have any suggestions that fit the description above?
thanks for any input,
chris
Hello,
If you know Oracle, maybe you also know Sql developer reporting features,
and as SQL developer can connect to Postgres,
it can be used for free (it is what Oracle claims, but it should be double
verified)
https://www.oracle.com/webfolder/technetwork/tutorials/obe/db/sqldev/r40/Chart/12cChart.html
Regards
PAscal
--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
Em seg., 7 de dez. de 2020 às 12:53, Chris Stephens <cstephens16@gmail.com>
escreveu:
Hello,
We have a need to display some very simple reports generated from views in
an rds postgres database. We need little more functionality beyond simple
filtering, column hiding, sorting, grouping. Anything much beyond that
would be a strike against the tool.i'm looking for something similar to oracle application
express's interactive reports (i come from an oracle background).i took a look at what's available from amazon's aws marketplace but
quickly got overwhelmed. every application i saw was overkill.users will not be tech savvy. we have a tentative fallback plan to use
excel with pages linked to views in the database but i'm looking for
something a little more targeted.does anyone have any suggestions that fit the description above?
thanks for any input,
chris
Hi,
If you need dashboards, with a lot of widgets (chat, tabular, etc), take a
look at this awesome tool called Redash:
Or if you need reports like Crystal Reports, you can use PRD - Pentaho
Reports Designer:
https://community.hitachivantara.com/s/article/pentaho-reporting
And publish them in a Pentaho B.I. Server.
Best regards,
Alexandre