Can we connect NiFi Processor QueryDatabaseTable to Netezza Database?

[#1 · Accepted solution]

Hi @Sunil Mukati,

Yes it works with the "Generic" Database Type but it do not accept Netezza specific syntax. You also need to setup a DBCPConnectionPool and JDBC connection for your Netezza box.

/Best regards, Mats

[#2]

HI @Mats Johansson,

Could you please specify what syntax to be used to fetch contents of table.