Step 3: Configure the data source for the PM Cell #

The PM cell needs to communicate with your i2b2 database and in order to do this it needs to know where the tables for the pmdata reside. Therefore the third and final step in the cell configuration process is to configure the data sources for the PM Cell. This information is configured in the pm-ds.xml file.

Things to keep in mind when configuring your datasources: #

When configuring your data sources you want to make sure you edit the following:

• The pmdata tables were created during the chapter on Data Installation.

• The PMBootStrapDS points to the data source for your pm tables.
  • The and need to match the database user you set up for your pmdata. In the i2b2 demo database this is i2b2pm and demouser.

• The needs to have the following:
  • The correct JDBC information for your type of database.
  • The correct location of the database containing your pmdata tables.

• Both the and need to accurately reflect the type of database you are connecting to.

Steps to configure data sources #

The following steps define how to configure your data sources for the PM Cell.

Oracle Database #

	jdbc:oracle:thin:@localhost:1521:xe
	oracle.jdbc.OracleDriver
	ojdbc6.jar
	
		i2b2pm
		demouser
	
	
		false
		false
	
	
		false
	

PostgreSQL Database #

	jdbc:postgresql://localhost:5432/i2b2
	org.postgresql.Driver
	postgresql-9.2-1002.jdbc4.jar
	
		i2b2pm
		demouser
	
	
		false
		false
	
	
		false
	

SQL Server Database #

	jdbc:sqlserver://localhost:1433
	com.microsoft.sqlserver.jdbc.SQLServerDriver
	sqljdbc4.jar
	
		i2b2pm
		demouser
	
	
		
		false
	
	
		false