IDRT - Integrated Data Repository Toolkit
Space shortcuts
Space Tools

Versions Compared

Old Version 11

changes.mady.by.user Benjamin Baum

Saved on

compared with

New Version Current

changes.mady.by.user Matthias Löbe

Saved on

Key

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

Import DB Table

To import data from another sql database, you need to add the server as a Datasource Server first. Select Show Datasource Servers in the Import Browser and right click the free area and select Add Datasource Server.

...

Name

Description

Truncate i2b2 Project?

If you check this, the project will be truncated before the data is uploaded.

Truncate Previous Queries?

This will truncate the previous queries tables.

Database Indexing

Ignore: Don't touch the indexes;
Stop/Start: Stop the indexes before the upload and start them afterwards;
Drop/Create: Drop the indexes before the upload and create them from scratch afterwards.

Set patient_count after import

This will fill the c_totalnum column.

Save Settings?

This will save the settings for the next import. Note: The truncate checks are never saved.

If you hit Finish the upload starts. You can observe the progress in the progress bar of the Import Browser.