1 / 4

Extracting Data From SAP Source Systems

Require SQL Server Change Data Capture? BryteFlow guarantees availability and lightning-fast replication across several platforms. Our Change Data Capture can be simply set up without admin access or access to logs. BryteFlowu2019s SQL Serverlog-based technology allows continuousloading and merging changes in data without slowing down source systems. <br>

troyevans275
Download Presentation

Extracting Data From SAP Source Systems

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Extracting Data From SAP Source Systems  An integral and critical component of the data retrieval mechanisms in the source systems of SAP are Extractors that can be used to extract data from SAP. An Extractor can fill the structure of a Data Source with the data from the source system datasets of SAP. Replication is the process that is widely used to enable the Data Source and its relevant properties to be known in the SAP Business Warehouse (BW).

  2. To extract data from SAP and transfer it to the input layer of SAP Business Warehouse that is the Persistent Staging Area (PSA), the load process with an Info Package in the scheduler needs to be defined. When the Info Package is executed, the data load process is triggered by a request IDoc to the source system. The process chains should be used for executions. 

  3. Process to extract data from SAPThere are several application-specific extractors, which are hard-coded for the Data Source delivered with the BI Content of the Business Warehouse. These extractors fill the precise structure of the Data Source. Further, there are many generic extractors to extract data from SAP source system and transfer into BW. The extractor will know which data has to be extracted and which tables from where data has to be read only after the generic extractor names the Data Source. 

  4. It is also possible to generically extract data from SAP that includes master data attributes or texts, transaction data from all transparent tables, database views, or SAP query functional areas regardless of the application used. The Data Source data for these types are read generically and transferred to the BW. This is how to extract data from SAP through generic extractors.    

More Related