Many Netezza configurations have unusual conventions with case-sensitive names. Have you tried setting the database name to all upper-case? Likewise, your user name and the name of the table may have to match the expected case exactly.
If you are still having problems connecting, please contact our excellent support team (firstname.lastname@example.org) so they may work with you to collect logs, investigate the problem and find a resolution or workaround.
Thanks Robert. I updated the database name to all CAPS and connected without issue.
Excellent! Thanks for replying to let us know that this worked for you.