Using the power of SAP HANA

[Sabrina_dup_279]

Hi Community,

i want to use data from a HANA database (connected to Alteryx via ODBC) - where are the different steps in Alteryx processed? Is the power of the in-memory technology of HANA used?

Thanks!

Best,

Sabrina

[AndrewL · Accepted solution]

Hi Sabrina,

Great question! The short answer is not really, the longer answer is sort of. Within the Input Data tool you can create custom SQL queries using the SQL editor and in there you can do joins and whatever else you need to do. Those queries are executed within the database itself without bringing anything into Alteryx so the processing of those queries is generally faster.

The general recommendation is to only bring in to Alteryx what you need to in order to optimize the processing time. Once the records pass into Alteryx through the Input Data tool, everything is done within Alteryx using the in-memory processing that is leveraged as much as possible.