If you look at the following two diagrams, you will see that they both obtain the password from a file...
Even if the two tables involved require different passwords, they should probably both be obtained from the same place...
If you look at https://github.com/jpaulm/fbp-etl/blob/master/src/main/java/com/jpaulmorrison/Step20/code/networks/Step20.java , you will see that we did exactly that: for both the (single) password, and for the user name.
Now, since "Extract" and "Load" are separate subnets, we will have to add another input port to each of these, and move the password reader outside of them - i.e. to the higher level.
However, first we will show the high-level diagram for this ETL app, with password access fully within the first and 3rd blocks - as below.
Thses are all subnets, so, when using DrawFBP, double clicking on each name in green will bring up the next lower level diagram... The higher level remains in a separate tab, so you can jump back and forth easily. The blue class names can be used to bring up class attributes, both for subnets and for lowest level components.
Now we will add an "external" Password block, and copy it to the two subnets that use it. The subnets will of course need to be modified to externalise the password function. Because the Password block has no inputs, this block effectively starts the whole network (remember that blocks with no non-IIP input connections are "self-starting" by FBP rules).
(The Password block will itself be a subnet, as it contains a ReadFile function, plus maybe more processing)
"Extract" now looks like this:
