Achilles

Automated Characterization of Health Information at Large-scale Longitudinal Evidence Systems (ACHILLES) - descriptive statistics about a OMOP CDM v4 database

Getting Started

1. Make sure you have your data in the OMOP CDM v4 format.

2. Make sure that you have Java installed. If you don't have Java already intalled on your computed (on most computers it already is installed), go to java.com to get the latest version.

3. If you're using Windows, make sure you install RTools.

4. in R, use the following commands to install Achilles:

install.packages("devtools")
library(devtools)
install_github("ohdsi/DatabaseConnector")
install_github("ohdsi/SqlRender")
install_github("ohdsi/Achilles")

5. To run the Achilles analysis, use the following commands in R:

library(Achilles)
connectionDetails <- createConnectionDetails(dbms="sql server", server="server.com")
achillesResults <- achilles(connectionDetails, "cdm4_inst", "results")

"cdm4_inst" and "results" are the names of the schemas holding the CDM data and target results respectively. See the DatabaseConnector package for details on settings the connection details for your database, for example by typing

?createConnectionDetails

Currently "sql server", "oracle", "postgresql", and "redshift" are supported as dbms.

6. To use AchillesWeb to explore the Achilles statistics, you must first export the statistics to JSON files:

exportToJson(connectionDetails, "cdm4_inst", "results", "c:/myPath/AchillesExport")

License

Achilles is licensed under Apache License 2.0

Acknowledgements

• This project is supported in part through the National Science Foundation grant IIS 1251151.