cancel
Showing results for 
Search instead for 
Did you mean: 

Push and pull

Former Member
0 Kudos
2,546

hi,

     can anyone please explain me about push and pull???

   plz guys plz explain me in a very detailed manner

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member186082
Active Contributor
0 Kudos

Hi Venkatesh,

When data is written directly to BW side, it is PUSH mechanism (Webservices)

When BW initiates a process to read from some external source, it is PULL mechanism (R3 Extraction)

Also have a look at this, will clear your doubt

http://scn.sap.com/thread/262127

http://scn.sap.com/thread/243252

Before posting a query, search once in SCN, you will find enough information

Then post for further clarifications/doubts

Regards

Chandu

Former Member
0 Kudos

In the ‘push’ mode, data are posted tointermediate tables or a delta queue by the applicationin the OLTP system without any initiation on the part of the BW system. The LO, FI-GL, FI-AP extractors use the ‘push’ concept. In the ‘pull’ mode, the BW systemtriggers the extraction from the OLTP system. For delta-enabled ‘pull’mode extractors, a delta queue or atimestamp (or any monotonously increasing numericvalue) approach provides the deltas. All genericextractors that do full loads use the pull mode.

confusion

former_member186082
Active Contributor
0 Kudos

In push mode, the application will take care of identifying the records for delta. The delta update reads these delta data records from the delta queue. The delta type supported is 'D', image will be AIM (After-Images Via Delta Queue)

In pull mode, the extractor provides the delta for the data source. The data source extractor determines the delta data records. The delta type supported is  'E', image will be AIE (After-Images Via Extractor)

Hence in push mode, the data will be posted to delta queue automatically by the application. Where as in pull, the extractor has the vital role in delta records

'D': The SAP application writes delta data records directly to the delta queue (“PUSH”) for the DataSource. Each data record is either a) stored in the delta queue individually on saving / updating the corresponding transactions in the application (for example, FI-AR/AP or direct delta in the LO Cockpit), or b) written in groups of delta data records (after updating the transaction) to the delta queue by means of application-specific jobs. In each case, however, the delta data records are in the delta queue for the SAP source system before the delta update is executed. In the case of a delta update for the DataSource, this delta queue is read and the data records that exist there are transferred to the BI system. This delta type is normally used in applications in which

delta data records cannot be determined through fields or control tables for

the underlying application tables.

'E': The DataSource determines the delta through the extractor on request. This means that the extractor must be capable of providing the delta records for the DataSource on request (“PULL”). The delta data records that have been determined are placed in the delta queue by the extractor and

transferred from the there to the requesting BI target system. If you have carried out delta initializations for more than one BI system, or several delta initializations for the same BI system, the extractor has to stage delta records for all the delta initializations and store them in all the delta queues that are specific to the BI target systems. This delta type is normally used in applications in which delta data records can be determined through fields or control tables for the underlying application tables (for example, time stamp information for each data record).

Go through TBW42_part 1,  page num 254, for more info.

Regards
Chandu

Former Member
0 Kudos

Hi Venkat,

Push & Pull are very basic terms w.r.t to data aquisition in SAP BI/BW.

Pull is when a process happens in BW and data is pulled inside BW.

Push is when a process happens outside BW and data is pushed to BW.

More detailed information has been provided in this document ::

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/20122919-0b7f-2e10-a08d-ea7def3ac...

Regards,

Arpit 

Former Member
0 Kudos

Hi Venkat,

Push and Pull are delta mechanisms with reference to BW.

If data is picked into BW only after a process is initiated in BW side, then it is called Pull Delta.

If data is pushed into BW by a process outside BW, then it is called Push Delta.

Regards,

Harish.

Former Member
0 Kudos

examples for pull delta is LO cockpit extraction and push delta is used when web services is used as source.

Hope it helps.

Regards,

Harish.