Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Passing parameter from different source into insert statement using Nifi

Passing parameter from different source into insert statement using Nifi

New Contributor

I'm still new in NiFi. What I want to achieve is to pass a parameter from a different source.

Scenario:

I have 2 datasource which is Json string data from web api and record id (from oracle db function). I declared record id using extract text as "${recid}" and json string default is "$1" .

 

How to insert into table using sql statement insert into table1 (json,recid) value ('$1','${recid}')

 

After I run the processor. I'm not able to get both attribute into one insert statement.

 

Please help.

 

nifi.pngScreenshot_1.png

 

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