Xtract IS

Xtract IS is a component suite that provides Plug'n'Play functionality with SAP and SSIS.

Xtract IS Component Suite offers nine components to provide all kinds of SAP interface technologies. You can also implement your data flows in a secure and type-safe way with a graphical editor.

Xtract IS Components:

Xtract IS Table
Xtract IS Table is a data source component for SQL Server Integration Services. It lets you extract mass data directly from SAP data tables. To optimize the system load and network traffic, only the columns explicitly marked by the user are extracted. It is also possible to process nearly any WHERE statement to suit the data to the user’s needs.

Xtract IS BAPI
With the Xtract IS BAPI component you can call BAPIs or RFC function modules directly from your SSIS data flow. In doing so, the component can be regarded as a source, trans-formation or target. Scalar import and export parameters are read or stored from the SSIS variables. The in-bound or outbound tables can each be linked with a pipeline or static data. If individual module tables are not needed, they can be ignored.

Xtract IS Query
SAP queries are so popular as data suppliers because tables can be joined on the SAP end without any developer authorization. With Xtract IS Query, you can make your SAP queries directly available in the Integration Services. With a graphical user interface and full meta-data support, the result is available for further processing within seconds. As with every SAP query, variants can also be applied here. Alternatively or in addition, it is also possible to fill the selection screen with your own selection values The variant and all selection parameters can be dynamically entered via SSIS variables.

Xtract IS BW Cube
Xtract IS BW Cube is a data source for SQL Server 2005 Integration Services with which datasets can be extracted from SAP BW InfoCubes and BW queries. The dimensions, key figures and attributes to be transferred can simply be dragged and dropped into the query output. This turns complex, cubic data structures into relational data that are easy to handle.

Xtract IS OHS
Compared to traditional BW extraction via the OLAP API, the Open Hub Services (OHS) were developed by SAP so that the extraction of BW data could be made available for further electronic processing instead of just pure reporting.

Xtract IS OHS component supports all of the possibilities inherent to OHS extraction:

• Extremely large data volumes through packaging and asynchronous background processes
• Delta extracts
• Not just cubes, but also InfoObjects, ODS objects, texts etc.
• Extraction definition with the help of InfoSpokes (BW 3.5) or data transfer processes (BI 7.0)

Xtract IS Hierarchy
It makes it possible to extract all hierarchy types from the BW.

Xtract IS BW Loader
With the Xtract IS BW Loader data target, you can reroute data streams within your SSIS data flow directly in your SAP BW system.The corresponding BW InfoPackage is automatically triggered and filled in. The component is based exclusively on the required SAP standard (staging BAPIs for third-party vendors).

Xtract IS Report
Xtract IS Report data source for SSIS allows you to use existing ABAP reports or ABAP programs as data sources within the SSIS data flow. This technique is often used in the area of FI/CO reporting. In a lot of cases, a comprehensive pool of such reports has accu-mulated over the years and simply cannot be replaced or reengineered. With the Xtract IS Report component you can protect your investments because existing logic doesn’t have to be reengineered—it can simply be reused.

Xtract IS DeltaQ
Xtract IS DeltaQ component forms the top class of the BI components for SAP access by SSIS. With its help, the Extractor API in SAP R/3 can be addressed and in such, the functionality with which BW systems also secure their data supply from the production system can be used:

• Real transaction-secure delta transfer of data
• Support of all master and variable data including own generic extractors
• No installation in SAP required
• All business contents are available immediately even though no application-specific knowledge (e.g. about the tables' structure) is required.

Xtract IS Licenses

Xtract IS is licensed per customer site. An unlimited number of SAP systems and developers is covered and all licenses include six months of support via email, phone and update subscription.

Xtract IS Professional License includes: Xtract IS Table and Xtract IS Query

Xtract IS Enterprise License includes: Xtract IS Table, Xtract IS Query, Xtract IS BW Cube and Xtract IS BAPI

Xtract IS Extended Enterprise License includes: Xtract IS Table, Xtract IS Query, Xtract IS BW Cube, Xtract IS BAPI, Xtract IS BW Loader and Xtract IS Open Hub Service

Xtract IS Ultimate License inlcudes: Xtract IS Table, Xtract IS Query, Xtract IS BW Cube, Xtract IS BAPI, Xtract IS BW Loader, Xtract IS Open Hub Service, Xtract IS Hierarchy, Xtract IS DeltaQ, Xtract IS Report