you will need Oracle drivers installed on your development and production machines. I would look at the drivers from Attunity as they seem to run much faster than the Oracle ones - go figure

You will need to create ODBC connections in ODBC32 (in the Windows/System folder in 32bit architecture and in Windows/SysWOW in 64bit - even though Microsoft decided to keep the application name as ODBC32 - thanks for that :-P)

You should then be able to access the Oracle server through the ODBC connection.

Last time I did this I was pulling data from Progress on Linux to Oracle in the cloud via on-prem SQL server. Not pretty, but effective.

You might need to do some tuning of the ODBC connections for packet size and #records and you will almost certainly need to tune the throughput of the SSIS package