About ralvad

ralvad · ‎05-25-2023

Hi @PBS I am looking for a similar solution. Did you manage to find a solution for this?

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-02-2022

@dominikschauer : I tried to use PutSQL processor to run a Postgres procedure. Unfortunately, i ended up with an error. I have given the details in the below thread https://community.cloudera.com/t5/Support-Questions/Execute-Postgres-Procedure-in-Nifi/m-p/358798#M237937 Could you please help. Thanks Mareena

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: Apache Nifi: I want to compare or find missi...

Re: Execute Postgres Procedure in Nifi

Re: Execute Stored Procedure of MSSQL in Nifi

Execute Postgres Procedure in Nifi