Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
manu1512
Creator
Creator

Not able to extract data from sap

Hi all,

When ever i am trying to extract data from Sap cubes , i am getting this error.??

Can any pls help?

ODBC connection failed

SQL EXTRACTOR 8D0WBS_ELEM

TFRMETHOD T  

UPDMODE F  

EXTRLANGUAGE E  

LOGSYS QTQVCEXTR

Advance Thanks

Manu

5 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

Lots of details that can help us answer your question are missing. "SAP" is an extremely complex product and there are quite a few different ways for Qlik software to extract data from SAP.

Are you trying to read directly from the database underneath SAP? From SAP HANA? From SAP directly?

manu1512
Creator
Creator
Author

Hi peter ,

I am trying to extract data directly from SAP

Peter_Cammaert
Partner - Champion III
Partner - Champion III

IMHO if you're not reading from SAP HANA, you cannot do this using an ODBC connection. You'll need a SAP Connector to talk to the SAP API level.

manu1512
Creator
Creator
Author

Hi Peter,

I am using SAP EXTRACTOR to extract data

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Your error message says: "ODBC connection failed"


That doesn't look like a SAP Connector message to me...


What does your connection string look like?