Alteryx to AmazonRedshift

[saiHareesh]

Hi Everyone,

I am Hareesh, I have started learning Alteryx from two day which an amazing tool.

I have a Amazon Red shift databases where i need to connect and work with the input file, but i am not able to do so,do i need drives in order to connect or is there any process? i have tried ODBC but failed and getting the below error.

If you have any solution please reply me and i appreciate for the help in advance.

 

Regards,
Hareesh

[AmeliaG · Accepted solution]

Hi Hareesh,

You will need to install the Amazon Redshift driver if you do not already have it on your computer. The recommended driver and the link to the download can be found here.

Here is a helpful community article which details how to connect to an ODBC source and here is a helpful article detailing how to debug a database connection. 

Hope this helps!

[saiHareesh]

Hi Amelia,

Thank you for the help i appreciate it. The drivers for the Red shift were installed on my computer, but they were not configured properly on the system.

Regards,
Hareesh