Difficult made easy by Theobald

Make your SAP data easy to access in Reporting Services without additional interface layer with Xtract RS.

SAP und SharePoint nahtlos verbinden

Xtract RS

Display SAP data with Microsoft Reporting Services and Power BI Report Server

Xtract RS Screenshot
General

Xtract RS can be seamlessly integrated into the Microsoft Business Intelligence Development Studio and the Microsoft Reporting Services Server as a data extension.

SAP tables (direct or as an aggregated join), SAP queries, RFC function modules and BAPIs as well as BW objects (cubes, queries and master data) all can be used as data providers. Dynamic variables and parameters are also possible. True to our motto < Difficeasy > Xtract RS is naturally easy to work with – no programming knowledge required. And single sign-on ensures user-specific and secure access to SAP.

download

Xtract RS

Unleash the power of your SAP data

How it works

Xtract RS is our tool for the report developer in Microsoft Reporting Services (SSRS) as well as in Power BI Report Server. Whether you are looking to integrate SAP sales, finance, procurement, material or employee data into your reports, with Xtract RS you will have SAP data at your fingertips.

For the report developer, this means you can continue to work in your familiar environment – the SQL Server Data Tools (SSDT) - to connect to one or more SAP systems, including SAP ERP or SAP BW, and to design and preview your reports with SAP data. Everything you need to tap into your SAP data sources is right where you need it – no need for another tool or cumbersome data transfer procedures. The provided SAP source components are available inside the Graphical Query Designer. Simply select and configure an SAP data source with a few mouse clicks - no coding or scripting required.

For the Reporting Services administrator, this means that report deployment, scheduling and monitoring of reporting related jobs is no different from other reporting solutions.

Your SAP data connections can be easily modified in the Query Designer to include new data elements or data from different SAP modules to accommodate your changing business requirements. No need for expensive and time-consuming ABAP coding cycles.

Xtract RS can be seamlessly integrated into the Microsoft Business Intelligence Development Studio and the Microsoft Reporting Services Server as a data extension.

SAP tables (direct or as an aggregated join), SAP queries, RFC function modules and BAPIs as well as BW objects (cubes, queries and master data) all can be used as data providers. Dynamic variables and parameters are also possible. True to our motto < Difficeasy > Xtract RS is naturally easy to work with – no programming knowledge required. And single sign-on ensures user-specific and secure access to SAP.

Make it easy
Xtract RS Screenshot

Xtract Universal & Xtract IS

We have something ELSE to offer you …

Do you want flexibility when sending your SAP data to the cloud or other destinations?
With the Xtract Universal stand-alone solution, your data reaches any cloud environment, database, or analytics or BI solution securely and reliably.

You are not only at home in the Microsoft universe when it comes to cloud environments?
Then use Xtract IS—SAP data can be easily extracted and conveniently integrated into any SSIS-supported process with its clever interface.

To the product
Loading...

Functional SAP interfaces

Your advantages with
Xtract RS
  • Based on SAP certified technology*

  • Real time reporting with SAP data without any delay

  • No redundant data storage

  • Single Sign-On-Scenarios available with total maintenance of SAP security

  • Any data sources from SAP ERP and SAP BW are available

  • Full integration in Reporting Services Designer as a part of the SQL Server Data Tools (SSDT) for Visual Studio.

  • Entire compatibility to all SSRS-Features like Subscriptions, Report-Parameter, Shared Data Sources etc.

*Our SAP certified product ERPConnect provides the kernel for all our products and is responsible for the connection to each SAP system.

download

Frequently asked questions

Useful facts about
Xtract RS

Xtract RS is based on our SAP certified product ERPConnect.

For detailed requirements, please have a look at our OnlineHelp.

Xtract RS is licensed per server. It is independent if our software will be installed on a productive or a non-productive server environment. In both cases a full license is required.

Every license comes with six months of maintenance. Apart from technical support via phone or email, this also includes updates for all versions that are released within this period. After the six-month maintenance period is over, an additional year of maintenance can be purchased for 20% of the license fee.
There is no right for updates after expiration of maintenance.

Yes. We provide the consulting you want and need. From a single-day workshop up to a complete interface solution. Please contact us at info@theobald-software.com.

If you can’t find an answer here, please write to us at support@theobald-software.com.

download
These components will help you to achieve your goals!

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.

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.

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.

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.

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.

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.

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.

If you can’t find an answer here, please write to us at support@theobald-software.com.

download