Alternatives for Xtract ODP
The following article shows how to replace most Xtract ODP provider contexts with other components.
In addition to the components presented in this article, Xtract IS offers the Xtract ODP(OData) component to extract ODP data via OData protocol. While Xtract ODP(OData) covers all provider contexts, the extraction time for large data sets is longer compared to the alternatives described in this article.
| Provider Context | Alternative |
|---|---|
| ABAP Core Data Services [ABAP_CDS] | Xtract Table |
| HANA Information Views [HANA] | Xtract Table Xtract BWCube |
| SAP NetWeaver Business Warehouse or BW4/HANA [BW] | Xtract BWCube Xtract Table Xtract TableCDC Xtract DeltaQ Xtract OHS |
| Datasources/Extractors [SAPI] | Xtract DeltaQ |
| SAP LT Queue Alias [SLT~your_queue_alias] | Xtract Table Xtract TableCDC |
About SAP Note 3255746
SAP prohibits customers and third-party applications from using the RFC modules of the ODP Data Replication API to access SAP ABAP sources, see SAP Note 3255746. These modules are exclusively for SAP-internal use and may be changed by SAP at any time without prior notice.
The following RFC modules are affected by this restriction:
- RODPS_REPL_AUTH_CHECK_CONT
- RODPS_REPL_CONTEXT_GET_LIST
- RODPS_REPL_CURSOR_GET_LIST
- RODPS_REPL_ODP_ACTIVATE_CONT
- RODPS_REPL_ODP_CLOSE
- RODPS_REPL_ODP_FETCH
- RODPS_REPL_ODP_FETCH_COLUMN
- RODPS_REPL_ODP_FETCH_XML
- RODPS_REPL_ODP_GET_CONT
- RODPS_REPL_ODP_GET_DETAIL
- RODPS_REPL_ODP_GET_LIST
- RODPS_REPL_ODP_GET_SUBSCR
- RODPS_REPL_ODP_MD_GET_ALL
- RODPS_REPL_ODP_MD_TREE_GET
- RODPS_REPL_ODP_OPEN
- RODPS_REPL_ODP_PREFETCH
- RODPS_REPL_ODP_READ_DIRECT
- RODPS_REPL_ODP_READ_DIRECT_XML
- RODPS_REPL_ODP_RESET
- RODPS_REPL_ODP_SUBSCRIBER_NEW
- RSAP_ROUNDTRIP_CHECK
The alternaitves decribed in this article do not use the ODP API and are not affected by SAP Note 3255746. For more information on how to handle SAP Note 3255746, refer to our Blog post Guidance on SAP Note 3255746 for Theobald Software Xtract Products.
Extract Data from CDS Views
Alternative for the ABAP Core Data Services [ABAP_CDS] provider context:
To extract data from CDS Views, use the Xtract Table component.
Note
When looking up CDS Views in Xtract IS, make sure to look up the name of the DDL SQL View (CDS Database View) instead of the CDS View name.
Extract Data from HANA Views
Alternative for the HANA Information Views [HANA] provider context:
To extract data from HANA Views, use the Xtract BWCube component or the Xtract Table component.
-
Extraction via Xtract Table
- In SAP, expose the HANA View to ABAP CDS Views, see SAP Community: How to consume HANA Calculation views in S/4HANA CDS views.
- Extract the CDS View using the Xtract Table component.
-
Extraction via Xtract BWCube
- In SAP, expose the HANA View to CompositeProviders, see SAP Learning: Consuming a Calculation View with SAP BW/4HANA
- Extract the CompositeProvider using the Xtract BWCube component.
Extract Data from BW Systems (CompositeProviders, Cubes, InfoObjects, etc.)
Alternative for the SAP NetWeaver Business Warehouse or BW4/HANA [BW] provider context:
- To extract data from CompositeProviders, InfoCubes, MultiProviders, aDSO/DSOs etc., use the Xtract BWCube component.
- To extract data from InfoObjects (Master data, Text data or Hierarchies), look up the respective tables (P, T, H) in the Xtract Table component.
- To extract data from Hierarchy InfoObjects, use the Xtract Hierarchy component.
- To extraxt data from Infocubes and DSOs, convert the Infocubes and DSOs to DataSources and extract the DataSources using the Xtract DeltaQ component.
- If you use Open Hub Service (OHS) destinations that can receive data from Cubes, DSOs, aDSOs etc., the data can be extracted using the Xtract OHS component. You can also run the process chain that writes data to OHS within SAP BW.
- To extract the data from OHS tables, use the Xtract Table component.
- To extract delta changes (Inserts, Updates, Deletes) from an OHS table, use the Xtract TableCDC component.
Extract Data from Extractors
Alternative for the Datasources/Extractors [SAPI] provider context:
To extract data from Extractors, use the Xtract DeltaQ component.
Extract Data from Tables
Alternative for the SAP LT Queue Alias [SLT~your_queue_alias] provider context:
- To extract data from regular (application) tables, cluster or pooled tables, use the Xtract Table component.
- To extract delta changes (Inserts, Updates, Deletes), use the Xtract TableCDC component.
Related Topics
Written by: Rajesh Malapati, Valerie Schipka