Hello,
My question is very basic.
We are developping on Windows with R Studio and accessing our local databases.
How should we proceed to push data/scripts to shinyapps.io and almost to schedule such a task?
Typically, we have a global report (data from a MS SQL database) and we would like data to be updated automatically every day at 5AM for instance.
May we use GitLab (or another solution) to perform such a thing?
Thanks in advance for your recommendations.
Would you just automate the updating of the tables in the database daily and have the app just read from the database?
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.
We are currently studying the global architecture (including also security access,...).
I will be waiting for some other answers.
Regards
This topic was automatically closed 42 days after the last reply. New replies are no longer allowed.
If you have a query related to it or one of the replies, start a new topic and refer back with a link.