What is the solution for creating forms for searching information from various sources? (database,xml,json,api...)?

Question

Database

Good evening, a very non-standard question, but I'll ask
. Maybe there is already some ready-made solution
. Let's imagine that there are many different systems on the intranet: ERP, ECM, PLM, etc. which everywhere have a lot of information in the database, search engines (solr), their APIs, etc.
And the task is such that sometimes you need to make some kind of quick search page, which was just some kind of search form in which you enter what you are looking for, and it displays a table of results
. So, is there any solution, something like a constructor - which would allow make such pages, specifying the source of information (database table, view, xml, etc.) and the form constructor itself (what to look for) and how to display the results
A very non-trivial question

Answer 1

For all of the above, JSON-APIs are written (each service has its own).
Then one HTML page with Javascript is written, which sends parallel AJAX requests to all services through a unified API and receives responses, then sorts on the fly and displays the result.

Answer 2

https://www.tableau.com/ and others like it,
yes, the same MSO office,
but a simpler framework

Answer 3

ETL?!