Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

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

britanneywiley
5 - Atom

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

1 REPLY 1
dreldrel
9 - Comet

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

Labels
Top Solution Authors