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.
| 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 Xtract Universal, 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 BWCube extraction type or the Table extraction type.
-
Extraction via 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 Table extraction type.
-
Extraction via 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 BWCube 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.
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.
Author(s): Rajesh Malapati, Valerie Schipka