This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am want to do a simple input from an Oracle database. Dont' need to write; don't need in-database function; just want to pull some data from a few tables; join them up, do a bit preparation, and then write the output to local SQL Server DB.
Using tableau, I can download an oracle driver msi file, install, and 1 minute later, I'm connecting to Oracel datbase tables - all good.
For Alteryx, after about an hour of research downloads, installs - i'm still no closer to connecting, and i'm about to give up, and just use Tableau.
My reaserach (including help in this community) tells me that I can't just install an ODBC driver, but I have to install an oracle instant client, and then an instant client package ODBC; and then set-up an ODBC connection in ODBC tool.
Ok - so I download the instant client (after I had to create an Oracle account). I open up the 54MB zip file - only to find no setup.exe or anything resembling that.
Then I'm directed to the oracle instant client install instructions - which is an 88 page document (i'm not kidding); which deep on page 35 tells me that I have to set window path environment variables; and that I have to download another package - Oracle Univesal Installer and run comand lines to install the client.
This just got too rediculous, so hard compared to all of the other datasources I've ever connected to.. I give up.
Does anyone have a simpler way to connect Alteryx to an oracle database?
This video really helped me, https://www.youtube.com/watch?v=cZDDI9HFBIU. It is a short video with clear instructions. All you need to do is follow the video and request the tns entry from your system administrator (i.e. configuring the tnsnames.ora file). Then you can connect using the input tool via the "New ODBC Connection...". Done!