ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
The Alteryx Community will be temporarily unavailable for a few hours due to scheduled maintenance starting on Thursday, April 22nd at 5pm MST. Please plan accordingly.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Upgrading ODBC Drivers

Dan5
8 - Asteroid

Hi 

 

I am trying to make sure i get the best performance when connecting and downloading from an oracle database. I have installed Oracle Instant Client, and just upgraded to version 19_10. I thought this would result in a new driver version when running my workflows, however the messages indicate in am running ODBC Driver version 03.52, which i believe is the version i had before, when i was using Instant Client 12_2.

 

Is this a setup issue? Am i going about updating my driver wrong? 

 

It runs, just very slow in Alteryx. Much faster when i execute the same sql in sqldeveloper on the same machine. 

BrandonB
Alteryx
Alteryx

You may want to try an OCI connection rather than an ODBC connection when using an Oracle database. 

 

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-to-Connect-to-an-Oracle-Databas... 

Labels