cancel
Showing results for 
Search instead for 
Did you mean: 

Replicate BW Cubes to HANA Sidecar

former_member200967
Active Participant
0 Kudos

Hi Experts,

We have a BW 7.4 on HANA system. However we have a requirement where in we want to use this BW data in another HANA (Native) Sidecar system. What is the best way to replicate the data or to create view of BW data in the Sidecar HANA system?

Regards

Manpreet

Accepted Solutions (0)

Answers (2)

Answers (2)

FCI
Active Contributor
0 Kudos

If you have a Hana sidecar, you probably already use SLT. If you don't need any heavy transformation, I'd rather used SLT than BO DS.

Regards,

Frederic

muthuram_shanmugavel2
Contributor
0 Kudos

Hi Manpreet,

1. BODS:

    Using Business Objects Data Services, We can able to replicate BW data to Native HANA System.

    

Using this approach,

1. We can extract Data directly from BW Objects (DSO, Info cube).

2. Delta Loading is possible.

3. BW Data will be stored in HANA Tables.

2. Smart Data Access (Target HANA to Source HANA - DB Connection)

This is DB to DB connection.

1. If we need to Extract DSO Data, It need to be extracted from Its Active Table.

    For Example To Extract Data from DSO - ZTEST,

    Data has to be extracted from /BIC/AZTEST00 Table.

2. This will be Virtual Table concept, So BW Data won't be stored in HANA DB.

    During Request, The Data will be retrieved from Source BW.

3. SLT:

SLT is real time replication But It is Table to Table replication.

To Extract DSO Data, It has to be extracted from DSO Active Table only.

Data will stored in HANA Tables.

4. Direct Extractor Connection (DXC):

Using DXC, Data will be extracted from ECC to Native HANA system

using Embedded BW ETL mechanics.

But Here, The data has to be moved from BW system is source.

To Implement DXC, We need one more BW system for ETL mechanics.

So I think It is not feasible solution.


--------------------------------------------------------------------------------------------------------------------------

So My Final Suggestion would be BODS would be good option to extract data from BW on HANA system to Native HANA System.


Regards,

Muthuram