Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

astarodubov
New Contributor

Performance of SAP Connector

Hello everybody!

We are trying to load data from SAP BW via OLAP Connector.

The average speed of our loading is about 30000 lines per minute.

We see the strange behaviour: SAP Connector use just only one Core.

The questions are:

1) is it normal speed of data load?

2) is it normal behaviour of using CPU?

3) can we make SAP Connector to use all avaliable cores? How?

We use SAP Connector 5.5, 2 CPU, 4 Cores, 16 GB RAM

Thanks!

1 Reply
suniljain
Honored Contributor

Performance of SAP Connector

I will suggest you that instead of exptecting cube through OLAP connector . pls extract fact and dimention table seperately,

and make cube in qlikview.

Your process become faster.