Need an expert advice, After making the DXC connection between BW and HANA for extracting data from bw and loading to hana db.
How does this connection work, is it similar to trigger based SLT or is it something like scheduling process to run at regular intervals to handle initial and delta loads to hana db.
which element initiates the process is it BW or HANA.
Are there any video links or any steps available to achieve the DXC connection and handling of initial loads and deltas.
Thanks a lot for the helpful info.
As per my undertanding,DXC is used to replicatte the BI datasources in ECC to HANA.
DXC does not require BW on SAP HANA. Also with DXC, data is not loaded into the embedded BW system. Instead, data is redirected into SAP HANA and that can futhur use for the modelling and reporting. Hope it is useful. Regards, neha
DXC does not require BW on SAP HANA. Also with DXC, data is not loaded into the embedded BW system. Instead, data is redirected into SAP HANA and that can futhur use for the modelling and reporting.
Hope it is useful.
Let us say we have a client who is currently on SAP BW and regular delta loads are happening from their ECC System. If we gradually migrate their BW Application to HANA, can have a DXC between the BW System and HANA, and extract regularly from their BW System ?
The IMDSOs would then be generated from "Export Datasources" of Infocubes like 0SD_C03.
My two cents:
Data loads from ECC to BW on HANA (after gradual migration) can continue and for the standalone HANA you might want to use DXC, if the extractors fullfil the conditions / limitations of DXC. If the DXC cannot be used, you might want to use BODS for extraction.
Regarding accessing the data in BW objects in Standalone HANA, currently there is no direct mechanism for that. Although technically you can access the Infocube fact tables and DSO active data table from Standalone HANA (if both the schemas are implemented on the same HANA serv er), it is not allowed by SAP.
So you might want to have a workaround solution like exporting the data from BW in form of open-hub or something to get the data from BW and load it to the HANA database.
In this scenario, the BW application with all the existing business solution implementation will remain as it is with the transformation and "consumable" data, whereas the Standalone HANA will act as the "Reporting Solution".
It can continue till the entire data model in BW is generated in standalone HANA.
The only doubt that I have with BO Data Services, is they will not be able to handle the Delta Management from the BW System. This is because Infocubes in SAP BW are being loaded with incremental Data on a daily basis.
My understanding of BODS with SAP is that they can help in extracting data from Infocubes/BeX Queries on a one-time basis and there is no mechanism to get regular updates on a daily basis to stabilise a process.
Same for Open-hub, I am not confident of its capabilities for a regular and smooth flow of incremental data on a daily basis.
That is why I was thinking of DXC from BW to HANA. Like I said, Export Datasources from Infocubes can also be treated as SAP Extractors and to IMDSOs they would be just another extractor, albeit from the BW System.
Adding to the above points:
DXC can only provide near real-time data replication. Depending on your reporting needs this should be sufficient in most business cases.
The big advantage of DXC is in the landscape and skills required to implement SAP HANA (in other words cost). The key is whether or not the business needs real-time data replication.
If BW extractor in ECC supports DXC and delta loads, implementing DXC should be sufficient. Personally, I am all for DXC.
I'm not sure if Kumar's question got answered and I have a similar question. I've read thru many of the Hana documents and it's not clear how data moves from ECC to BW 7.3 on Hana. Say after BW 7.3 is implement on Hana, 2LIS_02_ITM datasource is activated and Infopackage is created for 2LIS_02_ITM. If I execute the infopackage how does the data get into HANA?
1) Uses the current TRFC process to transfer data to a HANA table(PSA).
2) Uses the DXC functionality.
3) Uses the BODS functionality.
My understanding is that option 2 is the normal transfer process for ECC datasources to BW on Hana but I have not been able to confirm this. The only thing I can find is the following link
It has an entry for PSA which indicates a MERGE functionality which tells me it's in the IMDSO architecture which is how the DXC functionality works.
Hello Rama Shankar,
After reading the entire discussion, i am again confused with DXC.
My understanding is i can use DXC to get the data from ECC to SAP HANA via SAP BODS (using Extractor type) replication is it?
Is there any document or tutorial which explains with example on how can i do this ?
Please help me in this.
DXC is an alternative solution to BODS. If you are using DXC, you do not need BODS or SLT. The only thing with using DXC is that you can not have real-time replication. The data replication will happen on scheduled time intervals with full support to delta extraction provided the source SAP ECC-BW extractor supports delta.
Checkout the SPS4 admin guide for details on using DXC, I also remember reading a DXC guide but can't find it anymore in experienceHANA website.
Hope this helps.
According to my knowledge if your bw system is not running on hana we will go for dxc connection. After enabling both xsengine and icm service in your hana studio your dxc will be in running mode. After this you have to create a rfc connection in sm59 to hana from bw system. After creating rfc connection go to sa38 and assign your data sources to hana. After doing this 5 tabels will be generated in your hana db corresponding to your dso. After this you have to design a process chain in bw for regular data lodes into hana.
Note: if once a data source is assigned to hana through dxc that data source is no more usefull in your bw system for any etl or reporting purposes.