1 Reply Latest reply: Jan 22, 2015 8:19 AM by Mats Olin RSS

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

    mallik holikatti

      I need to extract infoobject which is in multoprovider

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

          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)