You're gonna have to do a lot more googling Sparky, do you need to set up linked servers to Ora and MySQL from SQL Server, do you know how to do this ?, how about using OpenRowset ? Do you have Server Names, table names, accounts, schemas, etc.
It's a lot more complex than simply getting data via T-SQL from Oracle and MySQL, sorry to burst your bubble.
I too thought abt Linked server . but my boss is not in favor of using any kind of provider (where in for linked server we need providers like odbc to talk with other database)
he wants the connection also to be established via t-sql upon which the extract query used in the t-sql should extract relevant data from the DB