Member since
09-11-2024
2
Posts
1
Kudos Received
0
Solutions
09-25-2024
02:09 PM
1 Kudo
Good afternoon MattWho, so I'm going to attach an image, maybe it will be clearer, your answer was very enlightening, but if I clear up those doubts about my question, your answer will be even clearer. Well, I'm doing the process of deleting data from a local bank, and inserting the entire database again, but why am I consulting the value before deleting? why do I need to check if the query returned values, if it didn't, I can't delete the database, that's why this order of processors that I explained, in short the process I would like to execute would be ExecuteSQL (query data in source database) -> RouteOnAttribute (if there are no lines, it will follow another path) -> ExecuteSQL (deletes the data from the local database, i.e., destination) -> PutDatabaseRecord (insert the base again into the destination database).
... View more
09-25-2024
11:00 AM
Hi guys, I'm relatively new to Apache Nifi, and there's a subject that I don't understand the logic behind, how to handle flowfiles between processors. Basically I need to extract the data from an ExecuteSQL processor, then execute another ExecuteSQL to delete the data from the destination and finally insert the data using PutDatabaseRecord, but the value of the first ExecuteSQL is overlapped by the second, and it needs to be done in that order to ensure that the data exists before deleting the old base, could anyone guide me?
... View more
Labels:
- Labels:
-
Apache NiFi