Alternatives for Xtract ODP
The following article shows how to replace most Xtract ODP provider contexts with other components.
Aside from the components presented in this article, Xtract for Alteryx offers the Xtract ODP (OData) component that enables users to extract ODP data via OData protocol. For more information, see Guidance on SAP Note 3255746 for Theobald Software Xtract Products.
| Provider Context | Alternative |
|---|---|
| ABAP Core Data Services [ABAP_CDS] | Xtract Table |
| HANA Information Views [HANA] | Xtract Table Xtract Cube |
| SAP NetWeaver Business Warehouse or BW4/HANA [BW] | Xtract Cube Xtract Table |
| Datasources/Extractors [SAPI] | - |
| SAP LT Queue Alias [SLT~your_queue_alias] | Xtract Table |
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.
Note
When looking up CDS Views in Xtract for Alteryx, 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 Xtract Cube component or the Xtract Table component.
-
Extraction via Xtract 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 Xtract Table component.
-
Extraction via Xtract Cube
- In SAP, expose the HANA View to CompositeProviders, see SAP Learning: Consuming a Calculation View with SAP BW/4HANA
- Extract the CompositeProvider using the Xtract Cube 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 Cube 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.
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.
Written by: Rajesh Malapati, Valerie Schipka