Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP 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 (3)
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!