topic SAP Connector slow extraction in QlikView

SAP Connector slow extraction

Tue, 12 Apr 2011 17:03:21 GMT

Hello everybody,

I'm facing an issue with the SAP Connector.

First of all, I installed the SAP Connector 5.5 but I couldn't get any row from the tables.

Then I installed SAP Connector 5.4 and then we could get the data but really really slowly.

We tried many combinations, Connector 5.4 with transports 5.5, Connector 5.4 with transports 5.4 but the extraction is still really slow.

When connecting directly to the database with an OLED connection, the extraction is really fast. Same thing when executing the queries directly in SAP with the same user.

The firewall and the antivirus are deactivated.

There is a SAP Router on the production environment but not on the quality environment and the problem is the same on both environments.

Any idea?

Regards

Kevin

SAP Connector slow extraction

suniljain — Wed, 13 Apr 2011 19:15:56 GMT

can you give me more details like which table you are extracting ?.

SAP Connector slow extraction

danielrozental — Wed, 13 Apr 2011 19:38:41 GMT

Kevin,

Extraction through SAP Netweaver connector is definitely going to be slower as it's not done directly through the database but through SAP Netweaver application server.

I've recently learned that there are some parameters in the connection string you can mess around with to improve performance, like packet and buffer size but you might also want to get in contact with someone from QT who might be more experienced in this.

Regards,

SAP Connector slow extraction

suniljain — Thu, 14 Apr 2011 12:01:23 GMT

Agree with daniel. you can improve extraction speed by connection string parameter.

SAP Connector slow extraction

Thu, 19 May 2011 13:18:48 GMT

Ok, we downgraded to QV Connector 3.5 and it worked.

SAP Connector slow extraction

danielrozental — Thu, 19 May 2011 19:09:42 GMT

You got a better performance by downgrading to Connecto 5.3? You should probably contact QlikTech support to let them know, maybe that's something they can improve for the next version.

SAP Connector slow extraction

Fri, 20 May 2011 07:34:51 GMT

Hi Kevin,

Out of curiosity, can you please tell which SAP Basis do you have and which transports are installed?

Thanks in advance

sravan

SAP Connector slow extraction

Fri, 20 May 2011 07:39:57 GMT

Hi,

We have informed Qliktech.

We installed the transports of version 5.3

Regards

Kevin

SAP Connector slow extraction

suniljain — Fri, 20 May 2011 11:34:33 GMT

Deae Kevin,

There are couple of reason behind slow data extraction from SAP R/3.

if you put any where condition during extraction it directly reflect extraction speed.

another thing is that most of SAP Details table have more than 150 column. In that case you have to extract only required column.

it will definitely increase extraction speed.

SAP Connector slow extraction

Fri, 20 May 2011 12:46:44 GMT

Well, we didn't change the script between connector 5.5 and 5.3. But yes, we are loading every column for each table.

The fact that we are on a virtual environment may have affect the speed.

We will wait for the reply of Qliktech and for the version 5.6 of the connector.

SAP Connector slow extraction

suniljain — Sun, 22 May 2011 10:43:28 GMT

In case of virtual environment you have to tranport file of Qlikview SAP Connector on Message Server and extract data through message server.

Because In virtual Environment Message Server play roles of Centralize server and perform all request response activity.

SAP Connector slow extraction

Wed, 15 Jun 2011 14:22:17 GMT

Hallo Kevin,

we have almost the same problem. We upgraded our connector from 5.2 to 5.5, installed the right transports. Otherwise we didn't change anything else. The extraction/reload from SAP is 30% slower. We asked QlikTech but they have no idea...

Do you have a solution meanwhile? Thanks!!!!

Regards

Alex

SAP Connector slow extraction

Wed, 15 Jun 2011 15:02:12 GMT

Hello Rotec,

As I said before, our solution was to downgrade to version 5.3.

I hope that Qliktech will find a solution asap.

I didn't read the doc but what are the difference between 5.5 and 5.3?

Regards

Kevin

SAP Connector slow extraction

suniljain — Fri, 17 Jun 2011 05:00:54 GMT

I alredy using QVC 5.5 SR3 . it have better performance than 5.3.

SAP Connector slow extraction

Fri, 17 Jun 2011 07:53:59 GMT

with virtual machines?

SAP Connector slow extraction

Thu, 21 Jul 2011 14:52:44 GMT

Kevin,

we're currently experiencing the same issue like you.

We just installed the 5.5 SR3 (onto a new virtual machine) and are doing some comparison with 5.3.

We went through a couple of BW queries and found a huge decreasing of performances.

The reason why we were thinking to move towards 5.5 SR3 was the limit of 1' million cells.

At the same time we checked on the SAP side and found out the note 1232751 (about the 1 million cells limit).

Anyway I am not sure whether this note specifically requires the 5.5 SR3 instead of 5.3.

We too are going to get Qliktech involved as well.

If we could manage more than 1' million cell even with 5.3 I do not see any valuable reason to move to 5.5SR3

SAP Connector slow extraction

Wed, 27 Jul 2011 10:20:51 GMT

Hi everybody,

Did anyone find a solution for this problem?

I am facing the exact same problem and had the same approach. Upgrade and downgrade versions of SAP Connector but without success (5.3, 5.4 and 5.5). Either it displays a terrible performance or it doesn't extract the data accurately.

SAP Connector slow extraction

Wed, 27 Jul 2011 10:32:36 GMT

Hi everybody,

Did anyone find a solution for this problem?

SAP Connector slow extraction

Tue, 20 Sep 2011 14:55:24 GMT

No solution for the moment.

No QlikTech members interested in my problem ?

Regards

Kevin

SAP Connector slow extraction

danielrozental — Tue, 20 Sep 2011 20:00:00 GMT

Kevin, have you got qliktech support involved?