Welcome to the Online Help for Xtract IS.

Xtract IS is a plug-in for the SQL Server Integration Services (SSIS). Xtract IS allows extracting data from SAP systems and writing data to SAP systems.

Available Components #

The Xtract IS offers you a total of 10 different Data Flow components for the SQL Server Integration Services.

XIS-Architecture

The overview below depicts the types of the Data Flow components.

Name Data Flow Component Type
BAPI Transformation
BW Cube Source
BW Hierarchy Source
BW Loader Destination
DeltaQ Source
ODP Source
Open Hub Services (OHS) Source
Query Source
Report Source
Table Source

Extraction Types #

  • BAPI accesses BAPIs and RFC function modules.
  • BW Cube extracts data from SAP BW InfoCubes and BEx Queries.
  • BW Hierarchy extracts Hierarchies from an SAP BW / BI system.
  • BW Loader loads data into SAP BW systems.
  • DeltaQ extracts DataSources (OLTP) and extractors from ERP and ECC systems.
  • ODP extracts data via the SAP Operational Data Provisioning (ODP) framework.
  • Open Hub Services (OHS) extracts InfoSpokes and OHS destinations.
  • Query extracts ERP queries. Note: not BEx queries supplied by BW Cube.
  • Report extracts ABAP Reports.
  • Table extracts data from SAP tables and views; allows joining several tables on the SAP side.
  • Table Join - allows to join several SAP tables. The Join-process takes place entirely within the SAP system without downloading single tables.
    Note: obsolete component! Use Table component instead.

The online help for Xtract IS consists of the following sections:

Introduction to Xtract IS

Xtract IS for Azure

SAP Connection

Xtract BAPI

Xtract BW Cube

Xtract BW Hierarchy

Xtract BW Loader

Xtract DeltaQ

Xtract ODP (Operational data provisioning)

Xtract OHS (Open Hub Service)

Xtract Query

Xtract Report

Xtract Table

Xtract Table Join

The BI Notification Server

SAP Customizing