Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
mallikarjun_h
Partner - Creator
Partner - Creator

Which connector should be used to extract master data from SAP to qlikView?

I need to extract infoobject which is in multoprovider

1 Reply
mats_olin
Employee
Employee

You have a couple ofdifferent options:

Extarctor connector:

Right click on the IO and select 'Generate Export Data Source'. Then go to /n/QTQVC/Activate and make it available for QV. Or if applicable, from the MP go to the underlying data object (ex DSO or Cube) and select only the IO you want in /n/QTQVC/Activate but that will only give you the values that you have in that data object and for master data that is probably not what you want.

SAP SQL connector:

Extract the P table of the IO.

OLAP Connector: Build a query that extracts the data you want and then extract the query result via the OLAP connector

I would probably use the first option (Generate Export Data Source)