The best practice is to use a new empty folder you created for Alteryx to install the driver to : Select a directory to install the client to.Ī window will appear prompting you to select a directory to install the client.
If Oracle client is not found or it is incomplete, it prompts to install the instant client from Oracle website.Ĭ. Check for Instant Client in User Settings. If it cannot find tnsnames.ora file, it assumes client install is incomplete and prompts to install the instant client from Oracle website. Check the Oracle home directory for the existence of tnsnames.ora file (Note: it does not check for the content of the file and it does not use the file, it just checks for existence.). Check PATH variable for Oracle client path. Add an Input tool to the canvas, and select Data Sources from the drop-down menu in the configuration window then select Oracle Quick connectĪlteryx Designer checks for the client as follows: Open a new workflow in Alteryx Designer.ī. Connection Type: Quick Connect Procedure: If you have NEVER connected to Oracle beforeĪ. Oracle Instant Client Driver or an internet connection (if you have never connected to Oracle before)ġ. 
Note: All screenshots included in this article are for Designer version 2019.2 or later. This article details different methods for connecting to an Oracle database from Alteryx.
#DOWNLOAD ORACLE DATABASE CLIENT HOW TO#
How to Connect to an Oracle Database in Alteryx
0 kommentar(er)
