How to organize database replication?

Question

Database

There is measuring equipment, which is located remotely in different branches.
They maintain archival measurement data,
databases on various platforms, all databases are stored locally on the equipment, database platforms are different.
I want to make software replication from all equipment into a single database.
1. Which way to choose?
I think to do so,
Write a service in java, which connects to the equipment database through drivers, makes a selection per day (synchronization once a day) and enters this data into our database.
2. How to store data in the database?
To create for each branch the DB?
or store similar equipment data in one table, adding the site id?
Or does each equipment of the branch site have its own plate?
From a single database, various analyzes will be carried out, reports will be generated, i.e. 90% are selects.
PostgreSQL database server.

Answer 1

IMHO, can it be worth wrapping data from "local" databases, for example, in kafka or hadoop, and then aggregate this data and write it to the central database?