Skip to content

Alternatives for the ODP Extraction Type

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

Aside from the extractions types presented in this article, Board Connector will offer ODP via OData protocol. The OData connectivity is currently in development and scheduled to be released in Q4 2024. For more information, see Guidance on SAP Note 3255746 for Theobald Software Xtract Products.

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

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 extraxt 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: September 13, 2024
Written by: Rajesh Malapati, Valerie Schipka