Using CDM tables for Achilles (ATLAS)

@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)