Xtract IS

What is Xtract IS?

Plug’n’Play para SAP e SQL Server Integration Services

Integrate your mySAP or SAP BW system with SQL. With a few mouse clicks, you can bulk extract data with high performance and stability.

The Xtract IS Component Suite offers nine components to provide all types of SAP interface technologies. Deploy your data flows securely and with a graphical editor.

Table Xtract IS

·          Xtract IS Table is a data source component for SQL Server (SQL Server 2005-2014).

·          Allows you to extract mass data directly from SAP data tables.

·          To optimize system load and network traffic, only columns explicitly marked by the user are extracted.

·          You can also process virtually any WHERE claim to tailor the data to the user's needs.

Xtract IS Table Join

The table join component allows you to mix/merge multiple tables. You can join tables for document headers and items in a single result set.

Join-process takes place entirely within the SAP system, which does not require downloading of each table.

Xtract IS Query

SAP Query is as popular as data providers because tables can be associated at the end of SAP without any developer authorization. With Xtract IS Query, you can make your SAP queries directly available in integration services. With a graphical user interface and full metadata support, the result is available for further processing in a matter of seconds.

Xtract IS BAPI

With the Xtract IS BAPI component you can call BAPIs or RFC function modules directly from your SSIS data flow. By doing this, the component can be considered as a source, transformation, or target.

Scaling import and export parameters are read or stored from ssis variables. In-bound or outbound tables can be associated with a pipeline or static data. If individual module tables are not required, they can of course be ignored.

Xtract IS BW Cube

Xtract IS BW Cube is a data source for SQL Server (2005 – 2014) with which datasets can be extracted from SAP BW infobubs and BW Query.

Dimensions, key figures, and attributes to be transferred can simply be dragged to the query output. This transforms complex cubic data structures into relational data that is easy to handle.

Xtract IS Report

The Xtract IS report data source for SSIS allows you to use existing ABAP reports or ABAP programs as data sources within the SSIS data stream. This technique is often used in the AREA of FI/CO reporting.

With the Xtract IS Report component you can protect your investments, because existing logic does not need to be restructured, it can be reused.

The input values (selection options) are filled with values (SSIS variables, if necessary). With the help of a graphical tool, the report output is divided into columns that generates the query output for further processing.

Advantages with Xtract IS based on certified SAP technology

·          Minimal or zero change to your SAP system

·          Very fast installation and configuration

·          Very fast installation and configuration. Programming knowledge is not required

·          Cross-module and independent module

·          100% security with full meta-data support

·          Business logic is available

·          Robust, standardized process for incremental loads (Delta Logic)

·          Seamless integration for reading and writing

·          Cost savings through optimal integration without friction losses

ERPConnect-certified Xtract IS provides the kernel for all our products and is responsible for connecting to each SAP system.

SYSTEM REQUIREMENTS

SQL Server

SQL Server 2008 (all versions of SQL Server. Express Version does not include SSIS)

SQL Server 2008 R2

SQL Server 2012

SQL Server 2014

SQL Server 2016

SQL Server Integration Services (SSIS)

For development: Visual Studio (except express version) for Business Intelligence is required to create SSIS packages.

Supported SAP versions

SAP R/3 version 4.0B and higher or SAP ECC.

SAP S/4 Hana

SAP BW version 3.1 and higher.

SAP Authentication

Custom authentication.

SAP authentication: Single Sign On (SSO) or SAP credentials.

SAP system or user dialog with appropriate authority objects.

Operating system

Windows XP

Windows Vista

Windows 7

Windows 8

Windows 10

Windows Server 2003

Windows Server 2008

Windows Server 2008 R2

Windows Server 2012

• Windows Server 2012 R2

Other applications and Frameworks

.NET Framework 4 or higher.

 Visual C++ 2005 Runtime.

Librfc32.dll if SAP GUI is not installed.

Memory

At least 4 GB, depending on the volume of data, more space may be required.

Hard drive space

For installation, 30MB is required.

Network Settings

The ports below should be open depending on the SAP System where NN is the instantiation of the SAP System number.

SAP Application Server: Porta 33nn

SAP Message Server (Load Balancing): Porta 36nn

Secure Communication Network (SCN): Porta 48nn

SAP Router: Gate 3399