Exporting to Netezza

Prerequisites

Having Netezza Configured as a Connection

Configuring Export Jobs to Netezza

To export a worksheet through a Netezza connector:

1. Click the "+" button and choose "Export Job" or right-click in the file browser and select "Create New" → "Export Job". The 'New Export Job' tab appears in the menu bar.
    or 
2. Click "Select" to select the workbook from the File Browser. The dialog "Select Workbook" opens. 
    
3. Select the workbook and confirm with "Select". The name of the workbook appears in the workbook field. 
    
4. Confirm with "Next". 
    
5. Select a worksheet from the drop-down and confirm with "Next". A preview of the selected sheet is displayed below. The 'Connection' tab opens. 
   INFO: Only kept sheets are available for export. If the drop-down is missing the sheet you want to export, modify the workbook settings to keep the sheet. 
    
6. Click on "Select Connection" to select the Netezza connection. The dialog 'Select Connection' opens. 
   INFO: If you haven't create the connection yet, you can do it here by clicking on "New Connection". 
    
7. Select the relevant Netezza connection and confirm with "Next". The selected connection is displayed under 'Connection'. 
    
8. Confirm with "Next". The 'Data Details' tab opens. 
    

9. Select the schema from the drop-down and decide if to use an existing table or create a new one. 
   INFO: If the data is being exported to a new table, enter the new table name below. 
   INFO: If the data is being exported to an existing file path, the previous data is written over by the current export.
    

10. Decide if the export job can overwrite the existing database table or keep the existing data and append rows to the table. 
    
11. If needed, adjust the default values for the maximum number of concurrent database connections, maximum records per transaction, rows per batch and the configuration for case sensitivity and confirm with "Next". The 'Mapping' tab opens.
    
12. Have a look a the preview and decide which columns shall be included and be nullable. 
    INFO: All checkboxes are activated by default. 
     
13. Decide how to handle invalid data and confirm with "Next". The 'Schedule' tab opens.
     
14. Select the schedule method for when the export job shall be run and confirm with "Next". The 'Save' tab opens. 
     
15. If needed, add a description.
    INFO: Deactivating the checkbox 'Start export immediately after save' will prevent the export starting immediately after saving.
     
16. If needed, add your email address in section 'Notification' to receive possible error notifications and confirm with "Save". The dialog 'Save Export Job' opens. 
    INFO: Datameer X can only send email notifications, if an email server has been configured.
    
    
17. Select the place to save the export job to and name the export job, confirm with "Save". The export job is shown in the File Browser.