i2b2 - Mapped Importer Data Sources

Below are the settings for the specific Data Sources for the i2b2 Mapped Importer

MsSqlDataSourceSet

Settings

• type: uk.org.briccs.i2b2mappedimport.input.sql.MsSqlDataSourceSet
• Server: The name of the SQL Server
• instance: The name of the SQL Server instance
• database: The name of the SQL Server database
• username: The username required to log on
• password: The password for the above user
• query: The query used to extract the patient data

The query should return a row for each patient, and contain a patient identifier.

Mapping Source

The source attribute list for mappings should contain one item: the name of the field from the query.

MySqlDataSourceSet

Settings

• type: uk.org.briccs.i2b2mappedimport.input.sql.MySqlDataSourceSet
• Server: The name of the SQL Server
• database: The name of the SQL Server database
• username: The username required to log on
• password: The password for the above user
• query: The query used to extract the patient data

The query should return a row for each patient, and contain a patient identifier.

Mapping Source

The source attribute list for mappings should contain one item: the name of the field from the query.

CsvDataSourceSet

Settings

• type: uk.org.briccs.i2b2mappedimport.input.csv.CsvDataSourceSet
• Server: The name of the SQL Server
• database: The name of the SQL Server database
• username: The username required to log on
• password: The password for the above user
• query: The query used to extract the patient data

The query should return a row for each patient, and contain a patient identifier.

Mapping Source

The source attribute list for mappings should contain one item: the name of the field from the query.

OnyxDataSourceSet

Settings

• type: uk.org.briccs.i2b2mappedimport.onyx.OnyxDataSourceSet
• export_directory: The directory where the exported questionnaires are stored

This is a data source written to import questionnaire data exported from the Onyx questionnaire tool.

The tool exports a set of questionnaires into a series of sub-directories, each directory containing the results for all patients for one questionnaire. Each questionnaire folder contains a file called Entities.xml that maps patients to numbered XML files within the same directory (for example 00000001.xml).

Mapping Source

The source attribute list for mappings should contain two items. The first is the name of the questionnaire folder, the second is the name of the variable element within the patient's numbered XML file.