Bw Training - 4 Extraction

Data Extraction

1

OLTP Extraction

• Production Data Extractors • DataSource Replication • R/3 Extraction Process • Non-R/3 Extraction Process • Scheduling • Monitoring

2

R/3 Production Data Extractor • Supports multiple R/3 releases beginning with 3.0D. • Integration to DataSources provided by SAP OLTP system. • Data transferred using either IDOCs or TRFCs to carry the data.

3

DataSource Replication for R/3 OLTP BW Server

Transfer Structure

DataSource Replication Transfer Structure Extract Structure

R/3 OLTP 4

Extraction from R/3 OLTP • InfoSources • Transaction data Meta data

Data Extractor

• Master Data Descriptions • Attributes • Hierarchies

HR

CO

FI R/3 OLTP

LO

EC

• Currency conversion rates • Full update / Delta update

5

Update Process BW Server Master Data Hierarchies Texts

Aggregates, ODS’ and InfoCubes

Update Rules

Info Sources

UR1

UR2

Sales data

UR3

HR admin

Customer

• Update process serves • ODS Objects • InfoCubes • Master data • Update Rules • Field to field • Currency conversion • Time conversion • Grouping • Fixed values • Formulas • Conditions ...

6

Non-R/3 Data Sources • Third party data extraction and load tools • Third party tool represents Source System with multiple InfoSources • Meta data exchange through BAPI • Consistent update through BW transformation and update rules • File interface • Mapping based on meta data • Fixed and variable record length • CSV-format (i.e. Excel)

7

External Data ‘Extraction’ – Remote Cubes

8

SAP BW Remote Cube • Replace reporting tools in OLTP systems wherever possible • Uniform and modern user interface • Cross application reporting

• Real-time access to transaction data in the operative system(s) • Direct access versus replication

• Reuse of the existing BW infrastructure • Extractors • Service API • BW meta data model • Transfer rules 9

Limitations • Only for transaction data • Suitable only for small volumes of data • Few end users • Additional requirements for the extractors • Selective for the most important characteristics • Pre-aggregation (if appropriate)

• No Inversion of Customer Exits (in SAPI) • Available from OLTP-Release 4.0B on

10