on 2012 Apr 11 10:09 AM
hi,
can anyone please explain me about push and pull???
plz guys plz explain me in a very detailed manner
Request clarification before answering.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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 ::
Regards,
Arpit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 12 | |
| 9 | |
| 6 | |
| 4 | |
| 4 | |
| 4 | |
| 3 | |
| 3 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.