Green data strands that symbolize Xtract Universal, a SAP interface from Theobald Software.
Logo from Xtract Universal, an SAP interface from Theobald Software.
SAP integration with universal destination environments

Xtract Universal – Fast and
Simple SAP Data Integration

With Xtract Universal, SAP data is transferred quickly, reliably, and automatically to where it’s needed — whether in databases, analytics platforms, BI tools, or cloud solutions.

Thanks to its high level of automation, this happens within a short amount of time. The stand-alone solution operates independently of anyexisting ETL or data warehouse systems and integrates easily and seamlessly into any data strategy.

Various SAP source connectors enable access to all relevant SAP data, regardless of where it is stored or in what format it exists.

An image of a desktop screen displaying Theobald Software's interface

Lorem Ipsum test test test

Example Text

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
Overview

The benefits of using Xtract Universal

15x faster loading times

through optimized extraction processes (Symrise AG).

Time saving

Very fast installation and configuration.

Incremental loading

and capture changes in near real-time thanks to Table CDC.

And also...

  • SAP to Snowflake, Amazon Redshift, Amazon S3 and more.
  • Quickly install and set up your new processes, no code required.
  • Integrate your SAP system into a new destination, without fear of harming your original data.
  • Ensure the security of your SAP with central and process monitoring.
  • Save money through our optimal integration solution.
  • Instantly collect and organize data from multiple sources into a central repository.
  • Keep your data secure in a single central location.
  • Interact with your database using business logic.
Logo from Xtract Universal, an SAP interface from Theobald Software.
SAP integration with universal destination environments

Unleash the power
of your SAP data

Xtract Universal offers proven SAP extraction capabilities, just like our other Xtract products such as Xtract for Alteryx or Xtract IS.

With the Xtract Universal Designer, you can connect to one or multiple SAP systems and configure SAP data extractions in just a few clicks - no coding or scripting required. Data preview and logging functionality assist in the development of the various SAP data extracts.

After extracting data from SAP, you can directly integrate it into the target environment of your choice - from database systems and cloud storage to BI and analytics solutions.

Infographic showing the components of Xtract Universal from Theobald Software.

With Xtract Universal, you can:

  • Flexibly modify SAP data extractions, add new data elements, and feed data into other destinations - no need for costly and time-consuming ABAP programming.
  • Process mass data and incremental updates
  • Execute, automate, and monitor multiple extractions in parallel.
  • Control access rights thanks to built-in security features.

The Table CDC component (Change Data Capture) additionally enables:

  • Near real-time synchronization and replication of your SAP data
  • Near real-time capture of changes and reliable transfer to destinations such as cloud or database storage
  • Efficient data replication, cloud migrations, and analytics/AI applications reliably and without downtime

The component can be seamlessly integrated into your existing Xtract Universal installation.

Features & Components

What Xtract Universal Can Do:

SAP BW Cube or QuerySAP BW Cube or Query
BW Cube
BW Cube

Maximum flexibility in BW data extraction

The BW Cube component implements SAP’s OLAP BAPI interface (MDX) as well as the native BICS interface. It is therefore possible to extract traditional BW objects, such as BW or BEx queries, cubes, and MultiProvider. At the same time, the component supports both the new HANA-based BW objects and the objects of an S/4HANA embedded BW. The BW Cube component supports BEx variables and dimension filtering, thus enabling the extraction of large amounts of data with a packetizing and slicing function.

SAP QuerySAP Query
SAP Query
SAP Query

Directly extract SAP ERP queries from the SAP system

The Query component lets users extract SAP ERP queries right from the SAP system. There is no need to tediously recreate existing queries and their respective business logic outside of SAP, because you can simply continue using them instead.

Table CDCTable CDC
Table CDC
Table CDC

Incremental SAP data loading: Fast & easy

This component is our champion when it comes to mapping data or changes in your SAP system in near real time and as easily as possible. Data from different data sources is integrated to consolidate all changes in one central system. Unlike a full data load, where all records in a table are transferred from the source to the target database, Table CDC captures only the changes to the data since the last load. This reduces the amount of data that needs to be transferred, resulting in faster and more efficient transfers. This ensures that you always have access to the latest and most up-to-date data, saving resources and time.

By incrementally capturing data changes, CDC also enables faster replication of data between different databases or systems. When only the changed data needs to be transferred, rather than the entire table, data changes can be updated in other systems in near real-time.

SAP Table or ViewSAP Table or View
Table
Table

Extract SAP tables – fast, flexible, and effortless

Reliable, high-performance extraction of SAP tables (transparent tables, cluster tables, and views) is easier than ever before thanks to the Table component.

This component comes with our custom ABAP package for table extraction but also supports standard SAP function modules. What´s more, joining SAP tables prior to extraction via Open SQL statement is also possible. This replaces the need for manually creating views or SAP queries on the SAP side.

RFC Function Module or BAPIRFC Function Module or BAPI
BAPI
BAPI

Call BAPIs and RFC function modules with ease

With the BAPI component, it is possible to call BAPIs and RFC function modules. At the same time, the component can be used as both the data source and—depending on the Xtract product—the target (data write-back). Users can extract or populate the BAPI’s import/export and table parameters.

BW HierarchyBW Hierarchy
Hierarchy & Open Hub Service
Hierarchy & Open Hub Service

Extract hierarchies from SAP BW – high-performance, flexible, delta-capable

The Hierarchy component makes it possible to extract hierarchies from an SAP BW system. At the same time, this component gives users the option to extract the data in its original parent/child format. The hierarchies can also be broken up, however, and the individual hierarchy levels extracted as column headers in a flat table.

Through Open Hub Services (OHS), SAP provides an extraction method for a range of BW source objects. OHS is a particularly interesting choice when it comes to exporting mass data from SAP BW and provides an integrated delta mechanism when using SAP DTPs. Theobald Software supports the OHS component for BW/4 HANA as well.

ABAP ReportABAP Report
Reports
Reports

Use ABAP reports as a data source

This component makes it possible to use ABAP reports as a data source. This guarantees the extraction and thus continued use of existing, customer-specific ABAP reports or of standard reports provided by SAP. Users can simply adopt existing reports and their respective business logic instead of wasting time to recreate them outside of SAP.

Delta QDelta Q
Delta Q
Delta Q

The gold standard for SAP data extraction

These components are the crème de la crème when it comes to extracting data from SAP. With the help of the DeltaQ component, users can extract what are known as SAP DataSources. The main benefit of DataSources is the integrated mechanism for incremental data extraction — a function also employed by SAP BW.

DeltaQ and ODP enable the use of DataSources and thus eliminate the need for an SAP BW. The ODP component is Theobald Software’s response to the new SAP ODP extraction types. This component can also be used to extract SAP DataSources, as well as CDS views, BW/4HANA objects, and other data sources.

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.

Prefer to talk to someone directly? Get in touch, we're happy to help.

Demo Download

Get your 30 days trial version now

helper icon
Vanessa