Step 1:

 Set up a project  project as documented here:  

1. Project Project Setup : Create  Create a project. In this step, you define a project path which will be used to reference the project later.  
2. 6.4.3 Cell DB-Lookup: Add new db_lookup entries for each of the core cells, to define how the project will connect to the db.

...

 Update DATASOURCE XML files IN WILDFLY IF NEEDED …

The CRC cell communicates with your i2b2db instance via the configurations set in crc-ds.xml.

The datasource parameter should be set in the CRCBootStrapDS  section to point to the datasource of the CRC_DB_LOOKUP table. The datasource parameter value can be found in the CRC_DB_LOOKUP.C_DB_DATASOURCE (this is built at the time of datamart creation)

Image Added

The datasource parameter should be set in the QueryToolDemoDS section to point to the datasource of your Crcdata tables location (star-schema and QT tables)  

Example crc-ds.xml 

Image Added

  <--- Need more detail

For detailed information refer to: https://community.i2b2.org/wiki/display/OMOP/Configure+Data+Sources

Image Removed

Step 5:

Load i2b2 tables into the database(s) used for the project as needed, making sure to update db properties file  file with the  db parameters  parameters (e.g., 3.4 Crcdata Tables, 3.7.4 Load Metadata Tables). For example, you might specify an existing database in the ontology db-lookup, but a new database in the CRC db lookup. In this case, you only need to create/load the tables in the CRC database.

<--- We don't need db.project highlighted in this screenshot.

Step 6

Finally add  add project users. Make sure to add AGG_SERVICE_ACCOUNT

...