Xtract IS Table is a data source component for SQL Server 2005 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.

The image below shows a sample data flow created with Xtract IS. Two tables are ex-tracted before being merged in the data flow (purchase order headers and order lines). The dialog box shows the component editor that is fully integrated in Visual Studio 2005.

• Data extraction can be processed in packets to handle large amounts of data
• Asynchronous processing of data packets
• SSIS variables for dynamic WHERE statements
• Type safety and meta data support by 100% from SAP’s data dictionary