This discussion is locked
2 Replies Latest reply: Dec 11, 2011 3:20 PM by Arun Varadarajan RSS

How to fetch the data from Ecc to BI ?

harish kamarthi
Currently Being Moderated

Hi everybody.


Can anyone briefly explain with the screen shots > How to fetch the datasource from  RSA5 tcode in ECC to BI? How you replicate there? how the INFO PACKAGE , TRANSFORMATIONS, DTP , DSO, INFO CUBE was created? where we see the catalogs for this data.......THANKS IN ADVANCE

  • Re: How to fetch the data from Ecc to BI ?
    Alok Kumar
    Currently Being Moderated



    You can follow the below steps to fetch the data from ECC to BI System.


    1>Connection should be there between ECC and BW System.

    2>Go to Tcode-RSA5 in ECC system and find your data source and then activate it.

    3> Go to Tcode-RSA6 in ECC system to check whether your DS is available..if it is there then its been activated.

    4>Go to Extract Checker tcode RSA3 and test the data and make sure data is correct.

    5>login to BW Side..go to tcode RSA1-->Choose your source system. ECC -> double click on it and you will move to Data source>Select your Application component ex, SD,FI ...>Right click and replicate the Datasouce> Now on refresh you can see the datasource in BI System.

    6>Install the related the Infoprovider .. cube or dso ..Connect the datasouurce and create Transformation.

    7> Now create infopackage and run it in ful & init mode then do the delta for the new records.


    Please refer the below link for more details on extraction.



    Hope this helps.