Message-ID: <675075523.7816.1711645564292.JavaMail.confluence@ip-172-30-4-17.ec2.internal> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_7815_176677197.1711645564289" ------=_Part_7815_176677197.1711645564289 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html 3.5.2 Set Database Properties

3.5.2 Set Database Properties

Step 2: Set Database Properties for Hivedata Tables

= =20

As stated earlier each i2b2 database schema has a corresponding director= y that contains the data files for installing the data. Each of these direc= tories has a file called db.properties and it needs to be = updated with your environment variables.

=20


=20

= Steps for setting database properties

=20


Assumptions:

=20 =20


=20
1. At the command prompt type the following:
=20


=20
Linux Command
=20

      open db.properties

=20
=20


=20
Windows Command
=20

      db.properties

=20
=20



= =20
2. The=20 db.properties file will open. Set the following properties= for the DBMS at your site:=20
=20


=20

Important

=20

When setting the database properties make sure you set the user to i2b2hive. Projects are not assigned to Hivedata which is why th= e db.project property is not in the hive's db.properties file.

=20



= =20
Database Properties File
=20

Oracle Database

=20
db.type=3D oracle=20
=20
db.username=3D i2b2hive=20
=20
db.password=3D demouser=20
=20
db.server=3D LocationOfYourDatabase :1521:xe=20
=20
db.driver=3D oracle.jdbc.driver.OracleDriver=20
=20
db.url=3D jdbc:oracle:thin:@ LocationOfYourDatabase :1521:xe=20
=20



PostgreSQL Database

=20
db.type=3D postgresql=20
=20
db.username=3D i2b2hive=20
=20
db.password=3D demouser=20
=20
db.driver=3D org.postgresql.Driver=20
=20
db.url=3D jdbc:postgresql:// LocationOfYourDatabase /i2b2?searchpath=3Di2b2hive=20
=20



SQL Server Database

=20
db.type=3D sqlserver=20
=20
db.username=3D i2b2hive=20
=20
db.password=3D demouser=20
=20
db.driver=3D com.microsoft.sqlserver.jdbc.SQLServe= rDriver=20
=20
db.url=3D jdbc:sqlserver:// LocationOfYourDatabase :1433;database=3Ddemo=20
=20


=20
=20



= =20
3. Save the changes and close the file.=20
=20


=20
Tip

=20

To save yourself steps, DO NOT close your Command Prompt window as you w= ill be continuing to use it throughout the remainder of the installation.

=20




------=_Part_7815_176677197.1711645564289--