About ralvad

ralvad · ‎12-02-2022

Thanks @dominikschauer . I tried ExecuteSQL processor to run the Postgres procedure and it ran succesfully. But I am getting the error while connecting PutSQL processor to ExecuteSQL processor. As part of my requirement , I need to execute the procedure(ExecuteSQL) after inserting data into a particular table using PutSQL processor. Is there any other way I can achieve this, that is run a procedure after successful insertion to a table. Thanks in advance

ralvad · ‎12-01-2022

I have requirement to execute a PostgreSQL procedure in Nifi, I tried to use Put Sql processor , but ended up getting error. Could someone let me know what I'm doing wrong. This is how my entire flow looks like. -querying from a table and putting the record to another stage table using the first 'PutSql' processor. And afterwards the second putsql processor to call my stored procedure.

Online	Offline
Last Visited	‎06-06-2023 05:11 AM

Member Since	‎12-01-2022 10:57 PM
Last Visited	‎06-06-2023 05:11 AM
Posts	4

Cloudera Community

Re: Execute Postgres Procedure in Nifi

Execute Postgres Procedure in Nifi