OMOP
Space shortcuts
Space Tools
OMOP OMOP

Versions Compared

Old Version 15

changes.mady.by.user Janice Donahoe

Saved on

compared with

New Version 16

changes.mady.by.user Janice Donahoe

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Section

Overview of CRC Data Installation

The crcdata tables are part of the Data Repository (CRC) Cell. The following outlines the steps that will be taken during the crcdata installation.

Step 1:   Change your working directory

Step 2:   Set the database properties for the crcdata 

Step 3:   Create the Data Repository (CRC) tables, indexes and sequences

Step 4:   Create the stored procedures

Step 5:   Load sample data into the tables

Step 6:   Create the OMOP views

Section

Step 1: Change Working Directory 
Anchor
omop_crcdata_step1
omop_crcdata_step1

During the CRC Data Installation we will be working with the crcdata directory. Within this directory are the files we will be editing to define the database properties, create the crcdata tables and load the sample data provided with the i2b2 on OMOP data package.

To change your working directory to the crcdata directory enter the following command:

Panel
borderColor#ccc
bgColor#ffffff
titleBGColor#DDD9C3
borderStylesolid
titleChange Directory Command

indent
Level1

CD YOUR_I2B2_DATA_DIR\i2b2_omop_data\{oracle|sqlserver}\CRCdata

Section

Excerpt
html-text
<div class="i2b2-panel">
        <table class="i2b2-important">
            <colgroup>
                <col width="24">
                <col>
            </colgroup>
            <tbody>
                <tr>
                    <th><td>
                        <img src="https://community.i2b2.org/wiki/download/attachments/14091764/icon_important.png" width="16" height="16" align="absmiddle" alt="importantinfo" border="0">
                    </th>td>
                    <th>
    <td>
                    <b>Important</b>
                    </th>
                </tr>
                <tr>
                    <td>
                    </td>
                    <td>The <br>The change directory command shown above is written for Windows. The command itself is the same for both Linux and Windows with the only exceptions being the slashes in the path name and Linux does not include the "drive".
					<br>
					<ul>
						<li><i>Linux Path:</i> use a forward slash.</li>
						<li><i>Windows Path:</i> use a backward slash.</li>
					</ul>
                    </td>
                </tr>
            </tbody>
        </table>
    </div>

Section


EXAMPLES:

indent
Level2

Windows Command:  CD C:\opt\data\i2b2_omop_data\oracle\CRCdata

indent
Level2

Linux Command:  CD /opt/data/i2b2_omop_data/oracle/CRCdata

OMOP OMOP