Hi Gennady, you should set up a jdbc connection pool controller service and connect it to your postgres instance. Then you will need a csv record reader controller service, configured with the correct csv format. Eventually, put an ExecuteSQLRecord processor onto the canvas. It should use the connection pool and the csv reader. Check the remaining properties of the processor for more config options. Cf. also https://nifi.apache.org/docs/nifi-docs/html/user-guide.html. Of course, you will need some processor to get the csv files in the first place. For local files, use GetFile. So that depends on the source of your files. When the correct processor is found, connect it to the sql processor (success relationship). When using GetFile, you will need to put a GenerateFlowfile processor in front of it, and connect them. When starting it, it will produce a flowfile. The GetFile proc will obtain the data, the sql processor will insert it into the db. Make sure to configure error relationships as well by e.g. terminating them (just to get you started). I hope, you will manage to go on from there. The docs are pretty extensive, as is the user mailing list archive.
Best, Lars On 6 October 2023 18:06:56 CEST, Gennady Kondratov <[email protected]> wrote: >How to Connect Apache NiFi to PostgreSql and using nifi insert records from >csv file to database/ >i'd like to ask you how to get it or where looking for about it >
