How to get reports from the database?

Question

Analytics

Good day everyone! There are several databases. It is necessary to give users the ability to view data from these databases using pre-written SQL query templates. You also need access control. That is, software or a form in which you need to enter a login and password and gain access to your set of queries. How can I do that? Is there any ready-made software for this?

Answer 1

In general, these are reporting services, only the "separation" point is slightly different - reports / report templates and access is regulated at this level, and the reporting systems themselves have access to the database or views / procedures at a glance
: Microsoft Reporting Services, crystal reports, stimulsoft reports, elastic kibana and everything that is now positioned as bi

Answer 2

No special software is needed.
1. You do on the basis of ready requests Views (view) there only allow selects. here
2. You make in the database all the necessary users with the necessary access rights to each view.
3. Users connect through a convenient DBMS client and see only what they were allowed to see

Answer 3

Dokin in the list of software - Superset.
The tasks specified in the question are covered