Accessing different databases simultaneously

How can I access two different databases (e.g sql server and oracle) simultaneously and update and move data between each other. For instance how would I move a table row from one database to another if the row does not exist in the first.