Step 1: Change Working Directory 

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

Working directory for metadata: YOUR_I2B2_OMOP_DATA_DIR\i2b2_omop_data\{oracle|sqlserver}\metadata

How to Change Directories

Make sure you replace the following when entering the above command:

• YOUR_I2B2_OMOP_DATA_DIR is the location where you unzipped the i2b2 omop data package.
• oracle|sqlserver is the type of database management system used for your CDM database.

Important 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". Linux Path: use a forward slash. Windows Path: use a backward slash.

EXAMPLES:

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

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

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

Change Directory Command

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

Important 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". Linux Path: use a forward slash. Windows Path: use a backward slash.

EXAMPLES:

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

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