Created on 03-05-2020 03:52 AM - last edited on 03-05-2020 01:34 PM by ask_bill_brooks
Hi,
I am new with nifi and i am trying to load large csv file into sql server with nifi..
someone can help me please?
Cordialy,
A.HGB
Created 03-05-2020 05:04 AM
@ahadi I would recommend to spend some time researching similar posts in this community.
There are loads (search "csv" in Apache NiFi Label):
https://community.cloudera.com/t5/forums/searchpage/tab/message?filter=labels&q=csv&collapse_discuss...
Here is a good one (introduce yourself to record reader):
https://community.cloudera.com/t5/Community-Articles/Convert-CSV-to-JSON-Avro-XML-using-ConvertRecor...
I also have an example (split file into lines, parse lines for values, insert) in my GitHub:
https://github.com/steven-dfheinz/NiFi-Templates
Created 03-05-2020 06:34 AM
Thank you very much for answer i will try it