documentation:software:webapi:webapi_installation_guide
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
documentation:software:webapi:webapi_installation_guide [2017/02/28 14:14] anthonysena |
documentation:software:webapi:webapi_installation_guide [2017/02/28 15:19] anthonysena |
||
|---|---|---|---|
| Line 13: | Line 13: | ||
| === MS SQL Server === | === MS SQL Server === | ||
| ---- | ---- | ||
| - | Coming Soon. | + | |
| + | Please refer to the [[documentation:software:webapi:sqlserver_installation_guide|SQL Server Setup Guide]] article for installation and setup details. | ||
| === PostgreSQL 9.3 === | === PostgreSQL 9.3 === | ||
| Line 49: | Line 50: | ||
| === Microsoft SQL Server === | === Microsoft SQL Server === | ||
| - | Coming Soon. | + | **Create settings.xml File** |
| + | |||
| + | Specify user name, password, and location of the OHDSI database (this was created as ‘ohdsi_app_user’ from the [[documentation:software:webapi:sqlserver_installation_guide|SQL Server Setup Guide]]. Note that the user should have read, write, and create privileges on the OHDSI database. Here is an example XML that is based on the above configuration: | ||
| + | |||
| + | <settings> | ||
| + | <profiles> | ||
| + | <profile> | ||
| + | <id>webapi-mssql</id> | ||
| + | <properties> | ||
| + | <datasource.driverClassName>com.microsoft.sqlserver.jdbc.SQLServerDriver</datasource.driverClassName> | ||
| + | <datasource.url>jdbc:sqlserver://localhost;databaseName=OHDSI</datasource.url> | ||
| + | <datasource.username>ohdsi_app_user</datasource.username> | ||
| + | <datasource.password>app1</datasource.password> | ||
| + | <datasource.dialect>sql server</datasource.dialect> | ||
| + | <datasource.ohdsi.schema>dbo</datasource.ohdsi.schema> | ||
| + | <flyway.datasource.driverClassName>${datasource.driverClassName}</flyway.datasource.driverClassName> | ||
| + | <flyway.datasource.url>${datasource.url}</flyway.datasource.url> | ||
| + | <flyway.datasource.username>ohdsi_app_user</flyway.datasource.username> | ||
| + | <flyway.datasource.password>app1</flyway.datasource.password> | ||
| + | <flyway.locations>classpath:db/migration/sqlserver</flyway.locations> | ||
| + | <security.enabled>false</security.enabled> | ||
| + | <security.token.expiration>43200</security.token.expiration> | ||
| + | <security.origin>*</security.origin> | ||
| + | <security.ssl.enabled>false</security.ssl.enabled> | ||
| + | <security.oauth.callback.ui>http://localhost/atlas/#/welcome</security.oauth.callback.ui> | ||
| + | <security.oauth.callback.api>http://localhost:8080/WebAPI/user/oauth/callback</security.oauth.callback.api> | ||
| + | <security.oauth.google.apiKey></security.oauth.google.apiKey> | ||
| + | <security.oauth.google.apiSecret></security.oauth.google.apiSecret> | ||
| + | <security.oauth.facebook.apiKey></security.oauth.facebook.apiKey> | ||
| + | <security.oauth.facebook.apiSecret></security.oauth.facebook.apiSecret> | ||
| + | </properties> | ||
| + | </profile> | ||
| + | </profiles> | ||
| + | </settings> | ||
| + | |||
| + | Note: this file above is saved as /WebAPIConfig/settings.xml and will be referred to in the “Building the .war file section”. | ||
| + | |||
| + | **Download the appropriate JDBC driver** | ||
| + | |||
| + | For SQL Server, the driver is available from the Maven repository, so no additional steps are required. | ||
| === PostgreSQL === | === PostgreSQL === | ||
| **Create settings.xml File** | **Create settings.xml File** | ||
| - | Specify user name, password, and location of the OHDSI schema (this was created as ‘webapi’ from the [[https://github.com/OHDSI/WebAPI/wiki/PostgreSQL-Installation-Guide|PostgreSQL Setup Guide]]. Note that the user should have read, write, and create privileges on the OHDSI schema. | + | Specify user name, password, and location of the OHDSI schema (this was created as ‘webapi’ from the [[documentation:software:webapi:postgresql_installation_guide|PostgreSQL Setup Guide]]. Note that the user should have read, write, and create privileges on the OHDSI schema. |
| Here is an example XML that is based on the above configuration: | Here is an example XML that is based on the above configuration: | ||
| Line 73: | Line 113: | ||
| <flyway.datasource.password>!PASSWORD!</flyway.datasource.password> | <flyway.datasource.password>!PASSWORD!</flyway.datasource.password> | ||
| <flyway.locations>classpath:db/migration/postgresql</flyway.locations> | <flyway.locations>classpath:db/migration/postgresql</flyway.locations> | ||
| + | <security.enabled>false</security.enabled> | ||
| + | <security.token.expiration>43200</security.token.expiration> | ||
| + | <security.origin>*</security.origin> | ||
| + | <security.ssl.enabled>false</security.ssl.enabled> | ||
| + | <security.oauth.callback.ui>http://localhost/atlas/#/welcome</security.oauth.callback.ui> | ||
| + | <security.oauth.callback.api>http://localhost:8080/WebAPI/user/oauth/callback</security.oauth.callback.api> | ||
| + | <security.oauth.google.apiKey></security.oauth.google.apiKey> | ||
| + | <security.oauth.google.apiSecret></security.oauth.google.apiSecret> | ||
| + | <security.oauth.facebook.apiKey></security.oauth.facebook.apiKey> | ||
| + | <security.oauth.facebook.apiSecret></security.oauth.facebook.apiSecret> | ||
| </properties> | </properties> | ||
| </profile> | </profile> | ||
| Line 86: | Line 136: | ||
| === Oracle === | === Oracle === | ||
| **Create settings.xml File** | **Create settings.xml File** | ||
| - | Specify user name, password, and location of the OHDSI schema (this was created as ‘ohdsi’ above). Note that the user should have read, write, and create privileges on the OHDSI schema because this user is the owner of the 'ohdsi' schema. | + | Specify user name, password, and location of the OHDSI schema (this was created as ‘ohdsi’ in the [[documentation:software:webapi:oracle_db_setup_guide|Oracle Setup Guide]]). Note that the user should have read, write, and create privileges on the OHDSI schema because this user is the owner of the 'ohdsi' schema. |
| Here is an example XML that is based on the above configuration: | Here is an example XML that is based on the above configuration: | ||
| Line 104: | Line 154: | ||
| <flyway.datasource.password>{password}</flyway.datasource.password> | <flyway.datasource.password>{password}</flyway.datasource.password> | ||
| <flyway.locations>classpath:db/migration/oracle</flyway.locations> | <flyway.locations>classpath:db/migration/oracle</flyway.locations> | ||
| + | <security.enabled>false</security.enabled> | ||
| + | <security.token.expiration>43200</security.token.expiration> | ||
| + | <security.origin>*</security.origin> | ||
| + | <security.ssl.enabled>false</security.ssl.enabled> | ||
| + | <security.oauth.callback.ui>http://localhost/atlas/#/welcome</security.oauth.callback.ui> | ||
| + | <security.oauth.callback.api>http://localhost:8080/WebAPI/user/oauth/callback</security.oauth.callback.api> | ||
| + | <security.oauth.google.apiKey></security.oauth.google.apiKey> | ||
| + | <security.oauth.google.apiSecret></security.oauth.google.apiSecret> | ||
| + | <security.oauth.facebook.apiKey></security.oauth.facebook.apiKey> | ||
| + | <security.oauth.facebook.apiSecret></security.oauth.facebook.apiSecret> | ||
| </properties> | </properties> | ||
| </profile> | </profile> | ||
documentation/software/webapi/webapi_installation_guide.txt · Last modified: 2019/04/19 16:23 by anthonysena
Page Tools
