topic Re: Extraction SAP Connector in QlikView

Extraction SAP Connector

Mon, 26 Jan 2026 21:26:37 GMT

Good morning,

Is there any way to improve the connectivity of the SAP Connector? Improve desempeño of extraction?

Thanks

Re: Extraction SAP Connector

Tue, 25 Sep 2012 14:55:18 GMT

Hi!

Which kind of extraction do you use? And how long does it take?

Do you use a complex where clause? Have you considered tables indexes?

Regards,

Patrick

Re: Extraction SAP Connector

Tue, 25 Sep 2012 14:58:17 GMT

We are using only Extracotor to SAP, the client don't have the BW.

And we are extracting only tables.

And version is 5.7 and SAPBASIS 701.

Re: Extraction SAP Connector

Tue, 25 Sep 2012 15:10:07 GMT

Hi!

And which table are you extracting? With which WHERE clause?

And what do you consider as slow? 20000 rows per minute? 200000 rows per minute?

Regards,

Patrick

Re: Extraction SAP Connector

Tue, 25 Sep 2012 15:27:50 GMT

We are extraacting all tables which work with PMD (Modulo Health in SAP).

No are using the clause WHERE, we are extracting ALL rows.

And in one hour we can extract 1.265.000 rows, more or less.

Re: Extraction SAP Connector

mmichalke — Tue, 02 Apr 2013 11:16:27 GMT

What exactly are you looking for ? For example if loading time is taking to long you could consider reducing data volume by delta-loads using where-clauses. Is this what you are looking for ?