i2b2 - Create Project

This is the procedure to create a new project in i2b2. Most of the process is carried out by Jeff's create project scripts, but there is some preparation work that could perhaps be incorporated into the scripts at some point.

Procesdure

1. Create Databases

Run the following SQL script. Change [ProjectName] to be the actual project name:

CREATE DATABASE [ProjectName]_MetaData
GO
CREATE DATABASE [ProjectName]_Data
GO
CREATE DATABASE [ProjectName]_WorkData
GO

CREATE LOGIN [ProjectName]_MetaData WITH PASSWORD = '[ProjectName]_MetaData';
GO
CREATE LOGIN [ProjectName]_Data WITH PASSWORD = '[ProjectName]_Data';
GO
CREATE LOGIN [ProjectName]_WorkData WITH PASSWORD = '[ProjectName]_WorkData';
GO

USE [ProjectName]_MetaData
CREATE USER [ProjectName]_MetaData FOR LOGIN [ProjectName]_MetaData
GO
EXEC sp_addrolemember N'db_owner', N'[ProjectName]_MetaData'
GO

USE [ProjectName]_Data
CREATE USER [ProjectName]_Data FOR LOGIN [ProjectName]_Data
GO
EXEC sp_addrolemember N'db_owner', N'[ProjectName]_Data'
GO

USE [ProjectName]_WorkData
CREATE USER [ProjectName]_WorkData FOR LOGIN [ProjectName]_WorkData
GO
EXEC sp_addrolemember N'db_owner', N'[ProjectName]_WorkData'
GO

2. Edit Project Creation Config and Scripts

1. As the scripts have some hard coded elements it is necessary to take a copy of the procedures directory and change the hard coded values. Therefore, copy the /usr/local/i2b2-procedures-1.1-production directory.
2. In the new procedures directory, amend the file config/config.properties.

The following values need amending:

• project.name
• crc.ds.jndi.name
• ont.ds.jndi.name
• work.ds.jndi.name
• db.project.data.databasename
• db.project.data.username
• db.project.data.password
• db.project.meta.databasename
• db.project.meta.username
• db.project.meta.password
• db.project.work.databasename
• db.project.work.username
• db.project.work.password
• import.user
• import.password
• import.pmURL
• import.domainID
• import.projectID

1. In the same directory, edit the file defaults.sh.

The following values need amending:

• CRC_DS
• ONT_DS
• WORK_DS

Also, ensure that the following variables contain the correct directories:

• JBOSS_HOME
• ANT_HOME
• JAVA_HOME