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
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.