---
title: Overview
description: "The data installation chapter outlines the process of installing the i2b2 data. This process involves creating tables, procedures and triggers as well as loading data into the tables. **Chapter 3. Table of Contents** ###### [3.0 Prerequisites](https://i2b2.org/docs/3-0-prerequisites/) ###### [3.2 Data Installation…"
url: "https://i2b2.org/docs/chapter-3-data-installation/"
updated: "2026-09-15"
category: i2b2 Installation Guide / Chapter 3. Data Installation
---

# Overview

The data installation chapter outlines the process of installing the i2b2 data. This process involves creating tables, procedures and triggers as well as loading data into the tables.

 **Chapter 3. Table of Contents**

###### [3.0 Prerequisites](https://i2b2.org/docs/3-0-prerequisites/)

###### [3.2 Data Installation Overview](https://i2b2.org/docs/3-2-data-installation-overview/)

- [3.2.1 Extract the i2b2 Data Package](https://i2b2.org/docs/3-2-1-extract-the-i2b2-data-package/)
- [3.2.2 Directory Structure and Schema Mapping](https://i2b2.org/docs/3-2-2-directory-structure-and-schema-mapping/)

###### [3.3 Create Database User Accounts](https://i2b2.org/docs/3-3-create-database-user-accounts/)

- [3.3.3 Create User Accounts in SQL Server](https://i2b2.org/docs/3-3-3-create-user-accounts-in-sql-server/)
- [3.3.1 Create User Accounts in Oracle](https://i2b2.org/docs/3-3-1-create-user-accounts-in-oracle/)
- [3.3.2 Create User Accounts in PostgreSQL](https://i2b2.org/docs/3-3-2-create-user-accounts-in-postgresql/)

###### [3.4 Crcdata Tables](https://i2b2.org/docs/3-4-crcdata-tables/)

- [3.4.4 Create Crcdata Stored Procedures](https://i2b2.org/docs/3-4-4-create-crcdata-stored-procedures/)
- [3.4.2 Set Database Properties](https://i2b2.org/docs/3-4-2-set-database-properties/)
- [3.4.5 Load Crcdata Tables](https://i2b2.org/docs/3-4-5-load-crcdata-tables/)
- [3.4.3 Create Crcdata Tables](https://i2b2.org/docs/3-4-3-create-crcdata-tables/)
- [3.4.1 Working Directory](https://i2b2.org/docs/3-4-1-working-directory/)

###### [3.5 Hivedata Tables](https://i2b2.org/docs/3-5-hivedata-tables/)

- [3.5.4 Load Hive Data](https://i2b2.org/docs/3-5-4-load-hive-data/)
- [3.5.1 Working Directory](https://i2b2.org/docs/3-5-1-working-directory/)
- [3.5.2 Set Database Properties](https://i2b2.org/docs/3-5-2-set-database-properties/)
- [3.5.3 Create Hive Tables](https://i2b2.org/docs/3-5-3-create-hive-tables/)

###### [3.6 IM Tables](https://i2b2.org/docs/3-6-im-tables/)

- [3.6.2 Set Database Properties](https://i2b2.org/docs/3-6-2-set-database-properties/)
- [3.6.4 Load IM Tables](https://i2b2.org/docs/3-6-4-load-im-tables/)
- [3.6.1 Working Directory](https://i2b2.org/docs/3-6-1-working-directory/)
- [3.6.3 Create IM Tables](https://i2b2.org/docs/3-6-3-create-im-tables/)

###### [3.7 Metadata Tables](https://i2b2.org/docs/3-7-metadata-tables/)

- [3.7.4 Load Metadata Tables](https://i2b2.org/docs/3-7-4-load-metadata-tables/)
- [3.7.1 Working Directory](https://i2b2.org/docs/3-7-1-working-directory/)
- [3.7.2 Set Database Properties](https://i2b2.org/docs/3-7-2-set-database-properties/)
- [3.7.3 Create Metadata Tables](https://i2b2.org/docs/3-7-3-create-metadata-tables/)

###### [3.8 PM Tables](https://i2b2.org/docs/3-8-pm-tables/)

- [3.8.1 Working Directory](https://i2b2.org/docs/3-8-1-working-directory/)
- [3.8.4 Create PM Triggers](https://i2b2.org/docs/3-8-4-create-pm-triggers/)
- [3.8.3 Create PM Tables](https://i2b2.org/docs/3-8-3-create-pm-tables/)
- [3.10.5 Load PM Tables](https://i2b2.org/docs/3-10-5-load-pm-tables/)
- [3.8.2 Set Database Properties](https://i2b2.org/docs/3-8-2-set-database-properties/)

###### [3.9 Workdata Tables](https://i2b2.org/docs/3-9-workdata-tables/)

- [3.9.4 Load Workdata Tables](https://i2b2.org/docs/3-9-4-load-workdata-tables/)
- [3.9.2 Set Database Properties](https://i2b2.org/docs/3-9-2-set-database-properties/)
- [3.9.3 Create Workdata Tables](https://i2b2.org/docs/3-9-3-create-workdata-tables/)
- [3.9.1 Working Directory](https://i2b2.org/docs/3-9-1-working-directory/)

###### [3.10 Next Steps](https://i2b2.org/docs/3-10-next-steps/)

###### [3.11 Multiple Fact Tables](https://i2b2.org/docs/3-11-multiple-fact-tables/)

###### [Patient Counting Scripts ("totalnum")](https://i2b2.org/docs/patient-counting-scripts-totalnum/)

###### [i2b2-on-OMOP With ENACT-OMOP Ontology v4.1](https://i2b2.org/docs/i2b2-on-omop-with-enact-omop-ontology-v4-1/)