@Chris_Knoll I see, thanks for the clear explanation!
my overall schema structure is as below
CDM database
– cdm schema which contains the cdm and vocab tables
– results schema, which doesn’t have any tables
OHDSI database
– webapi schema
At the moment am having problems loading Achilles in R (Error in installing R-Packages - #6 by hui_xing_tan), but I’ve written down the connection details to run on RStudio once I’ve figured out the other issue (fingers crossed).
Would greatly appreciate any advice on whether I’ve filled in correctly…Thank you!
connectionDetails ← createConnectionDetails(
dbms=“postgresql”,
server=“localhost/CDM”,
user=“postgres”,
password=‘****’,
schema=‘cdm’,
port=“5433”)
achilles(connectionDetails,
cdmDatabaseSchema = “cdm”,
resultsDatabaseSchema=“results”,
vocabDatabaseSchema = “cdm”,
numThreads = 1,
sourceName = “Can_this_be_anything?”,
cdmVersion = “5”,
runHeel = TRUE,
runCostAnalysis = TRUE)