Difficult made easy by Theobald Software

With Xtract for Alteryx it’s all just plug ‘n’ play when it comes to using your SAP data in Alteryx.

SAP und SharePoint nahtlos verbinden

SAP integration with Alteryx

Integrate SAP data in the Alteryx data flow

Xtract for Alteryx Screenshot
General

Xtract for Alteryx is embedded in the Alteryx Designer. This enables data from the SAP system to be easily integrated into the data flow of your Alteryx solution.

Select from different types of SAP connectors in Alteryx Designer Tool Palette to design your workflows and applications for SAP with ease. This can involve the extraction of mass data directly from one or more SAP tables or the extraction of data from SAP BW InfoCubes or BEx queries. In addition, you can easily access SAP DataSources (BW extractors), CDS views, BW/4HANA objects, hierarchical data and other data sources.

Free trial

SAP integration with Alteryx

Unleash the power of your SAP data

How it works

Xtract for Alteryx is our tool for the business analyst working with Alteryx Designer. Whether you are looking to integrate SAP sales, finance, procurement, material or employee data into your analytics solution, with Xtract for Alteryx you will have SAP data at your fingertips.

As part of our Xtract family, the product comes with the same, proven SAP data extraction capabilities as our other Xtract products. Xtract for Alteryx will show up in the Designer as a separate Tools group, where you can access different SAP data source components. Simply drag and drop any of the tools to your workflow design area and start working with it. 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. With a few clicks, you can connect to one or more SAP systems and configure your SAP data feeds - no coding or scripting required. Xtract for Alteryx supports both large volume SAP data ingestion as well as repeated, incremental SAP data feeds. Multiple SAP data extracts can run concurrently.

Your SAP data feeds can be easily modified in Alteryx 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 for Alteryx is embedded in the Alteryx Designer. This enables data from the SAP system to be easily integrated into the data flow of your Alteryx solution.

Select from different types of SAP connectors in Alteryx Designer Tool Palette to design your workflows and applications for SAP with ease. This can involve the extraction of mass data directly from one or more SAP tables or the extraction of data from SAP BW InfoCubes or BEx queries. In addition, you can easily access SAP DataSources (BW extractors), CDS views, BW/4HANA objects, hierarchical data and other data sources.

Make it easy
Xtract for Alteryx Screenshot
Hint other solutions

Xtract Universal

We have something ELSE to offer you…

Did you know that we offer two different ways of getting your SAP data into Alteryx securely?

As well as Xtract for Alteryx, our universal stand-alone solution Xtract Universal is the perfect trailblazer for your SAP data’s journey.

To the product
Loading...

Functional SAP interface

Your advantages with
Xtract for Alteryx
  • Based on SAP certified technology*

  • Very fast installation and configuration

  • Fast, simple, user-friendly; programming knowledge not necessary

  • Minimal to zero modification in your SAP system

  • Cross-module and module independent

  • Business logic is available

  • 100 % type safety with full meta data support

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

  • Central security concept

  • Cost savings through optimal integration, no friction losses

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

Free trial

Frequently asked questions

Useful facts about
Xtract for Alteryx

Xtract for Alteryx is based on our SAP certified product ERPConnect.

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

Xtract for Alteryx is licensed per desktop (either with or without scheduling) or 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.

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.

Every server on which you are going to install our software has to be licensed. It does not matter whether this server environment is used productive or non-productive. From our experience, we generally recommend an architecture of at least two independent servers. The reason for this is concerning the installation of updates and new features relating to other solutions in the overall architecture. There are many different factors like the version of each individual solution which could affect the functionality. This could have serious consequences, especially in a productive environment. Therefore, we strongly recommend the implementation of a second non-productive server in order not to endanger the stability of the productive environment, especially in terms of installing updates and new features. We would also like to point out that there are no questions about the functionality of Theobald Software’s own solutions, but rather the whole architecture with all the influencing factors has to be taken into account.

You can purchase Xtract for Alteryx either from us or directly from Alteryx and their resellers. Since there is an existing reseller agreement, there are no disadvantages for you.

If you can’t find an answer here, please visit our support portal.

Free trial
Trenner
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.

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.

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 visit our support portal.

Free trial