Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2017-03-12 07:28 PM

SAP Connector - extract times 4-5 fold

We've been working on SAP Connector 6.0.124 into ECC 721 release for some time (12 months) and all of a sudden we're finding our extracts varying 12 fold (from 40 minutes to nearly 5 hours). We've all but eliminated SAP, server or network issues but are perplexed. Has anyone had any problems with this version of connector.

389 Views
0 Likes
2 Replies
Hakan_Ronningberg
Employee
Employee
‎2017-03-16 04:54 AM

Hi,

There was a performance degrade for the SQL connector which was discovered in release 6.1 IR and fixed in release 6.1.1.

In release 6.1.2 there was a significant performance improvement for the SQL connector. We noticed up to 30 % better performance when extracting from some SAP tables!

If possible, I suggest that you upgrade to the latest released version 6.3.2. In the near future release 6.4.0 will also be available.

Regards,

Hakan

216 Views
0 Likes
Not applicable
‎2017-03-20 08:18 PM
Author

In response to Hakan_Ronningberg

Thanks Hakan - I think this will be the steps I need to take. Whilst I'm sure it will improve performance it might not resolve the initial cause of the problem of 5 +fold increase in extract time. I'm assuming coming from 6.0.xx,  I'll have to also redeploy SAP transports to support the 6.3.2 connector.

Cheers

John

216 Views