I'm attempting to connect to a Netezza server, and gettting an error. I've tried both the tNetezzaInput component, and the tJDBCInput connection, both generate the same error. The error: when I run a simple job to retrieve data: "A connection error has occurred: Invalid - database name" (full text below) I know that the underlying connection is good, as it is possible to create a new connection, then do "Import Schema" using both Netezza and JDBC options. The Import Schema correctly retreives various tables. Any ideas? Exception in component tNetezzaInput_2 org.netezza.util.PSQLException: A connection error has occurred: Invalid - database name at org.netezza.core.PgHandshake.handshake(Unknown Source) at org.netezza.core.PgHandshake.connect(Unknown Source) at org.netezza.jdbc1.AbstractJdbc1Connection.handshake(Unknown Source) at org.netezza.jdbc1.AbstractJdbc1Connection.openConnection(Unknown Source) at org.netezza.Driver.getConnection(Unknown Source) at org.netezza.Driver.connect(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at testjava.testnetezza_0_1.testnetezza.tNetezzaInput_2Process(testnetezza.java:888) at testjava.testnetezza_0_1.testnetezza.runJobInTOS(testnetezza.java:1547) at testjava.testnetezza_0_1.testnetezza.main(testnetezza.java:1459)
I am now able to successfully run a simple job to extract and load tables in netezza. I'm not sure what the solution was, I re-created the job from scratch and it now works, in both tNetezzaInput/Output and ODBC components.