Introduction to SAP HANA Direct Extractor Connection (DXC)
In many cases, data from different areas in SAP systems requires application logic to appropriately represent business documents.
SAP Business Content DataSource Extractors have been available for many years as a basis for data modeling and data acquisition for SAP Business Warehouse; now with DXC, these SAP Business Content DataSource Extractors are available to deliver data directly to SAP HANA.
DXC is a batch-driven data acquisition technique; it should be considered as a form of extraction, transformation and load although its transformation capabilities are limited to user exit for extraction.
SAP ECC source system has its own BW system embedded in it (provided in version of Netweaver 7 and up)
Usually, this embedded BW system inside SAP Business Suite systems is not utilized, as most customers have BW installed on separate server.
With DXC, SAP utilize the scheduling and monitoring features of embedded BW system, but do not utilize its other aspects such as data warehousing or reporting.
DXC extraction is different from normal dataflow, and instead sends data to SAP HANA using HTTP connection.
An Advanced DSO of type standard DSO is generated in SAP HANA, which has same structure as the Datasource.
The data gets stored in this adso and activated which can be further used to build hana models.
Note: DXC does not require BW on SAP HANA. Also with DXC, data is not loaded into the embedded BW system. Instead, data is redirected into SAP HANA.
Both the SAP Web Dispatcher and XS Engine components must be installed in SAP HANA to utilize DXC.
Limitations of DXC
- Version of SAP ECC should be Netweaver 7 or higher
- Datsource must have a key field defined (one can use stored procedure to define key if it is not defined)
- certain datasources may have specific limitations
- some datasources are not delta enables, this is not an issue with DXC but it is point to consider
DXC provides a way to use Business content datasources and build solutions quickly in HANA from ECC data using these extractors.
These business content datasources provide advantage of delta capabilities, enhancing structures using append field, transformation of data and data extraction in batch of mass data volumes.