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

Nifi || Unable to insert CSV records into database.

Nifi || Unable to insert CSV records into database.

Explorer

Hi All,

 

I am preparing a flow to insert the records from csv file to database.

Following processors used by me are attached hereby.

 

Also it is:

Executesqlrecord > Update Attribute > ValidateCSV > PutDatabaserecord.

 

current flow.png

 

I am unable to proceed with the same please guide I want to have database entry from generated csv.

 

I have same structure of table as CSV column name.

TIME

CAUSE

CATEGORY

PREVIOUS_COUNT

CURRENT_COUNT

5_MIN_RATIO

AVERAGE

STDDEV

COEFFICIENT

SEVERITY