Well, with the release of 4.0, there's a new 'Database-Driven' step type that allows for querying another database to pull in a data element for the workflow.
If you're curious I would recommend looking this up in the inline help (the 'Help' link in the upper-right when you're logged in).
Does this sound like what you're looking for?