Oracle Client Error Connection

Question

Hello, I try to connect to an Oracle client database to extract data from but I keep getting an error that it cannot find my oracle client. I tried setting my path as such below and I still get the error it cannot find it. - The wierd thing is in the user settings when I set the user path and try to install again it removes the user settings file path. "C:Users\\AppData\Roaming\Alteryx\Engine\\UserSettings.xml There you need to look for the following line and put your oracle client path: C:\ProgramData\instantclient_12_1\" end result is I would like to connect to an Oracle DB using quick connect without having to remove and reinstall everything.

fmvizcaino · Answer

Hey @Jafar ,

Take a look on this tutorial. https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-to-Connect-to-an-Oracle-Database-in-Alteryx/ta-p/561574

The option D says to:

Note: The install directory will be saved with the user settings and will only be visible to the user who installed the client. If you are installing this on a server or as an admin for another user on the machine, you should download the client directly from Oracle  ( Instant Client Downloads for Microsoft Windows (x64) 64-bit  ) and follow the installation instructions provided by them at the bottom of the page.

Best regards,

Fernando Vizcaino

Jafar · Answer

@fmvizcaino 
I have tried every possible way.
Even change the user settings.
Still, I am unable to download.
I have checked with the IT team they have given all access to the folder.

fmvizcaino · Answer

Hey @AntlRo ,

Please go to the quick connect option on the input tool and select a new and blank folder for the oracle client to be downloaded.

Let me know if this works. If not, we can go ahead with a different process.

Best,

Fernando Vizcaino