topic Re: Not able to extract data from sap in QlikView

Not able to extract data from sap

manu1512 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Not able to extract data from sap

Peter_Cammaert — Mon, 06 Nov 2017 14:12:17 GMT

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?

Re: Not able to extract data from sap

manu1512 — Tue, 07 Nov 2017 12:42:18 GMT

Hi peter ,

I am trying to extract data directly from SAP

Re: Not able to extract data from sap

Peter_Cammaert — Tue, 07 Nov 2017 12:45:44 GMT

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.

Re: Not able to extract data from sap

manu1512 — Tue, 07 Nov 2017 12:48:34 GMT

Hi Peter,

I am using SAP EXTRACTOR to extract data

Re: Not able to extract data from sap

Peter_Cammaert — Tue, 07 Nov 2017 13:06:14 GMT

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?