community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

SAP HANA connections to alteryx

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?

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
 

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?

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

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

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! 

Alteryx Partner

Hi

 

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

 

Labels