Thread: BI Reports and Postgres

BI Reports and Postgres

From
KK CHN
Date:
List, 
1. For generating BI reports, which  Databases are more suitable ( RDBMS like Postgres  OR NoSQL like MongoDB ) ? Which is best? Why ?    

2. Is NoSQL DBs like MongoDB et all useful in which scenarios  and application context ? or NoSQLs are losing the initial hype ?

3. Could someone point out which BI report tool (  OpenSource tool / Free Software tool )  available for  generating BI reports from Postgres ?   What does the community use ? 

4. For Generating BI reports does it make sense to keep your data in RDBMS or do we need to port data to MongoDB or similar NoSQLs ?

Any hints are much appreciated.
Krishane


Re: BI Reports and Postgres

From
Gurjeet Singh
Date:
On Tue, Jul 11, 2023 at 1:45 AM KK CHN <kkchn.in@gmail.com> wrote:
>
> List,
> 1. For generating BI reports, which  Databases are more suitable ( RDBMS like Postgres  OR NoSQL like MongoDB ) ?
Whichis best? Why ? 
>
> 2. Is NoSQL DBs like MongoDB et all useful in which scenarios  and application context ? or NoSQLs are losing the
initialhype ? 
>
> 3. Could someone point out which BI report tool (  OpenSource tool / Free Software tool )  available for  generating
BIreports from Postgres ?   What does the community use ? 
>
> 4. For Generating BI reports does it make sense to keep your data in RDBMS or do we need to port data to MongoDB or
similarNoSQLs ? 
>
> Any hints are much appreciated.

Each one of your questions has multiple answers, and which answer you
choose will depend on many factors, like cost, tools you currently
use, talent you have access to, etc.

I believe what you need is a consultant or company that provides
professional services, who can evaluate your needs, and then suggest
solutions and tools that will work for you.

Postgres website has a section [1] that lists companies that provide
professional services and support for Postgres and its ecosystem.

[1]: https://www.postgresql.org/support/professional_support/

Best regards,
Gurjeet
http://Gurje.et