Data loading components
There are several components provided for loading data into the system.
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 Performance Server database. You can use these tables to load data into the Netezza Performance Server system. 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 Performance Server system. 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 Performance Server 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 Performance Server backup and restore utilities provide different methods for transferring data between Netezza Performance Server 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 Performance Server Software Support Tools package. This utility is a script that can migrate (copy) a database or table from one Netezza Performance Server system to another or make a copy of a database or table on the same server. For online help, use the nz_migrate -? command.