Page History
...
In the Directory Structure and Schema section of this installation guide we reviewed how the data installation files are structured within the i2b2_omop_data package. Each set of data tables (crcdata, metadata, and workdata) has its own data files for installing the appropriate data. Within each of these directories is a file called db.properties that needs to be updated with your environment variables before we can begin installing the crcdata metadata tables.
Steps for setting database properties
...
| Panel | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
Oracle Database db.type=oracle db.username=YourCdmDatabaseUser db.password=PasswordForYourCdmDatabaseUser db.server=LocationOfYourCdmDatabase:1521:xe db.driver=oracle.jdbc.driver.OracleDriver db.url=jdbc:oracle:thin:@LocationOfYourCdmDatabase:1521:xe db.project=omopOMOP PostgreSQL Database db.type=postgresql db.username=YourCdmDatabaseUser db.password=PasswordForYourCdmDatabaseUser db.driver=org.postgresql.Driver db.url=jdbc:postgresql://LocationOfYourCdmDatabase/i2b2?searchpath=i2b2demodataYourCdmDatabase db.project=omopOMOP SQL Server Database db.type=sqlserver db.username=YourCdmDatabaseUser db.password=PasswordForYourCdmDatabaseUser db.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver db.url=jdbc:sqlserver://LocationOfYourCdmDatabase:1433;database=demoNameOfYourCdmDatabase db.project=omopOMOP |
3. Save the changes and close the file.
...
