Caution: For some destinations (e.g. Oracle, DB2, Teradata, Exasol etc.) the appropriate driver must be installed. Refer to Requirements.

Xtract Universal allows to extract data from SAP ERP and BW systems and to load them to different destination environments, including:

Database / Datawarehouse:

Business Intelligence / Analytics Tools:

Analytics & ETL Tools:

Business Systems:

Cloud Storage:

Generic Destinations:

  • CSV (via HTTP)
  • OData (e.g. for PowerPivot, PowerQuery, Datazen and Tableau)
  • Flat File - CSV (comma-seperated values)

Pull and Push Destinations

The destinations are divided into two categories, depending on where the extraction process is started.

Pull Destinations

Pull destinations provide the data on request. The extraction process is started by the destination product environment. These include the following destinations:

  • CSV (via HTTP)
  • OData
  • Qlik
  • Alteryx

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
All remaining Destinations are Push Destinations, that provide the data to the destination environment proactively. The extraction process is started in Xtract Universal, e.g. from a scheduled extraction.

Managing Destinations

Azure DWH

Azure BLOB Storage

IBM DB2

EXASolution

GoodData

Oracle

Alteryx

Alteryx Connect

Amazon Redshift

Amazon AWS S3

Salesforce

SharePoint

Microsoft SQL Server

Microstrategy

PowerBI (Cloud)

Power BI (Desktop)

SAP HANA

MySQL

Tableau

TeraData

HP Vertica

QlikSense & Qlikview

OData

Flat File - CSV

CSV (via HTTP)

XML (via HTTP) - deprecated