Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

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

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
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