Data Loading to BW From ECC using ODP – SAP HANA Information Views
ECC on HANA is Source system and BW on HANA is Target system.
Analytic View (ms/ANV) is in Source ECC on HANA system.
Requirement is this Analytic view output data has to be loaded to DSO of BW system.
As per the classical approach, the data would be loaded into BW PSA via DB Connect / Data Provisioning options. Then DSO loading from PSA.
If PSA data is not deleted on a regular basis, It will increase the cost of data storage, the downtime for maintenance tasks and performance of the data load.
I have done this requirement using ODP – SAP HANA Information Views approach.
In this ODP approach, Data is directly stored into Target DSO from ECC HANA Information Views using DTP.
It is making PSA Storage and Info Package execution are obsolete
The first step in the data load, ODP – SAP HANA Information Views Connection (RFC ABAP Connection) need to be created in BW system.
In Connection Parameter, the Target as ECC system Host name has to be mentioned.
Once connection Tests are successful, New RFC Connection created under ODP – SAP HANA Information Views Folder.
The ODP – SAP HANA Information Views Connection (RFC ABAP Connection) between the Source and Target system is,
Data source created in BW System. In the pop-up, ODP Context would be displayed as HANA Information Views.
In Operational Data Provider Text Box, The HANA Information View Name (Analytic View / Calculation View) name has to be mentioned.
The help pop-up show the list of Information views available in the Source ECC HANA System.
From the list, appropriate Information view has to be selected.
Once Data Source Creation is done, no need to create Info Package.
BW Target would be either Classic DSO / Advanced DSO.
Target DSO/ADSO created and Transformation mapping done from ODP Data Source to DSO.
In DTP, ODP – SAP HANA Information Views as Source, Delta Extraction mode won’t be supported. So Extraction mode changed to Full.
Under Parameters of the Data source,
Data Extraction selected as “Directly from Source system. PSA not used (for small amount of data)”
Ignore the Warning Pop-up “Last change is incompatible with SAP HANA Processing”.
(DTP SAP HANA Execution Processing mode will be disabled)
DTP Adapter changed to “Extraction from SAP Source system by Operational Data Provisioning”
Activate the DTP and Execute the DTP execution. After DTP execution completed, DSO data has to be activated.
DSO Output is,
Data is getting loaded into BW DSO successfully from Source SAP HANA Information Views without PSA Storage and Info package execution.
Your thoughts and comments are welcomed.