Inspire EMEA 2022 On-Demand is live! Watch now, and be sure to save the date for Inspire 2023 in Las Vegas next May.

Alteryx Designer Discussions

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

SAP HANA connections to alteryx

harsha384
8 - Asteroid

Hi All,

Can you guide me how to connect to SAP HANA database(SP.11)? What all pre-requisite are required for driver setup?

7 REPLIES 7
JCR
Alteryx Alumni (Retired)

You need to setup the SAP HANA ODBC driver which is obtained directly from SAP.

Then define a DSN in the ODBC Administrator

Use this connection within Alteryx

 

Thanks

JC
 

harsha384
8 - Asteroid

Hi,

Thanks for your reply.i was able to connect to SAP HANA successfully earlier. One more issue i came across is that while loading tables into SAP HANA throught alteryx flow, the data was stored in row storage in HANA while my data in redhsift is already in columnar form.What can be the issue behind it? and how can it be resolved?

veeruj
5 - Atom

 Hi Harsha/All,

 

Can you please let me know how to search for the HANA client ODBC driver to connect to alteryx in market place ?

 

 

Thanks,
Veeru

harsha384
8 - Asteroid

Hi @veeruj,

 

When you install SAP HANA package on your system, the driver gets installed with it.

 

Check ODBC driver on your system.

 

You can find out details in below link-

 

https://help.sap.com/viewer/52715f71adba4aaeb480d946c742d1f6/2.0.00/en-US/66a4169b84b2466892e1af9781...

 

Thanks

harsh

MiniP
5 - Atom

How do we get SAP HANA ODBC driver directly from SAP? I need to connect SAP to Alteryx so I can pull report from SAP to Alteryx? Thanks in advance! 

gururajb
6 - Meteoroid

Hi

 

Can we bulk insert the data into SAP HANA like we have SQL server Bulk?

 

dandrews98
5 - Atom

Hi, were you able to find a solution to this? If so, would you mind sharing?

Labels