Developers Getting Started With i2b2
Space shortcuts
Space Tools

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin


The i2b2 data is stored in a relational database in a star schema format. Currently, the i2b2 supports three different database management systems (DBMS); Only one of them is required to store your i2b2 data.

indent
Level3

1. Oracle


indent
Level3

2. PostgreSQL


indent
Level3

3. SQL Server



The DBMS you choose to use is dependent on what works best for your institution. At this point in the installation all that we require is that you have a DBMS setup in your environment.


If you do not have a DBMS currently setup then you will need to do so at this point in the installation. The setup of the DBMS is specific to the version you are installing, therefore we recommend you follow the installation procedures documented by the vendor providing the software. The following table provides the links to the websites for each DBMS.


DBMS

Version

Website

Oracle

12 and 18

http://www.oracle.com/us/downloads/index.html

PostgreSQL

9.x (and 10.x unofficially)

http://www.postgresql.org/download/

SQL Server

2012+ (through 2019)

https://www.microsoft.com/en-us/sql-server/sql-server-downloads