Support Questions
Find answers, ask questions, and share your expertise

Inserting data using Putdatabaserecord processor

Highlighted

Inserting data using Putdatabaserecord processor

New Contributor

I am new to nifi data tool. Below is my requirement.

I have csv file with below content.

empid,empname,salary
1,'John',1000
2,'Alex',2000
3,'',3000
4,'',5000

I have to process only those records where empname is not null, to achieve this
i am using queryrecord processor and i am getting below records which is fine.

empid,empname,salary
1,'John',1000
2,'Alex',2000

Before inserting above values in oracle database, the first below four fields have data like below.

record_id : seq_file_id.nextval||lpad(rownum,16,0)
file_id : seq_file_id.nextval
source_id : 20
vendor_id : 30

structure of table(emp)
=======================
RECORD_ID NUMBER
FILE_ID NUMBER
SOURCE_ID NUMBER
VENDOR_ID NUMBER
EMPID VARCHAR2(200)
EMPNAME VARCHAR2(100)
SALARY VARCHAR2(200)

how should i insert values using Putdatabaserecord Processor ? Any help will be much appreciated.