Answer the question
In order to leave comments, you need to log in
System for generating queries to various databases
Good afternoon.
You need a software tool (preferably open source) that can make selections from various databases (mysql, db2, cache, etc...).
Mandatory with separation of rights: The administrator enters queries to the databases, and also specifies the necessary query parameters. The user sees only a list of allowed queries, and when the query is executed, they are shown a list of parameters for input (eg date from .., date to ..). The output is a query result with the ability to export to tabular formats.
Answer the question
In order to leave comments, you need to log in
I can’t advise ready-made solutions, but for your task you can write a simple web application (for example, in Ruby On Rails).
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question