Use the PutSQL and ExecuteSQL processors. You can read more about them and their usage at the below link.
You can configure them as below:
Also, to get a better idea of how to chain the processors, take a look at the below article for an example flow that ingests data into a relational database using Nifi.
As always, if you find this post helpful, don't forget to "accept" answer
Hello, I am begineer on this topic. I want to connect my dataflow to store data in postgresql and google found your topic in the forum. I am trying all the things you said and the service remains "Enabling". Could you explain exactly the steps to enable this communication. From my side:
1. Download postgresql-42.2.8.jar.
2. Move to C:\Program Files\nifi-1.9.2\lib
3. Restart Nifi.
4. Configure DBCPConnectionPool with the following parameters:
Diver Class: org/postgresql/Driver.class
Driver Location: file:////C:/Program Files/nifi-1.9.2/lib/postgresql-42.2.8.jar
Is something wrong? Could you help me? The service remains "ENABLING"