topic Re: Extract Data from Multi provider in QlikView

Extract Data from Multi provider

karthickv — Mon, 26 Jan 2026 21:26:37 GMT

Hi All,

We might have to extract data from SAP system. I have below 2 queries and kindly help by responding to those queries.

1) Can you suggest which connector can be used to extract data from Multi provider.

2) Are there any limitations of using BEx connector ?

Thanks,

Karthick V.

Re: Extract Data from Multi provider

mats_olin — Fri, 03 Mar 2017 14:02:18 GMT

You can either create extractors for the InfoProviders that makes up the MultiProvider (create a data source on the DSO, Cube or InfoObject and then activate the extractor for those data sources), or you can connect to BEx queries built on the MultiProvider.

The BEx connector has limitations, most of them are listed in the manual: Using the SAP BEx Connector ‒ Qlik Connectors

The biggest issue will probably be memory consumption. BEx queries are not originally made for mass data extraction and executing big set of data could case your SAP BW system to run out of memory. The solution is to either increase the memory in SAP BW or make smaller extractions. Best way to find out is to test.

The other limitations in short are:

No hierarchical data

No collapsed key figure structures

No customer exit variables (some will work though)

Max number of dimensions is 49

Structures must be selected for extraction

No hidden Key Figures

No hierarchy version variables

/ Mats

Re: Extract Data from Multi provider

karthickv — Fri, 03 Mar 2017 14:32:50 GMT

Many thanks for your response, Mats olin.

From your experience, Can you suggest which Connector can be best utilised (question 1)?

Thanks,

Karthick V.

Re: Extract Data from Multi provider

mats_olin — Mon, 06 Mar 2017 07:57:33 GMT

For big data volumes we recommend the Extractor or the SQL connector. But non of them can connect to a MultiProvider so you have to target the underlying objects. Extarctor has support for Delta and connects to datasources in SAP. SQL targets individual tables.

If connecting to a MultiProvider is an absolute requirement, the BEx connector is your only option for now.

/ Mats

Re: Extract Data from Multi provider

mats_olin — Thu, 09 Mar 2017 08:43:48 GMT

Also, you now have the option to use the InfoProvider connector that was released as a BETA version yesterday. It will be able to connect to MultiProviders and will have a functionality similar to transaction LISTCUBE in SAP BW. The BETA requires you to install new SAP transports. You can find the files here: https://community.qlik.com/community/qlik_product_insight/qlik-sap-connector-v64-technical-preview

Re: Extract Data from Multi provider

Thu, 09 Mar 2017 10:11:01 GMT

C1-INTERNAL

Re: Extract Data from Multi provider

karthickv — Thu, 09 Mar 2017 13:03:21 GMT

Many thanks Mats Olin ! It really helps.