Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Can we connect NiFi Processor QueryDatabaseTable to Netezza Database?

Solved Go to solution
Highlighted

Can we connect NiFi Processor QueryDatabaseTable to Netezza Database?

New Contributor
 
1 ACCEPTED SOLUTION

Accepted Solutions

Re: Can we connect NiFi Processor QueryDatabaseTable to Netezza Database?

Expert Contributor

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 REPLIES 2

Re: Can we connect NiFi Processor QueryDatabaseTable to Netezza Database?

Expert Contributor

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

Re: Can we connect NiFi Processor QueryDatabaseTable to Netezza Database?

New Contributor

HI @Mats Johansson,


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

Don't have an account?
Coming from Hortonworks? Activate your account here