Qlik Community

Qlik Connectors Discussions

Discussion Board for collaboration regarding Qlik Connectors.

Highlighted
andy
Not applicable

How to fetch data from SAP BW

Hi,

For me the SAP products and the connectors are somewhat a djungle therefore this question.

I'm using the SAP SQL connector to fetch data from a SAP-database. I've tried the Extractor connector as well and it works.

Now I'm wondering what it takes to fetch data from the SAP BW as well.

Which connector to use and what is the effort to get it working and maintain it?

 

Labels (1)
1 Solution

Accepted Solutions
andy
Not applicable

Re: How to fetch data from SAP BW

Well,

I did some more research and ended up in three alternatives to fetch data from SAP BW.

1. BeX-connector. If some BeX-queries already have been developed in SAP they can be reused by Qlik to preserve the logic. If no BeX-queries exists there is most certain nothing to gain from Qlik's perspective to develop new BeX-queries since the process to change the logic with SAP consultants and SAP dev->test->prod will be much more time consuming than changing a Qlik-script. BeX also does not work very well with large amounts of data.

2. Infoprovider. Better than the BeX-connector since it doesn't seem to need SAP-development. It can also read multiproviders (several connected cubes in BW)

3. Extractor-connector. This one can read data incremental. It can be used after you in BW right-click on your source and select "Generate datasource".  Obviously this includes some small amounts of work from SAP-people so the Infoprovider might be the easiest to start with. https://help.qlik.com/en-US/connectors/Subsystems/SAP_Connectors_Help/Content/Connectors_SAP/Configu...

Regards

4 Replies
PrashantSangle
Not applicable

Re: How to fetch data from SAP BW

use sap bex connector

Regards,
Prashant Sangle
Great dreamer's dreams never fulfilled, they are always transcended.
hrg
Not applicable

Re: How to fetch data from SAP BW

Jay_Brown
Not applicable

Re: How to fetch data from SAP BW

Hello @andy , you have received a couple of responses on this which I think could have solved your issue.

If one of the responses provided the information you needed, please mark this as solved.  Thanks!

To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.
andy
Not applicable

Re: How to fetch data from SAP BW

Well,

I did some more research and ended up in three alternatives to fetch data from SAP BW.

1. BeX-connector. If some BeX-queries already have been developed in SAP they can be reused by Qlik to preserve the logic. If no BeX-queries exists there is most certain nothing to gain from Qlik's perspective to develop new BeX-queries since the process to change the logic with SAP consultants and SAP dev->test->prod will be much more time consuming than changing a Qlik-script. BeX also does not work very well with large amounts of data.

2. Infoprovider. Better than the BeX-connector since it doesn't seem to need SAP-development. It can also read multiproviders (several connected cubes in BW)

3. Extractor-connector. This one can read data incremental. It can be used after you in BW right-click on your source and select "Generate datasource".  Obviously this includes some small amounts of work from SAP-people so the Infoprovider might be the easiest to start with. https://help.qlik.com/en-US/connectors/Subsystems/SAP_Connectors_Help/Content/Connectors_SAP/Configu...

Regards