NiFi PutDatabaseRecord to Postgres

I have NiFi installed on Windows. On the same PC, I have a VirtualBox/Linux-based VM, on which I am running a Postgres database. The ip for the VM is 192.168.1.X, the ip/port for the database is localhost:xxxx.

NiFi/PutSFTP can put files on the VM using the VM’s host ip and default SFTP port. NiFi/PutDatabaseRecord cannot insert records into the database using localhost.

Here is the question: Given the information above, how do I set up NiFi/PutDatabaseRecord to insert data directly into the Postgres database?

Thanks,

John

Source: StackOverflow

LEAVE A COMMENT