Support Questions
Find answers, ask questions, and share your expertise
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

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


Re: exeutesql to putsql

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.

Don't have an account?
Coming from Hortonworks? Activate your account here