Best way to leverage SAP HANA’s in-memory performance in Alteryx Designer

[britanneywiley]

I’m working with SAP HANA data in Alteryx Designer using an ODBC connection, and I’m trying to understand how much of HANA’s in-memory power is actually being used during processing. When I pull data into Alteryx and apply transformations, does the computation still happen inside HANA, or does it move to Alteryx once the data is loaded? Also, what’s the best approach to make sure I’m pushing as much logic as possible down to HANA, for example, through In-Database tools or optimized SQL queries?

Best,

britanneywiley

[dreldrel]

After you pull data into Alteryx, the computation moves to Alteryx. Unless you use the In-Database tool to perform data transformation, this will process computation on SAP HANA. If your data size is massive, I'd suggest using the In-Database tool for your main transformation before pulling into Alteryx, so you can leverage the power of SAP HANA. Hope this helps