Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
pix
Partner - Contributor III
Partner - Contributor III

Benefits of SAP SQL Connector over HDBODBC driver

Hello,

Would you know, in short, what are be the benefits of SAP Connector over HDBODBC?

The main purpose would be a QV connection and data extraction from SAP S/4 Hana.

From what I have read, the main convenient is that the source tables are automatically exposed once a connection with SAP connector is established, in comparison to a HDBODBC driver, where tables are not always visible. It seems that the solution would be knowing table names upfront  in order to extract data. So does this mean that even if the tables are not visible in the ODBC wizard,  as long as I know what table name to target in the script, I can still extract any data I need with a driver connection?

Also, it seems that some measures would have to be aggregated in order to be extracted:

So far, I found this post: https://community.qlik.com/t5/QlikView-Connector-for-SAP/QlikView-ODBC-Connect-to-HANA/m-p/447797

Could you please share from your experience regarding QV SAP Connector (SQL) vs. HDBODBC driver?

Thank you,

Diana

Labels (1)
0 Replies