ODP

Introduction

Operational Data Provisioning provides a technical infrastructure that you can use to support two different application scenarios. 

- Operational analytics for decision making in operative business processes. 

- Data extraction and replication.

Here mostly we will talk only about Data Extraction and Replication ( and mostly to BW ).

The R.H.S shows Providers which supply data to ODQ which is read by Consumers ( Subscribers ).
Eg : Here, Datasource ( Extractors ) basically refers to BW Extractors ( eg: 0FI_AP_4 or 2LIS_02_ACC etc.).
Once the datasources are ODP enabled ( SAP Note 0002232584 ) , They act as ODP Providers.
When BW System is reading data from ODQ, it becomes the subscriber.

One Source can provide data to multiple subscribers.
0FI_AP_4 Data can be read by SAP BW, SAP Data Services etc.

Context
A context represents a source of ODPs.
( Providers - Like sources which can be used - like SAP Extractors, HANA Views ? ).
Context identifiers exist for all technologies whose analytical views can be exposed as ODPs.
Determination of available contexts in system is done
via CL_RODPS_DEFAULT_CONTEXT->GET_CONTEXT_LIST


The main advantage of ODP in BW is we need not use PSA anymore ( that also means, we cannot correct invalid records in PSA - May be we can use Error DTPs ? )

ODP FAQs       - Click HERE
ODP Overview - Click HERE

Creating a ODP Datasource
Creating and ODP datasource is same as regular datasources.
If you know the datasource already exists in your source system, you can either replicate the datasource or create a datasource by right clicking.
Make sure that the datasource is ODP enabled before creating.Running BS_ANLY_DS_RELEASE_ODP make a datasource available as an ODP.

You can use the same name as the regular datasource and rename it.
once the datasource / transformation / DTP is created, run the DTP and it will create an entry in ODQMON.

Points to Remember

• Check if a datasource is ODP enabled. If the right hand side icon is Green, it is released and can be used. If red, we need to implement below mentioned note and other steps to make them available.

• Implement SAP Note 0002232584 to release datasources to ODP. 
• This will install program BS_ANLY_DS_RELEASE_ODP when executed, This program add entry in table ROOSATTR and makes field EXPOSE_EXTERNAL = ‘X’.
• Run program RODPS_OS_EXPOSE to expose zdatasources to ODP.
• Not all datasources in the excel sheet are relaeased
• Not all datasources are released for ODP. Go to RSA5/6 and check the datasource. If the datasource is in red  , it means it is not released for ODP.
•   Eg: 0EQUIPMENT_ATTR
•   Check Note 2173041
• Initialization
• There is no separate initialization. DTP when run for the first time, does initialization along with data load. There is an option to do init with out data transfer ( Delta init with out data).
• When the DTP is run again, it will act as Delta DTP.
• Delta Functionality
• Everything remains same the jobs in the background. It's just that the collective job would now write to ODQMON. If the same data source is used for traditional approach as well then the delta would be written to both ODQMON and RSA7.

Change Mode Field : ODQ_CHANGEMODE
'C' The data record was created as new record in the source.
'U' The data record was changed in the source. Depending on the delta procedure, the delta can contain up to two data records for one changed record in the source.
'D' The data record was deleted from the source.

ODP Tables

Tables	Description	Extra Notes
ODQDATA	Data Store for Delta	Contains all compressed Delta request Data
ODQDATA_F	Data Storage for One-Off Extraction	Contains compressed Full request Data
ODQDATA_C	Data Storage for Delta Init.	Contains compressed Init request Data
ODQREQ	Operational DeltaQueue: General Request

ODP TCodes & Std.Programs

Name	Description	Extra Notes
ODQMON	ODP Delta monitor	Monitor for all delta queues : Notes
ODP_CLEANUP	Clean up program	Notes
RODPS_REPL_TEST	Check data in the delta - Like RSA3	Notes
BS_ANLY_DS_RELEASE_ODP	Releases datasources to ODP	SAP Notes 2232584
RODPS_OS_EXPOSE	Release Z Datasources to ODP

Errors and Solutions

Click HERE

DTP Failures

Subscription for DTP_ deleted in source system ODP...... See long text.

Online content
Data Acquisition with ODP and SLT (SAP) - Video
Reporting on Operational Data Providers     - Link
Data Loading to BW From ECC using ODP – SAP HANA Information Views - Link
Logistics(LO) Extraction with ODP Framework - Link