Skip to Content
author's profile photo Former Member
Former Member

Difference between ODP and Open ODS

Hi

Hi,

I would like to know the difference between the ODP ( Operation Data provisioning ) and Operation Data Store?

1)For the BW Extractors:

Should we go with the ODP or Open ODS ?, as both support it.

2) For the SLT ( Tables( SAP and Non-SAP )

Should we go with the ODP or Open ODS ?, as both support it.

3) For the ( HANA : Information Views( Attr View, Analytical Views, Calc Views )

Should we go with the ODP or Open ODS?

So in the LSA ++ architecture , which type is recommended ( Open ODS or ODP ).

What Major advantages/disadvantages between these two.

Thanks in advance for your answers.

Regards,

Adhvi.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2014 at 05:04 AM


    Hi Adhvi,

    Same question is beign revolving around in SCN, you can secarch and get detailed answers.

    I will also try to give an overview of these fetaures:

    In BW basically there are three layers

    1) Extraction Layer --> Technically this layer is supported by "Source system" and "Data source" in BW

    2) Transformation/Staging Layer --> Technically this layer is supported by WODSO and DSO in BW

    3)Reporting layer layer -->Cube,MultiProvider.

    In the latest release of BW along with the excisting source systems you will get an additional optional of ODP source system

    So now in Extarction Layer - Along with other source system types you get additional option of ODP sosurce system.

    In the above picture you can see two types of BW source systems one is standard one and other is a ODP source systems similary for ther source systems like SAPI and extrenal source systems.

    The reason for giving both the options is when you migrate your systems your excisting source systems should remain intact.

    So the ODP Plays a role in Extarction Layer.

    Coming to Open ODS View this will come under staging / reporting layer.In latest BW relases especially in HANA we are trying to reduce the number of layers and try to merge the Staging and reporting layer.So the Open ODS will be a new type of infoprovider which has a role to hold the Data or Virtualise the data once the data is extracted via source systems.

    So the conclusion is

    ODP - is an new technology which helps you to extarct data

    ODS - is an new technology which heps you to store or virtualise the extracted data.

    Now you might question wat is the advantage of ODP should I go and change all my excisting extractors to this new ODP source system?

    My recomendation is donot touch any of your excisting setup initially but whenever you try to implement new extractors or new extraction use this ODP because this ODP has many advantages.Then Slowly you can migrate your old extractors.

    Coming to your other question: For extrating from SLT and HANA views use ODP.

    I hope your confusion will be cleared now and I have answered your question.

    Now with this basic understanding go through the below links to know more about ODP & ODS

    ODP:

    https://help.sap.com/saphelp_nw73/helpdata/en/c6/afacb707764885a6fb62f511c24f34/content.htm?frameset=/en/c6/afacb707764885a6fb62f511c24f34/frameset.htm&current_toc=/en/a3/fe1140d72dc442e10000000a1550b0/plain.htm&node_id=321&show_children=false

    ODS:

    https://help.sap.com/saphelp_erp2004/helpdata/en/f9/45503c242b4a67e10000000a114084/content.htm


    ODP.PNG (18.5 kB)
    ODS.png (37.3 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2014 at 06:39 PM

    Thanks a lot dinesh :-) that explained a lot ....no confusion now . Adding to the point in the reporting layer or architectures data mart layer multi provider and infosets will be replaced by NCP and ADSO .plz correct me if I am wrong here

    Thanks again

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.