Configuring Data Ship for Netezza
All Netezza data source connection configurations must be set to take advantage of the data ship optimization. Refer to the TDV Netezza Adapter Guide. You can now complete the set-up in
Finishing Data Ship Configuration for Data Sources.
Optionally, if you need to move data that has NUL characters, you can use the following procedure to determine how those characters characters are managed by TDV.
When the Ignore Nul Characters in Strings configuration parameter is true, NUL('\0') characters get discarded by Netezza and rest of the String is loaded. When the configuration parameter is false, NUL characters in Strings are not discarded. The default value is false.
To ignore Nul characters in strings
1. Make sure you have both Modify All Config and Access Tools rights.
2. Log into Studio as the admin user.
3. From the Administration menu, choose Configuration.
4. In the tree pane, navigate to Data Sources > Netezza Sources > Ignore Nul Characters in Strings.
5. Select True.
When set to false, NUL characters in strings are not discarded.
6. Click Apply.
7. Click OK.
This Studio configuration change is not immediately propagated to other open instances of Studio connected with this server.
8. Restart the TDV Server.