Data/Script synchronization

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?

Shiny - Persistent data storage in Shiny apps (posit.co)

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.