Skip to Content
Author's profile photo Muthuram Shanmugavel

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.

temp.PNG

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.


temp.PNG


The ODP – SAP HANA Information Views Connection (RFC ABAP Connection) between the Source and Target system is,

temp.PNG

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.


temp.PNG


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.

temp.PNG


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)”


temp.PNG


Ignore the Warning Pop-up “Last change is incompatible with SAP HANA Processing”.

(DTP SAP HANA Execution Processing mode will be disabled)

temp.PNG


DTP Adapter changed to “Extraction from SAP Source system by Operational Data Provisioning”

temp.PNG


Activate the DTP and Execute the DTP execution. After DTP execution completed, DSO data has to be activated.

DSO Output is,

temp.PNG

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.

Regards,

Muthuram




Assigned Tags

      16 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Dinesh Anblazahan
      Dinesh Anblazahan

      gud one muthu...

      Author's profile photo Daniel Ray
      Daniel Ray

      Hi muthu,

      how can we use SLT for the classic BW on HANA standard extractors for eg. 2LIS_13_VAITM where its further loaded to hana optimized IC. ...I mean if we have BW on HANA, and want to use SLT to extract data to BW using this standard data extractor. Do we need to use webservice to extract data from ECC on HANA to BW on HANA using SLT.

      Can we use your above process to do this ? Please advice.

      Thanks

      DR

      Author's profile photo Muthuram Shanmugavel
      Muthuram Shanmugavel
      Blog Post Author

      Hi Daniel,

      Sorry, I have not worked in this scenario.

      From My Learning, What I understand is,

      Using ODP-SLT approach, We can extract ECC Tables to BW.

      But I don't know How to use SLT to extract data to BW using this standard data extractor.

      This document might helpful for you.

      Transferring Data from SLT Using Web Service - Modeling - SAP Library

      http://sapassets.edgesuite.net/sapcom/docs/2015/07/62c8dbf4-5a7c-0010-82c7-eda71af511fa.pdf

      Regards,

      Muthuram

      Author's profile photo Daniel Ray
      Daniel Ray

      I got another reply from Martin Grob that we can't use LO datasource's through SLT replication for BW on HANA. Well how about , we can still go use the LO extractors through SLT to a HANA Info view's through Data services designer, and replicate these views to BW and use a Virtual provider on top of it with BW MD, and use it in BW bex reporting. Are you aware of this ?

      My intention is use the existing functionality of the standard SAP delivered ECC LO extractors to HANA. I don't think we need to fill setup tables and all as this can be controlled through HANA replication. for eg. 2lis_13_VDHDR to HANA. How do we do that ?

      Thanks

      DR

      Author's profile photo Abhishek Sharma
      Abhishek Sharma

      Hey Daniel,

      How about DXC for using LO extractors ?

      This may be an alternative which you might want to check.

      http://scn.sap.com/community/hana-in-memory/blog/2014/02/25/data-replication-to-sap-hana-using-dxc-method

      Regards,

      Abhishek

      Author's profile photo Former Member
      Former Member

      Hi Muthu!

      I've SDA connection in BW from ERP system. I have DB connect source system in BW  ( on SDA connect).In this system I can create datasource based on calculation view 

      I can do this using ODP. What advantages/ disadvantages have this two approaches   ?

      Regards

      AZ

      Author's profile photo Muthuram Shanmugavel
      Muthuram Shanmugavel
      Blog Post Author

      Hi Alexander,

      Using ODP,

      Target BW system connected to Source ECC System via RFC Connection.

      Using SDA,

      Target BW System connected to Source HANA System using SAP HANA Source System (DB Connection).

      If We take Data Transfer as a factor,

      In ODP,

      Data will me moved from Source HANA DB --> ECC

                                            ECC --> BW

                                            BW --> Target HANA DB.

      In SDA,

      Data will be moved from simply Source HANA DB to Target HANA DB without

      Application Server Intervention.

      If We want to create Virtual Data warehouse, SDA is most welcomed.

      Using SDA Connection,

      We can create Open ODS Views in Target BW on Source HANA Views.

      Reference: https://open.sap.com/courses/bwhana1-1/items/2tP65VpqDpx1X4k1kQ9qW1

      temp.PNG

                                      

      Regards,

      Muthuram

      Author's profile photo Former Member
      Former Member

      A lot of thanks!

      Author's profile photo Glen Spalding
      Glen Spalding

      hi

      Data Extraction selected as "Directly from Source system. PSA not used (for small amount of data)"


      using this setting, were you able to optimize the DTP for HANA processing?

      Author's profile photo Muthuram Shanmugavel
      Muthuram Shanmugavel
      Blog Post Author

      Hi Glen,

      No. I am not able to optimize for HANA Processing.

      So I continued without selection "SAP HANA Execution" Option.

      temp.PNG

      Regards,

      Muthuram

      Author's profile photo Former Member
      Former Member

      As of I know we can use only tables/views as sources for ODP. We cannot use the data sources as source.

      Author's profile photo Abhishek Sharma
      Abhishek Sharma

      That's true Indira however if you intend to capture the business logic available in the SAP extractors in the way they are you may want to use DXC for data extraction as an alternative as suggested to Daneil above.

      http://scn.sap.com/community/hana-in-memory/blog/2014/02/25/data-replication-to-sap-hana-using-dxc-method

      Author's profile photo Ganesh Bothe
      Ganesh Bothe

      Useful information Muthuram. 🙂

      Author's profile photo Former Member
      Former Member

      hi
      We are in BW 7.5 SP3 and while replicating datasrc using ODP as the source system connector, in BW while replicating the datasource getting the below error.
      ------------------------
      Error while saving DataSource 0INDUSTRY_TEXT_0001 xxxCLNT060
      No fields were supplied

      Source system xxxCLNT060: metadata upload with errors
      Message no. RSDS554
      -----------------------------
      Any thoughts ???

      Author's profile photo Former Member
      Former Member

      Hi Muthuram,

      I was about to make HANA -BW Connection, i followed the above steps provided.

      I have created RFC Connection with ECC Application Host Name, Not with ECC HANA Studio Host Name.

      It asked for the Source System Type and Release --Don't know what to be mentioned, However i have given some name as it says it starts from S.

      After that I am not able to get Views present in HANA Studio.

      Please let me know, is there anything missing in authentication?

      Thanks
      Abdullah

      Author's profile photo Former Member
      Former Member

      Hello Muthu,

      Can you please let me know on how can we further Edit or change data in BW, since the PSA is now becoming obsolete.

      I always get situatons in BW wehere we need to edit few PSA data and then further load it into BW, but since the data sources are of type ODP now which loads directly to data targets how can i edit data further,

       

      Regards