A request that we get frequently enough to comment on is, "How do I use OWB to move data between Salesforce.com and my Oracle database?" Data warehouse customers in particular seem to be running into this one.
Usually, the person asking expects that some kind of web service call will be the solution of choice. Perhaps it would be, in some arcane cases. There are also ODBC drivers for Salesforce.com, which OWB could connect to with similar results to other ODBC data sources. (Of course, Oracle support won't help with those third-party components.)
However, bulk data movement is the most common case, and there are tried and true ways of doing that without the latest SOA secret sauce.
The moving parts of the simple-enough solution are:
So ultimately this is no different from moving data back and forth using flat files with any other foreign system, something OWB users have no doubt done since time immemorial.
If you apply this technique in a real deployment, let us know and we'll spotlight you here on the blog.