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

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.