Xtract Universal allows you to extract data from SAP systems and load them to different destination environments. The following destinations are available:
Databases / Data Warehouses #
- Amazon Redshift
- Azure Synapse Analytics (SQl pool)
- Azure SQL Database
- IBM DB2
- SAP HANA
- SQL Server
Note: For some destinations e.g., Oracle and DB2 the appropriate drivers need to be installed. More information can be found under the Requirements section of each destination.
Business Intelligence / Analytics / ETL #
- Power BI connector (Cloud/Desktop)
- Qlik (QlikSense and QlikView)
- KNIME Integration via SAP Reader (Theobald Software)
Business Systems #
Cloud Storage #
Generic Destinations #
- CSV web service (via HTTP)
- JSON web service
- Flat File - CSV (comma-seperated values)
- Flat File - JSON
Note: The configuration files of destinations are stored in
Pull and Push Destinations #
There are two types of destinations, depending on where the extraction process is started.
Extractions with pull destinations provide data on request. The extraction process is started by the destination product environment.
An extraction with pull Destination supports the pass-through of data. When a consumer (e.g. a Self Service BI Tool) requests the data, Xtract Universal translates the request into a query for the underlying SAP system, retrieves the data directly from the source system and delivers that to the consumer.
These include the following destinations:
- CSV web service
- Power BI connector
- OData web service
If the destination supports the gzip http data compression, Xtract Universal will send the data to the destination client in a gzip compressed format.
Extractions with push destinations provide the data to the destination environment proactively. The extraction process is started in Xtract Universal, e.g. via a scheduled extraction.
An extraction with push destinations extracts data from the SAP source systems and loads them into the destination, where the data can be processed further. They can be transformed and optimized for analytic query workloads.