What's the preferred method for accessing data stored in oracle adw in shiny via shinyapps.io?
Locally, I use the following structure to access the data. I don't think this would be recommended given that I'd have to upload components (e.g., the wallet) to shinyapps.io. Any guidance would be appreciated!
library(ROracle)
library(DBI)
R.home(component = "home")
# make sure all environment variables are present
Sys.getenv("PATH")
Sys.getenv("OCI_INC")
Sys.getenv("OCI_LIB64")
Sys.getenv("ORACLE_HOME")
Sys.getenv("TNS_ADMIN")
Sys.getenv("RTOOLS40_HOME")
Sys.getenv("WALLET_LOCATION")
# set parms
drv<- dbDriver("Oracle")
connect.string <- ''
con_adw <- dbConnect(drv, username ="", password="",
dbname = connect.string)
# test
test <- DBI::dbGetQuery (con_adw, statement = 'select * from DW_DAY_D')