exeutesql to putsql

[#1]

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

[#2]

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.