Bulk loading data to IBM Netezza databases

The following points may help you to configure for bulk loading from IBM® SPSS® Modeler to an IBM Netezza database using the External Loader option in the DB Export Advanced Options dialog box.

Ensure that the Netezza nzload utility is installed

The script netezza_loader.py invokes the Netezza utility nzload. Ensure that nzload is installed and correctly configured on the server on which netezza_loader.py is to be executed.

Exporting non-ASCII data

If your export contains data that is not in ASCII format, you may need to add -encoding UTF8 to the Extra loader options field in the DB Export Advanced Options dialog box. This should ensure that non-ASCII data is correctly uploaded.

Date, Time and Timestamp format data

In the stream properties, set the date format to DD-MM-YYYY and the time format to HH:MM:SS.

Blank strings

Blank strings are exported to the database as NULL values.

Different order of columns in stream and target table when inserting data into an existing table

If the order of columns in the stream is different from that in the target table, data values will be inserted into the wrong columns. Use a Field Reorder node to ensure that the order of columns in the stream matches the order in the target table. See the topic Field Reorder Node for more information.

Tracking nzload progress

When running IBM SPSS Modeler in local mode, add -sts to the Extra loader options field in the DB Export Advanced Options dialog box to see status messages every 10000 rows in the command window opened by the nzload utility.