You may encounter this
topic while speaking of datasource which are or are not released for ODP. The
release it self means either they are enabled to be used by tools like SAP Data
Services (former SAP BusinessObjects Data Services (BODS)) (DS). ODP Data
Replication API is used for internal connection of Data Services to application
extractors. Interface is delivered with a NetWeaver Support
Package. SP is specific for each of ECC’s component PI_BASIS.
Great benefit of ODP is
that so far only BW could use business
content datasources. While utilizing ODP all Business
Suite extractor can be consumed without BW. Also there is no need for ABAP
flows where data provided by extractor is processed while staging. This clearly
indicates that one of data consumer is SAP
HANA.
How to recognize if
particular DS is released for ODP? Check table ROOSATTR. If the datasource
(extractor) is marked as released in ROOSATTR (field EXPOSE_EXTERNAL = X), then
ODP API will be used for extraction and multiple subscriptions should be
possible. If it is not marked as
released in ROOSATTR, then you are not using ODP to do extractions and multiple
subscriptions are not possible.
If you have developed your
custom extractors and you would like to released them in this way you need to
use ABAP report RODPS_OS_EXPOSE for that.
P.S: be careful while you
upgrading your ECC via SP or EHP.
It may happen that upgrade will release some of business
content datasources as ODP. As consequence some of them may stop working.
Therefore always check SMP
for the latest fixes of such a issues.
More info on ODP topic:
1558737 - Data
Sources released for ODP data replication API
2 comments:
Dear Sapper, great info. we are about to implement HANA and planning to use Extractors to read ECC data using BO DS, we want to do HANA modelling and expose it directly to reporting tools and avoid any BW artefacts of Cube/Provides. Other than using ODP is there any other option? DXC? Also, will ODP cover 80%+ of standard extraction need for FICO, MM, SD modules?
Thanks.
Abhishek.
Hi Abhishek,
From what I learned from sources like SCN other option complement to ODP is DXC. All others are data replication technologies for HANA: BODS (DS), SAP Landscape Transformation (SLT), Sybase Replication Server where you need another component in place e.g DS.
With respect Direct Extractor Connection (DXC) consider following features: DXC is ETL tool, no extra features. Data provided by DXC is presented to HANA's XS engine. Delta mechanism is done by HANA's IMDSO (In-Memory DataStore Object) with activation processing. If you need some data transformation you may want to put it to HANA therefore. It will be like recreating functionality of e.g. BW into HANA...
check out following sources:
https://help.sap.com/hana/SAP_HANA_Direct_Extractor_Connection_Implementation_Guide_en.pdf
cheers
sapper
Post a Comment