About this task
Create the schema and table structures on your Db2 Warehouse SaaS database target. You have
several options to do this, but the most effective way is to download, install, and use the download
IBM Database Conversion Workbench. This tool can help you to
convert your existing Netezza schema to one that's compatible with the Db2 Warehouse SaaS engine
database. After completing the conversion, the DCW produces a report that identifies which parts of
your source database DDL were automatically converted and which parts require manual intervention.
For more information, see the included step-by-step DCW guide.
Procedure
After your table structures are in place on the target database, you can start moving your
PureData System for Analytics (Netezza) tables. Start by extracting a table to a CSV file. Move that
file over the network, stage it in the landing zone on Db2 Warehouse SaaS, and then load it into
the database.
- Extract the table to a CSV file by running the following lift extract
command:
% lift extract --source-schema <source-schema-name> --source-table <source-table-name> --source-database ADMIN --source-host <source-database-host-name> --source-user <source-user-name> --source-password <source-password> --source-database-port <source-database-port> --file <path-to-csv-file>
- Move your CSV file and stage it in the landing zone of the target database by running the
following lift putcommand:
% lift put --file <path-to-csv-file> --target-user <target-user-name> --target-password <target-password> --target-host <target-database-host-name>
- Load your CSV file into the target engine database by running the following lift
load command:
% lift load --filename <csv-file-name> --target-schema <target-schema-name> --target-table <target-table-name> --file-origin extract-pda --target-user <target-user-nam> --target-password <target-password> --target-host <target-database-host-name>
The --file-origin extract-pda option specifies that the CSV file was extracted by using
the lift extract command.
You're done. You can now run SQL queries on your data from the database console.