SAP BW Connector vs SAP ERP Connector

[#1]

I've been told that it's better to connect QV directly to the ERP vs to the BW. Does anyone have a document specifying these reasons? Thanks,

[sicilianif]

Are you looking at using the OLAP connector for BW? If so, I would recommend that you use the DSO or SAP connector instead and get the data from the underlying tables.

We initially were using the OLAP connector, but switched after having many issues and talking to support.

[#3]

Thanks for your response.

Could you explain what issues you were having?

[sicilianif]

We were experiencing extremely long load times using the OLAP connector. Apparently it has something to do with the method that SAP uses to pass back the data. Also, there were limitations with the amount of data you could pull.

For example, we were pulling inventory trend data. To pull data for a month, it was taking 45 minutes to get the data. When we checked the performance in BW, we could see that the query itself was running within minutes. All of the extra time was being consumed for returning the data to QlikView.

We have since switched to using underlying DSOs and tables and have been very happy.

[#5]

hi SiciliaNif

Since I'm building a presentation to show the pros/cons of both connectors, is it OK if I quote you and mention the company you work for?}

Thanks,

[#6]

Hi,

I'm very new to Qlikview, and need help on qlikview from the experts. Could you please help me out in designing DSO/Cube on Qlikview. Appreciate if you could send any document.

I'm using SAP Connector.

thanks, Ravi

[suniljain]

SAP BW Connector vs SAP ERP Connector

1) SAP BW Connector is Extraction of - SAP ERP Connector is for extraction of data from Cube,DSO From table or view of SAP R/3

2) Extraction from SAP BW is faster than - Extraction from SAP R/3 is slow compare to B/W

SAP R/3 because data is processed and indexed - because some sap table are not indexed like

and on Indexed data select query working very fast - KONV,MSEG

3) Extraction from SAP B/W does not affect ERP - SAP R/3 Extraction affect ERP Operation or Operation - performance.

4) SAP BW almost solve incremental load problem - Still Some SAP R/3 Table donot have any

- timestamp in table

[suniljain]

Dear Ravi,

Can I know what is your exact requirement in qlikview ? whether you want to extract cube or anytihng else ?

Regards

Sunil Jain

[#9]

Hello Juan,

I have already said this in another thread: "http://community.qlik.com/message/108266#108266"

...

what you should use depends on your experience and your SAP knowledge. If you have no SAP BW system and you only want to use SAP BW I would say - Do not install SAP BW only for QlikView. You should also be carefull from the legal point of view because SAP has the possibility to debit you with a OpenHub license - I think but I'm not sure. It is not so clear.

If you have no SAP BW I would suggest:

     - Do not introduce SAP BW only to get the data for QlikView. If you want to use the SAP Service API (SAP

     BW datasource extractors) which is very powerful I suggest you will look around for a 3rd party connector. I

     made good experience with the Theobald connector. It also supports the connection to the SAP Service API      without the introduction of SAP BW and I think all other possiblities of the QV SAP connector.

     - Use the QV SAP connector to extract the SAP tables, reports, ...

If you have an SAP BW system I will suggest to collect the data from the SAP BW system because it will have no performance impact on your SAP ERP system. And your SAP ERP system is much more important than the SAP BW because you will do your operational business with your SAP ERP and the reporting with SAP BW.

     - Use an extractor what you want that supports the extraction of the SAP BW system.

Hopefully it helps you a little bit to find a good solution for your tasks.

Best regards!