Skip to content

Alternatives for the ODP Extraction Type

The following article shows how to replace most ODP provider contexts with other extractions types.

In addition to the extractions types presented in this article, Board Connector offers the ODP(OData) extraction type to extract ODP data via OData protocol. While 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] Table
HANA Information Views [HANA] Table
BWCube
SAP NetWeaver Business Warehouse or BW4/HANA [BW] BWCube
Table
Table CDC
DeltaQ
OHS
Datasources/Extractors [SAPI] DeltaQ
SAP LT Queue Alias [SLT~your_queue_alias] Table
Table CDC

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.

Tip

To display a list of all extractions that use the ODP extraction type in Board Connector, navigate to Help > Show Compliance Info or press F6.

Restricted RFC Modules

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

  • 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

Extract Data from CDS Views

Alternative for the ABAP Core Data Services [ABAP_CDS] provider context:
To extract data from CDS Views, use the Table extraction type.

Note

When looking up CDS Views in Board Connector, make sure to look up the name of the DDL SQL View (CDS Database View) instead of the CDS View name.

odp-abap-cds

odp-abap-cds

Extract Data from HANA Views

Alternative for the HANA Information Views [HANA] provider context:
To extract data from HANA Views, use the BWCube extraction type or the Table extraction type.

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 BWCube extraction type.
  • To extract data from InfoObjects (Master data, Text data or Hierarchies), look up the respective tables (P, T, H) in the Table extraction type.
  • To extract data from Hierarchy InfoObjects, use the BW Hierarchy extraction type.
  • To extract data from Infocubes and DSOs, convert the Infocubes and DSOs to DataSources and extract the DataSources using the DeltaQ extraction type.
    export-datsources
  • If you use Open Hub Service (OHS) destinations that can receive data from Cubes, DSOs, aDSOs etc., the data can be extracted using the OHS extraction type. You can also run the process chain that writes data to OHS within SAP BW.
    • To extract the data from OHS tables, use the Table extraction type.
    • To extract delta changes (Inserts, Updates, Deletes) from an OHS table, use the Table CDC extraction type.

Extract Data from Extractors

Alternative for the Datasources/Extractors [SAPI] provider context:
To extract data from Extractors, use the DeltaQ extraction type.

odp-abap-cds

odp-abap-cds

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 Table extraction type.
  • To extract delta changes (Inserts, Updates, Deletes), use the Table CDC extraction type.
Last update: June 28, 2025
Written by: Rajesh Malapati, Valerie Schipka