The attunity connector in SSIS is probably one of the fastest methods of getting data out of Oracle – knocks spots off using linked servers. However, make sure you use VS2017 version of SSDT otherwise you will waste a lot of time thinking the oracle configuration is wrong.

BlockSize is important – the default fetches 100 rows at a time and on a 90 Gb table in Oracle changing this to a fetch size of 2500 can knock a lot of time off the extract time

Make sure that Oracle works before doing any tests and make sure you have the 32 bit drivers for development.

And finally don’t forget to keep a copy of the package in git or your preferred source control.