Qlik Community

QlikView Connectors

Not applicable

Extraction SAP Connector

Good morning,

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

Thanks

5 Replies
Not applicable

Re: Extraction SAP Connector

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

Not applicable

Re: Extraction SAP Connector

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.

Not applicable

Re: Extraction SAP Connector

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

Not applicable

Re: Extraction SAP Connector

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.

mmichalke
New Contributor II

Re: Extraction SAP Connector

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 ?

Community Browser