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?