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.

About SAP Note 3255746

SAP Note 3255746 states that the RFC modules of the ODP Data Replication API are only intended for communication between SAP applications. Customer or third-party usage of ODP RFC is not permitted. A technical security update that validates incoming ODP RFC calls and can block unpermitted usage has been announced. For this reason, it is not guaranteed that ODP extractions will continue to run after the SAP security updates are deployed.

The alternatives described in this article do not use the ODP API and are not affected by SAP Note 3255746.

To check if your current ODP extractions are affected by the SAP security update, you can use a self-assessment utility provided by SAP Note 3439624. The utility allows users to analyze completed ODP RFC calls and classify them as:

• Permitted
• Unpermitted
• Unclear
• No Assessment Info

Note that the utility is not sufficient on its own. Users must manually review unclear or suspicious cases.

Restricted RFC Modules

The restrictions imposed by SAP Note 3255746 affect the following RFC modules of the ODP Data Replication API:

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.

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.

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 extract 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

• Guidance on SAP Note 3255746 for Theobald Software Xtract Products.