I am learning and trying to use NiFi to solve data transferring tasks. Now I have a requirement to lock down a same database connection instance between multiple processors.

My flow steps like this:
1.read data from source database
2.create a temp table in target database
3.insert data into the temp table
4.call a database function in target database to process and then drop the temp table

The 2, 3, 4 steps in the above steps require that its respective processors are in one same database connection session in order to share the temp table.

How could I ensure that?