Thread: 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:
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:
And publish them in a Pentaho B.I. Server.
Best regards,
Alexandre