Skip to main content

This is documentation for Caché & Ensemble.

For information on converting to InterSystems IRIS, see the InterSystems IRIS Adoption Guide and the InterSystems IRIS In-Place Conversion Guide, both available on the WRC Distributions page (login required).

Previous sectionNext section

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 Caché SQL.

  • The Import Globals page, which imports globals from .gof files. See “Importing Globals” in Using Caché 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()

  • CSVTOCLASS()

Availability: All namespaces.

%Global class

Includes the Import() class method

Availability: All namespaces.

Numerous tools within Caché and Ensemble provide more specific import options, documented elsewhere.

See Also