Importing Data (Tools/APIs)
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.
-
The Import Globals page, which imports globals from .gof files. See Importing Globals.
You can also import data from .txt files or .csv files into SQL tables by using the LOAD DATA SQL command. This command also enables you to import data from JDBC sources by using a SQL Gateway Connection.
Available Tools
Enables you to import text files into SQL tables. For information, see %SQL.ExImDataOpens in a new tab, the utility class from which %SQL.Import.MgrOpens in a new tab 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.
Includes the Import() class method
Availability: All namespaces.
Numerous tools within InterSystems IRIS® data platform provide more specific import options, documented elsewhere.
