I started my studies with Nifi.
I performed the query in a SQL database and inserted it into Elasticsearch. Now I would like to query a Mongo database according to the ID of each SQL result and then include the MONGO result in the SQL result. I know that I need use UpdateAttribute and ReplaceText processors. But I don't know how to pass to MONGO processor each ID and after take the results and include them in the SQL result that I had before.
Can you help me?