Muthu,
My recommendation is to create a Parameter Context and add a Parameter
called "Database Name", setting the value to the current source DB name.
Then refer to that parameter in your DBCPConnectionPool(s), like
"#{Database Name}". Then you can either change the value of the parameter
or create a new Parameter Context adding the Database Name parameter with
the new value then swap out the Parameter Context with the original.
If you're talking about dynamically discovering the database name, it
depends on the naming scheme but you may be able to use ExecuteSQL to
determine the current name of the source database. Could you provide more
information about your use case?
Thank you,
Matt
On Tue, Oct 14, 2025 at 1:54 AM Muthu Siva, M [ INDEC 4.0 ]
<[email protected]> wrote:
> Hi,
>
> I am using Apache Nifi for ETL from MS SQL Server to PostgreSQL, but my
> source Database name is changing every month and it's not predictable. I
> need to automatically find and update the current DB name in DBCP
> connection Pool. Can you share any solution for mentioned scenario.
>
>
>
> Thanks & Regards,
>
> Muthu Siva Malaichamy
> Database Admin
>
