We used to do replication datasource using RSA5 and RSA6 in ECC System. Then replicate the active datasource in BW System using RSDS.
But since SAP introduce ODP (Operational Data Provisioning) as Data Exchange Framework between Source and Target , it allows us to make use of the ODP source system to use the same technology for a data mart scenario between BW systems as you would for providing other SAP source data for the BW system.
To understand more about ODP here is the link for FAQ
After activating datasource in RSA5 & RSA6 ECC System the datasource is not appearing in BW RSDS Tcode.
First, understand the Color Legend in RSA5 transaction ( Utilities > Color Key ).
After activating datasource system asking for Package & TR for object. But the status still in red. In old replication this is common and we still can replicate it in our BW System. But it turns out the green check icon represent the Release Datasource for ODP.
then I’ve found out that not all Data extractor of Datasources is supported by ODP from here . I check on table ROOSATTR in ECC System, but my failed replicated datasource already there.
“The ODP API does not show all Extractors, it only shows the released ones. The idea is that over the time multiple Extractors have been developed by SAP, some became obsolete, some might not work with this API. So along with the ODP API a new table is created in the dictionary called ROOSATTR containing all the Extractors the API and hence DataServices 4.0 supports.”
after reading the notes on https://launchpad.support.sap.com/#/notes/2232584 ,
SAP extractors: Most of the delivered SAP extractors are already released for ODP replication. You can release the corresponding DataSources in your SAP source system by implementing this SAP Note in your source system and then executing the program BS_ANLY_DS_RELEASE_ODP in the relevant source system. Pay attention to the restrictions that apply to the ODP release described in SAP Note 1932459 and KBA 2407906.
So i run the program BS_ANLY_DS_RELEASE_ODP in Development & Testing Client for Source System in BW. Voila! The status in RSA5 & RSA6 my active datasource already turn into green, which is activated for ODP.
If your datasources still not activated for ODP, in notes also saying that,
For other SAP extractors that are not currently released for ODP replication but that you require, please open an incident in the application component BW-BCT-GEN.
Then Replicate in BW System
RSA1 > Source System > Choose Client under ODP – SAP > right-click > Replicate Datasource
You will find your activate datasources. Don’t forget to activate in RSDS Tcode to activating datasources in BW system.