Space shortcuts
Space Tools

Versions Compared


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

About this chapter

The data installation chapter outlines the process of installing the i2b2 data that is specific to the i2b2 on OMOP project. This process involves creating tables, procedures, views as well as loading data into the tables. The i2b2 data being loaded is based off the CMS SynPUF 1k sample data that is provided by OMOP.

In this chapter we will be using the scripts provided in the data package to create tables and load them with sample data.


 Before moving forward with the installation of the i2b2 on OMOP tables the following requirements must be met:

Your i2b2 hivedata and pmdata tables have been installed and loaded with the data provided in the standard i2b2 data file.

  Installed your CDM tables and loaded data from the SynPUF sample data file.

The OHDSI maintains the CDM tables, for additional information on setting up these tables, please see the OMOP CDM page.

  Your CDM database or schema have been setup.

   A database user has been setup.

  • This user is needed to create and load data into the new i2b2 tables.
  • It is also used by the i2b2 Cells when they need to contact the database or schema.


<div class="i2b2-panel">
    <table class="i2b2-important">
            <col width="24">
                    <img src="" width="16" height="16" align="absmiddle" alt="info" border="0">
                    <br>The i2b2 tables need to reside within the same location as your CDM tables. During the installation you need to know the following information about your CDM database.
						<li>The url for the location of the database</li>
						<li>Name of your CDM database / schema.</li>
						<li>The username and password for the database user.</li>