Member since
03-21-2022
2
Posts
0
Kudos Received
0
Solutions
03-22-2022
03:43 AM
Thanks for the explanation, @dmorvant .
From what you described, it seems to me that the ideal solution for this would be to use NiFi Parameters.
You could have 3 different Parameter Contexts, each of them with a different value for database.name.
Each one of the 3 Process Groups would use one of the Parameter Contexts. Then, when you create your DBCPConnectionPool controller service, you can specifyy the Database Connection URL parameter as, for example:
jdbc:postgresql://cdp.100.20.115.239.nip.io:5432/#{database.name}
With this, the controller service of each Process Group would connect to the database defined in the Parameter Context of that group. You don't even need a DBCPConnectionPoolLookup in this case.
Would that address you need?
What the NiFi version that you are using?
André
-- Was your question answered? Please take some time to click on "Accept as Solution" below this post. If you find a reply useful, say thanks by clicking on the thumbs up button.
... View more