We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
fireworks

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. 

1 REPLY 1
bbak91
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
Top Solution Authors