Qlik Community

QlikView Connectors

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
mallikarjun_h
New Contributor III

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

I need to extract infoobject which is in multoprovider

1 Reply
aoi
Contributor

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

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)

Community Browser