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

how to load large csv file into sql server with nifi?

how to load large csv file into sql server with nifi?

New Contributor

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

2 REPLIES 2

Re: how to load large csv file into sql server with nifi?

@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

 

 

Re: how to load large csv file into sql server with nifi?

New Contributor

Thank you very much for answer i will try it