Re: ETL processors for NiFi

Hey Mark, This would help me a lot in building the flow. Thanks a bunch!! Warm Regards, Karthik R. On Mon, Sep 19, 2016 at 3:11 PM, Mark Payne wrote: > Hi Karthik, > > I think what you want to be using here is PutSQL, rather than ExecuteSQL. > ExecuteSQL > is designed to

Re: ETL processors for NiFi

Hi Karthik, I think what you want to be using here is PutSQL, rather than ExecuteSQL. ExecuteSQL is designed to perform a SELECT statement, whereas PutSQL would update a database. PutSQL expects the incoming FlowFile to contain the SQL to execute. So you could use ReplaceText with the