Forum Discussion
MichaelT_QIC
5 years agoFrequent Visitor
Performance tuning Oracle ODAC driver with FetchSize option on OnPremises Data Gateway
Hello everyone, We are using the Oracle ODAC 64bit driver in conjunction with the Microsoft OnPremises Data Gateway solution for retrieving data from a "on prem" Oracle database and populating o...
MallikarjunaBan
3 years agoHelper III
Hi MichaelT_QIC will this work for oracle odac version 12 i am troubled now need to pull 32million records
MichaelT_QIC
3 years agoFrequent Visitor
Hi MallikarjunaBan the Oracle database we are connecting to now is version 19c and I'm not sure when the DB was upgrade to that version, so not sure I can guarantee it would work with version 12.
We are also in the process of upgrading to the latest Oracle-Client-for-Microsoft-Tools.exe as part of an environment uplift to latest versions.