Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Aria
Contributor III
Contributor III

How to create a connection from SAP HANA to Qliksense through ODBC?

 
Labels (1)
1 Solution

Accepted Solutions
PadmaPriya
Support
Support

Hello @Aria 

 

1)First make sure that you have the ODBC 64-bit connection.

PadmaPriya_0-1622564103780.jpeg

 


1.1) If you just have the ODBC Data Source connection then download it from here: https://dev.mysql.com/downloads/connector/odbc/

2) In the webpage (https://blogs.sap.com/2015/08/04/sap-hana-and-qlik-viewsense/) it shows the "OLE DB" connection instead of the ODBC one. Since you made the ODBC USER DSN connection, you should use ODBC instead of OLE DB.
After you've chosen the USER DSN, try to find the connection you created and fill in the missing parameters.

PadmaPriya_1-1622564102830.jpeg

 

Thanks,

Padma Priya

Help users find answers! Don't forget to mark a solution that worked for you! If already marked, give it a thumbs up!

View solution in original post

1 Reply
PadmaPriya
Support
Support

Hello @Aria 

 

1)First make sure that you have the ODBC 64-bit connection.

PadmaPriya_0-1622564103780.jpeg

 


1.1) If you just have the ODBC Data Source connection then download it from here: https://dev.mysql.com/downloads/connector/odbc/

2) In the webpage (https://blogs.sap.com/2015/08/04/sap-hana-and-qlik-viewsense/) it shows the "OLE DB" connection instead of the ODBC one. Since you made the ODBC USER DSN connection, you should use ODBC instead of OLE DB.
After you've chosen the USER DSN, try to find the connection you created and fill in the missing parameters.

PadmaPriya_1-1622564102830.jpeg

 

Thanks,

Padma Priya

Help users find answers! Don't forget to mark a solution that worked for you! If already marked, give it a thumbs up!