We would like to refresh our Shiny report with fresh data from our database, API... automatically X times a day.
Is it possible? Is it schedulable? are we obliged to read database data directly from the cloud by opening some ports on our firewall or can we transfer a file to the cloud directly ?
To make it simple, we are looking for the most secured architecture as private data will be in the cloud.
I'm sure someone else will have a better answer. But I've run an app with a connection to a database, with the cronjob updating that database. It seemed to work fine.