Re:PostgreSQL Accessing MySQL as a Data Source Using mysqsl_fdw
by gav on Friday August 24, 2018 @12:53PM
(#17836107)
Duplicating data isn't a bad thing.
Having a process that copies data into a reporting system solves the problem that otherwise it would be brittle (changes to either system might break things) and performance (any reporting queries affect realtime ones). Also, as it's decoupled, pulling in data from a 3rd system, e.g. CRM is possible.
Having a process that copies data into a reporting system solves the problem that otherwise it would be brittle (changes to either system might break things) and performance (any reporting queries affect realtime ones). Also, as it's decoupled, pulling in data from a 3rd system, e.g. CRM is possible.