Note: For some destinations (e.g., Oracle, DB2 etc.) the appropriate driver must be installed.

For more information on drivers, refer to Requirements.

Note: The configuration files of destinations are stored in config\destinations.

Xtract Universal allows to extract data from SAP (e.g., ERP, S/4 HANA, BW and BW/4 HANA) systems and to load them to different destination environments, including:

Databases / Data Warehouses #

Business Intelligence / Analytics / ETL #

Business Systems #

Cloud Storage #

Generic Destinations #

Pull and Push Destinations #

Two types of destinations is supported, depending on where the extraction process is started.

Pull Destinations

Extractions with pull destinations provide the 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
  • Qlik
  • 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.

Push Destinations

Extractions with push destinations provide the data to the destination environment proactively. The extraction process is started in Xtract Universal, e.g. from a scheduled extraction.
An extraction with push destinations involves the extracting of data from the SAP source systems and once loaded into the destination, data can be processed further. E.g. it can be transformed to an optimized form ready for analytic query workloads.

Managing Destinations

Flat File - CSV

Flat File - JSON

Web Service - CSV

Web Service - JSON

Web Service - OData

Alteryx

Amazon AWS S3

Amazon Redshift

Azure Storage

Azure DWH

EXASolution

Google Cloud Storage

IBM DB2

Microsoft SQL Server

Microstrategy

MySQL

Oracle

Parquet

PostgreSQL

Power BI Connector

QlikSense & QlikView

Salesforce

SAP HANA

SharePoint

Snowflake

Tableau