Data Extraction (Loading
data from OLTP servers to OLAP (BW/BI) servers)
OLTP server stores daily transactions data. For a bank all the transactions related to money debit/credit to any account, loan, employee related data etc will come under transactional data. They are used to support real time business. But for analysis purpose we do not need all data at each transaction level. For this purpose we load data from transactional servers to BW/BI Servers. We extract data/fields which are necessary for the analysis of the business and will help in taking business related decisions.
OLTP server stores daily transactions data. For a bank all the transactions related to money debit/credit to any account, loan, employee related data etc will come under transactional data. They are used to support real time business. But for analysis purpose we do not need all data at each transaction level. For this purpose we load data from transactional servers to BW/BI Servers. We extract data/fields which are necessary for the analysis of the business and will help in taking business related decisions.
You may load transactional data to BW/BI servers on daily
basis/weekly basis/monthly basis. Frequency of loading or refreshing the data
depend on the criticality of the decision taken based on that data. If any
decision which is very critical and can impact short term business decisions,
we need to refresh the data on daily basis.
Data Extraction Process
Basis of extraction is OLTP extraction tables. So R/3
OLTP source system must be replicated to BW. To replicate the Metadata from a
source system into BW for an application component, choose Source System
Tree->Required Source System->DataSource Overview ->The user
Application Components ->ContextMenu (right mouse click)->Replicate
DataSources in the BW Administrator Workbench.
To update all the Metadata of a source system-Choose
Source System Tree requires
Source System ->Context Menu (right mouse
click)->Replicate DataSources in the BW
Administrator Workbench
- Replicate the data source to BW server
- Go to transaction code RSA3-> Check data is available related to your Data Source.
- If yes-> Go to transaction code LBWG (Delete Setup data) -> Delete the data by entering the application name.
- Go to transaction SBIW --> Settings for Application Specific Data source --> Logistics --> Managing extract structures --> Initialization --> Filling the Setup table --> Application specific setup of statistical data --> perform setup (relevant application)
