8 Replies Latest reply: Jan 29, 2015 5:38 AM by Steffen Lange RSS

    SAP Extractor Connector - DSO delta enablement?

    Steffen Lange

      Hi all

       

      Can somebody confirm to me that the SAP Extractor Connector has the capability to extract data from SAP BW DSOs and automatically receiving the delta calculated by the DSO (after one-off initialization of course..).

       

      Thanks in advance!
      causeneffect

        • Re: SAP Extractor Connector - DSO delta enablement?
          Tomas Sommergyll

          Yes, the Qv SAP Extractor Connector can get data from SAP BW DSOs and use Delta loads.

           

          Below is an excerpt from the text in the QV Connector Manual:

           

          9.2.5 Delta Loads

          One of the major advantages of the extractor connector is the ability to use delta load capabilities (if allowable in the extractor itself).

           

          To execute a delta load, proceed as follows:

           

          1. Uncomment the required UPMODE statement in the script:

          UPMODE C – initial extraction followed by delta load

          This creates a QVD file with all of the data through the extractor and also tells SAP that a delta load process is required in the future.

           

          2. Modify the extractor script:

          UPMODE D – delta extraction

           

          3. Concatenate the QVD to the output.

           

          (Note: When using the delta loads use the same template and the same logical system used for the initialization.)

           

          4. To do a new initial extraction (UPMODE C) on an existing initial extraction load, delete the data source in this transaction (/N/QTQVC/DELETE_INIT) before the new load starts. Fill in the logical system and then the data source/extractor to delete.

           

          (See the Manual for more details, if necessary)

           

          /Tomas

            • Re: SAP Extractor Connector - DSO delta enablement?
              Steffen Lange

              Hi Tomas

               

              Thanks for your quick reply!

               

              My interpretation was that the section "Delta Load" from the QV SAP Connector Manual only refers to the extraction from SAP data source (extractors) directly, that are delta enabled.

              I still believe it is only referring to the extractor, see below quote from your extract:

               

              "One of the major advantages of the extractor connector is the ability to use delta load capabilities (if allowable in the extractor itself)"

               

              I am specifically looking into connecting to SAP BW DSOs by using the extractor connector and use the DSOs delta handling. Is that possible as well and if yes, how? I have not found anything in the SAP connector manual.

               

              Thanks

              Steffen

            • Re: SAP Extractor Connector - DSO delta enablement?
              Clive Rouse

              Hi Steffen,  Yes the extractor connector is connecting to the BI datasource and not the DSO.  To get the delta from the DSO you need to extract the DSO active table.  This is the resulting data after the delta has been applied.

                • Re: SAP Extractor Connector - DSO delta enablement?
                  Steffen Lange

                  Hi wp_analytics

                   

                  That way I would always do a full load from the DSO to QlikView.

                   

                  What I am looking for is an efficient way to only transfer the delta from the DSO (which is calculated by the DSO anyway due to its three-table concept) to QlikView.

                   

                  We can't use the extractor connector because we want to leverage business logic in SAP BW which is already implemented on the data flow up to the DSO (integration of multiple data sources and DSOs for complex calculations).

                   

                  Currently the only way we see is to write a timestamp to the updated DSO data and transfer the delta from BW to QlikView based on the timestamp. But I am sure there is a more automated and efficient way already built-in to the SAP connector. Or am I wrong?