Hello, i have been tasked with connecting to a netezza database endpoint, and i've made a good college try at it so far, but results are negative. i just get an 'unexpected error' popup with 'null' diagnostic information. error logs don't show anything more than that - just a few successful class loads relevant to this endpoint. netezza is essentially a postgres database. i have uploaded the (type 4) driver and i can see 3 different classes that i can specify for the class name and i have tried all of them. the port is 5480 (same as postgres). i have attempted to add properties as additional parameters as follows: url=jdbc:netezza://hostname:5480/dbname; user=admin; password=admin.
is there any guidance about setting up generic jdbc connections? i can't find a community thread or tip or document of any kind that explains how to do something like this, except that you need version 2+ and the driver must be type 4.