I've developed a shiny app which I'd like to deploy for internal use within my organisation via RStudio Connect. The application takes user inputs and then sends this to a database, the application then also calls another software to use this data. This all works fine on my local machine, where I have read and write access to the database and I have the other software installed on my machine.
How would I go about creating the same environment using RStudio connect? To be clear, what I am hoping to achieve is users within my organisation being able to use my application (via link provided by RStudio connect) to enter data to a database, then call the other software.
Is this possible?