Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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
Author

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
Author

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
Author

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
Partner - Contributor III
Partner - Contributor III

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 ?