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.
on 04-14-2016 03:04 PM - edited on 04-24-2020 11:16 AM by kcsrestapiuser
How To: Connect to an ODBC Data Source
Alteryx can connect to databases using different methods. This guide will focus on setting up an ODBC connection to SQL server, however, the same general process can be followed to connect to any database via ODBC.
Prerequisites
ODBC driver for the database (if it is not currently present on your machine, you must download and install it prior to using this guide. The download links to many of the drivers can be found here. If you are unsure of where to get the driver or which driver to use please contact your IT or database admin for this information).
Procedure
2019.2 and later
Before 2019.2
All Versions
Additional Resources
Hello Team,
Can you provide me a details on how we connect ODBC to Oracle.
The Example provide is of Microsoft SQL Server.
I want to connect to ODBC with Oracle (64 Bit)
Thanks in Advance.
I am having many issues connecting to ODBC data sources.
Any advice?
I am not getting ODBC 64 bit driver.
Well explained.
64 bit driver is a different file download. Originally I was trying to use the 32 bit and had to go back.
Hi, I am a new user with Alteryx and needed some advice on connecting to Hive tables is Hadoop.
it would be great if I could get some information on how do I start, thanks
@olimpio
Your go-to resources on how to connect to databases is this list of Data Sources and the help for Input Data tool. Many of the Data Sources have articles in Community, and Hadoop is no exception. If you're new to Alteryx this article on how to search Community might be helpful to you.
Hello,
Im trying to connect with mysql and was able to download and install odbc driver for mysql and created odbc data source successfully.
In alteryx also i was able to use Input Tool to connect using the above odbc data source and get the list of tables in "Visual Query Builder", but when i switched to "SQL Editor" to test the query it giving below error "No Columns Returned" although there are data in the table.
did anyone got this issue ? help requested.
Thank you,
Danish