Support Questions
Find answers, ask questions, and share your expertise

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


Super Guru

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.

; ;