ERPNext incrementatly daily export

Integration
1

Hi All,

I want to move ERPNext data to AWS Redshift for reporting purposes. Is there a way to download data from the various modules on a daily schedule so that I can be pickup and moved to Redshift?

2

Hi I believe this can be done in Scheduler Hooks you can check on
https://frappe.github.io/frappe/user/en/guides/basics/hooks
or if this task is a bit heavy then you can do crontab instead

3

Thank you John.

Do you know if there is a project does that does available that we can use? Can we remotely call the export functions for all the modules?