Alternatives for the ODP Extraction Type

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

Aside from the extraction types presented in this article, Xtract Universal 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.

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.

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.
  
• 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.

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.