Is there any way to improve the connectivity of the SAP Connector? Improve desempeño of extraction?
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?
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.
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?
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.
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 ?