Replicate ECC Datasource to SAP HANA

[former_member182277]

Hello All,

I have the requirement to replicate the ECC Datasource to SAP HANA.

We have SLT in place.

Any pointer on this will be really helpful.

Regards,

Neha

[Former Member · Accepted solution]

Hi Neha,

    From HANA 1.0 SPS 04 you can use the new DXC (SAP HANA Direct Extractor Connection) to extract data using DataSources. When you use it, data are extracted using DataSources and flow to an In-Memory DataStore Object (IMDSO in HANA - don't make confustion with In-Memory DSO created in Bw on HANA). You still have to setup infopackages, process chain, etc in the source system (SAP ERP has a embebbed BW in it, so you don't need a standalone BW).

And of course, this is not real time, but batch job driven. Using this scenario you don't need SLT neither DataServices.

More details: https://websmp206.sap-ag.de/~sapidb/011000358700000421852012

[Former Member · Accepted solution]

Hi Rodrigo

   Thanks for sharing this, this is very interesting,As of now In-memory DSO is there if In-Memory Infocube and other binfoproviders are also availble.May be this is  heading towards elimination of BI.

Thanks

Santosh Varada

[rama_shankar3 · Accepted solution]

Rodrigo,

This is what customers need. Cool stuff.

Thanks for sharing!

Rama

[Former Member · Accepted solution]

Hi Rodrigo:

This gives me an option to extract standard ECC transactions data through the standard BW Extractors.

Can DXC be used to send this extracted data to some external system as well?

Thanks

Devendra

[Former Member]

Hi Neha,

We can not replicate Data Sources delievered for BI into SAP HANA using SLT. using SLT, we can replicate the tables from ECC to HANA.

If you want Datasource, then it can be possible in two ways.

1) Replicate the tables which feeds that DS into HANA and create view same DS structure.

or

2) Loading data from ECC DS into HANA is possible with BODS. here also we have restictions that DS entry should present in table ROOSATTR.

Regards,

Venkatesh

[Former Member]

Hi Neha

   You mean the BI Datasource which we access using RSA6  or any table ,because replicating data via SLT into HANA you have already done I believe , so I just wanted to understand the Datasource in this context ,also I never came across replicating BI datasource to HANA using SLT, as per I know it is possible with BODS .Awaiting your feedbcak

Thanks

Santosh

[former_member182277]

Hello Santosh,

Thanks for the reply..

yes, i mean replicating BI datasource to SAP HANA through SLT.

I know we can do the same through BODS. but SAP is saying we can replicate data from ECC to HANA thorugh SLT, then why not datasource.

Regards,

neha