Changes between Initial Version and Version 1 of i2b2 HowTo Create a Project

Timestamp:

07/16/13 08:36:07 (11 years ago)

Author:

Richard Bramley

Comment:

--

i2b2 HowTo Create a Project

@@ +1 @@
+= 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:
+
+  {{{
+  #!sql
+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. Run Project Creation scripts
+
+i. 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.
+i. 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
+
+iii. In the same directory, edit the file defaults.sh.