Alteryx WF Oracle DB performance issue

[Manikumarayyachamy]

Hi,I have try to read the 20+ Million rows from Oracle Database and the Alteryx WF which running this SQL taking more than hour to finish it. When run the same SQL from Toad/Sql Developer its completed within 1 mins. Could you please suggest how can i improve the Alteryx WF performance when read the huge data from Oracle DB. 

For Data connection i have tried with Oracle OCI , ODBC & OLEDB , but none of them fixed the issue.

[Luke_C]

Hi @Manikumarayyachamy 

Have you tried the Simba Oracle ODBC driver? Check out the solution to the below post for more details

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Oracle-Database-read-speed-too-slow/td...