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 #

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 #

Business Systems #

Cloud Storage #

Generic Destinations #

Note: The configuration files of destinations are stored in C:\Program Files\XtractUniversal\config\destinations.

Pull and Push Destinations #

There are two types of destinations, depending on where the extraction process is started.

Pull Destinations

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:

  • Alteryx
  • CSV web service
  • JSON web service
  • Qlik
  • Power BI connector
  • SSRS

Push Destinations

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.