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:12] 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> | ||
| === 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 107: | ||
| <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 130: | ||
| === 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 148: | ||
| <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
