Skip to main content

Importing Data

Import data programmatically.

Background Information

The Management Portal provides two generic options for importing data:

  • The Data Import Wizard, which imports data into SQL tables. See “Importing Data from a Text File” in Using InterSystems SQL.

  • The Import Globals page, which imports globals from .gof files. See “Importing Globals” in Using Globals.

Available Tools

Enables you to import text files into SQL tables. For information, see %SQL.ExImData, the utility class from which %SQL.Import.Mgr inherits.

Availability: All namespaces.

Enables you to import objects from relational databases. It includes support for data scrubbing.

Availability: All namespaces.

Provides the following methods, which you can use to import from CSV files:

  • CSV()


Availability: All namespaces.

%Global class

Includes the Import() class method

Availability: All namespaces.

Numerous tools within InterSystems IRIS provide more specific import options, documented elsewhere.

See Also