What is the best practise to make update from select (different DBs) ?

In automation what it the best way to achieve that?

Message was edited by: sergeyer