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.

exeutesql to putsql

Highlighted

exeutesql to putsql

New Contributor

Hi, I'm new to nifi. can anyone help me.

I'm trying to get data from one database and put that in another database.

I'm following the flow GenerateTablefecth -> ExecuteSQL -> Covertrecord -> PutSQL

but at putsql record it fails to execute my insert 107531-screenshot-2.png

1 REPLY 1

Re: exeutesql to putsql

You have specified the SQL Statement property but haven't supplied any values. I recommend replacing PutSQL with PutDatabaseRecord with a Statement Type of INSERT, this should do what you are trying to do.