How to connect data through ( BigData-Impala) database to Alteryx Designer

Question

Hi Team,

I am using Alteryx designer (2020.1 X64).

My Requirement: I need to connect data through ( BigData-Impala) database to Alteryx Designer and the output will be excel & Tableau ( .tde) File (both or anyone).

Need your help to understand:

1) How can i connect "Bigdata-Impala" with Alteryx designer?

1a) What kind of drivers/setup required to installed ?
1b) Will this will be ODBC/JDBC connection ?
1c) What is the benifit of connecting Bigdata-Impala with Alteryx designer?
1d) What is the drawback of connecting Bigdata-Impala with Alteryx designer?
1e) Will this configuration ( Impala-Alteryx) impacted the performance /processing speed?
1f) Will my end data output excel/.tde gets impacted?

Sorry i asked do many questions , but really need help to resolved this issue asap.

Please add if i missed any point/observation that is need to be consider before implementing end to end process.

Also i follow few links ( searched in google) , but could not able to finalized outcome yet.

It will be really helpful if someone provides me step by step guidance.

Thanks & Regards
Piyush Jain

PiyushJain · Answer

Hi Team Alteryx,

Request you to please provide few more information.

Regards

Piyush Jain

PiyushJain · Answer

Hi Emil,

Thanks for your reply. I followed the link & found relevant information. But still i need more information regarding end to end flow..

Once again thanks for your help!!

Regards

Piyush Jain

Emil_Kos · Answer

Hi,

I think you can find a required driver under this link:

https://help.alteryx.com/current/designer/apache-impala

This article might be helpful for you as well:

https://community.alteryx.com/t5/Engine-Works/Tackle-your-Big-Data-Use-Cases-with-Alteryx-in-Database/ba-p/4527

Unfortunately I cannot help you more as this isn't my area of expertise. Good Luck!