Data loading components
IBM® Netezza® provides several components for loading data into the appliance.
The components are as follows:
- External tables
- Tables that are stored as flat files on the host or client systems and not in the Netezza database. You can use these tables to load data into the Netezza appliance. For more information, see External tables.
- The nzload command
- A command that provides an easy method for using external tables and getting data into the Netezza appliance. For more information, see nzload command.
- File format options
- Several options that you can use to format the data load to and from external tables. Because data comes in different forms, the Netezza product provides different ways of setting up the load. For more information, see nzload command and Examples of data loading with the fixed-length format.
- Back up and restore utilities
- The Netezza backup and restore utilities provide different methods for transferring data between Netezza systems. One method is to create external tables and use the nzload command, described in External tables and nzload command. For more information about backups and restores, see the IBM Netezza System Administrator’s Guide.
- The nz_migrate utility
- A separate tool in the general purpose scripts that are supplied in the Netezza Software Support Tools package. This utility is a script that can migrate (copy) a database or table from one Netezza appliance to another or make a copy of a database or table on the same server. For online help, use the nz_migrate -? command.