Blue data strands that symbolize the Xtract IS for Azure SAP interface from Theobald Software.
Xtract IS logo by Theobald Software.
Integrate SAP data seamlessly into SSIS

Xtract IS – Your Powerful SSIS SAP Connector

Connecting SAP systems to SSIS is a crucial step for successful ETL and data integration processes. With Xtract IS, this task becomes effortless: the solution enables the efficient extraction and utilization of your SAP data within SSIS-based ETL processes.

XtractIS supports you in integrating SAP data into SSIS by:

  • Master Data Extraction
  • Transaction Data Processing
  • Mass Data Extraction
  • IncrementalData Loads

The direct connection to SQL Server Data Tools (SSDT) allows you to model SAP data with full metadata support, a graphical editor, and drag-and-drop functionality – without programming or complex scripting.

Your Advantages With Xtract IS

15x faster loading times

through optimized extraction processes (Symrise AG).

Time saving

Very fast installation and configuration.

Incremental loading

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

More Highlights:

  • Cross-module and module independent
  • Minimal to zero modification in your SAP system
  • Business logic is available
  • Cost savings through optimal integration, no friction losses
  • Central monitoring and process monitoring for complete control of SAP access
  • Fast, simple & user-friendly; programming knowledge not necessary
  • Central security concept
Logo of Xtract IS, an SAP interface from Theobald Software.
SAP-Integration in SSIS

Use SAP Data Intelligently and at Scale

With the XtractIS Connection Manager, your SAP system becomes an additional data source accessible through Xtract IS. By integrating the Xtract IS tools into the native SSIS toolbox, your development workflow remains unchanged, and SAP data can be seamlessly processed alongside other SSIS tools.

Developers work as usual in SQL Server Data Tools (SSDT), while administrators deploy, monitor, and automate SSIS packages containing SAP data flows just like any other ETL pipelines.

SQL Server logo.
Infographic showing the architecture of Xtract IS, an SAP interface from Theobald Software.

Development and data architecture benefit from:

  • Seamless SSIS Integration: Xtract IS appears directly in your SSIS toolbox, allowing SAP data to be used in data flows via drag & drop.
  • High Performance & Delta Loading: Large volumes of data are extracted quickly, transferring only changes (deltas) instead of entire tables.
  •  Minimal SAP System Impact: Getting started requires little tono SAP modifications, reducing risk and administrative effort.
  •  Modular & Flexible: Various extraction components (tables, BAPIs, queries, reports, BW cubes) cover a wide range of scenarios.
  • User-Friendly & Dynamic: Configuration is done via a UI without programming skills; filters and conditions can be dynamically controlled using SSIS variables.

Lorem Ipsum test test test

Example Text

Short response times gives us a significant competitive advantage. Xtract IS makes an important contribution to this, because we can integrate decision-relevant data from SAP into our SQL server-based analysis systems quickly and automatically.

Senior Developer IT Business Intelligence Solutions, PUMA SE

Full table extractions have changed significantly with Xtract Universal. For certain tables, we’ve seen a 15x improvement in loading times — an impressive gain. Now, we can provide data much earlier, update it more frequently, and significantly increase the value for our applications and reporting solutions.

Dr. Christian Koch, Head of Data Engineering & Analytics, Symrise AG

By being able to perform delta loads instead of full loads with Table CDC, we can update our SAP data stocks more frequently in the future, even in near real-time if necessary. Instead of reloading a table with 30 million rows each time, we now only update about 1,000 rows that have changed. Instead of an hour, the loading process now takes only a few minutes.

Andreas Bliss, Manager Data & Analytics Platform, Covestro Deutschland AG
Demo Download

Get Your 30-Day Trial Version

helper icon
Vanessa
FAQ

Frequently Asked Questions About SSIS, SAP Integration, and Xtract IS

HelpCenter & Support

Still Have Questions?

If you'd like to learn more, visit our Help Center – you'll find answers to many common questions there.
Prefer to talk to someone directly? Get in touch, we're happy to help.