Re:PostgreSQL Accessing MySQL as a Data Source Using mysqsl_fdw
by logophobia on Friday August 24, 2018 @01:12PM
(#17836235)
ETL, that way you can also ensure your data gets put in a format that'd make it easy to report on.
Granted, it's not quite as quick as this, and not suited for "one-off" reporting, but it's a lot more flexible. Put things in a nice star schema and you have a good way to do analytics on your data.
Granted, it's not quite as quick as this, and not suited for "one-off" reporting, but it's a lot more flexible. Put things in a nice star schema and you have a good way to do analytics on your data.