OHDSI / Broadsea

Broadsea deploys the core OHDSI technology stack (Atlas & R Hades), using cross-platform Docker container technology.
http://ohdsi.github.io/Broadsea/
Apache License 2.0
75 stars 57 forks source link

Documentation about environment variables #24

Closed sdebruyn closed 3 years ago

sdebruyn commented 3 years ago

The difference between the datasource and the flyway_datasource configuration properties is not clear. My CDM DB is in Azure SQL Database and the WebAPI DB is on a PostgreSQL server.

What does env=webapi-postgresql refer to? The OMOP or the WebAPI DB? What do the datasource. properties refer to? I thought it was WebAPI, but one of the properties is datasource.cdm.schema which seems to refer to the CDM DB, while that config is in the source/daimon tables.

leeevans commented 3 years ago

webapi-postgresql is a java mvn profile. See WebAPI pom.xml here: https://github.com/OHDSI/WebAPI/blob/master/pom.xml

Flyway is used to automatically manage database migrations for the OHDSI (atlas/webapi application database - your WebAPI DB).

https://flywaydb.org/