Skip to Content

Replicate ECC Datasource to SAP HANA

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Jun 04, 2012 at 02:09 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Jun 04, 2012 at 06:51 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Jun 04, 2012 at 07:00 AM

    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

    Add comment
    10|10000 characters needed characters exceeded