I have a database (MySQL) and I need data from n databases (probably multiples DBMS). For example, if a person is added as an user in other database i need to update my table with the new name.
The data is critical, and for sure, i only would have access to read.
My database is the only that need to be updated with the new data.
These two statements contradict each other. You cannot only have access to read, and also update the table, because that’s a write operation.
I presume they meant that they only have read access to all the other databases, not to their own.
It doesn’t seem much of a complicated task - periodically query each of the other databases to find names that don’t exist in the local database, and when you find one, add it. Which part are you struggling with?
Oh i see.
Well, it depends on how you’re trying to store the data as to what the challenges would be.
If you’re essentially doing a full slave replication (which… would be the easier option probably… but not necessarily something you’re going to have access to), its pretty straightforward.
If you’re trying to combine the data into a single table, constraints and prioritization become issues.