How to build a web service architecture?

Question

Django

There are two relational databases:

• one is filled manually in 1s,
  
• the other is filled in automatically using GLPI, an application that polls all computer equipment connected to the network.
  

There are a lot of tables in these databases : table, chair, monitor, machine, board, and so on. In general, all material objects fall into one of the bases. There is a need to use information from these databases for different types of reporting.
It is necessary to create a web service that will perform all basic operations with two databases ( example: we pass the audience number as a parameter, we get a list of computer equipment from one database and a list of non-computer equipment from another database ).
Since operations with tables are typical and the tables themselves are similar and have many identical fields (inventory number, location, responsible person, etc.), it is necessary to create some kind of frame system, which unifies all material objects and reduces the amount of repetitive code.
Question: what are the architectures/solutions for such tasks? Is it possible to implement this using django rest framework? If not, what can be done?

Answer 1

It's probably worth digging towards ETL systems or indexing systems like ElasticSearch, but judging by the description of the database, it's more efficient to normalize the databases first - then the service will be easier to do.