No magic: SAP knowledge transfer at the push of a button

Customer Need The need to access data from SAP has become a common scenario and is indispensable for the biggest companies in the world. In the past, the responsible people had to have at least a basic understanding of SAP to know where the data is stored in the SAP system. This could quickly become a showstopper, especially if the SAP knowledge is not available or the relevant people do not have the resources to support the business user. This is about to change! Automation The Xtract Business Content Manager (BCM) will do…continue reading →

How to build perfect SAP Integration using Xtract Universal and Kettle

In this blog I will show how to use Kettle to run SAP extractions created with Xtract Universal to load it into an Oracle Database. Xtract Universal is an SAP connector by Theobald Software, a leading vendor of SAP Integration products. Xtract Universal supports integration of your SAP data in the most different target systems, like SQL Server, Oracle, IBM DB2, Teradata, flat files and others – fast, straight-forward and user-friendly. Kettle (aka Pentaho Data Integration (PDI)) is an open source data integration (ETL) engine that allows the user to define data integration…continue reading →

How to schedule Xtract Universal extractions to load data from SAP

Xtract Universal supports integration of your SAP data in the most different target systems. After creating an extraction (Refer to the online help), you can run an extraction by just calling the command tool with the right parameters. As an alternative you can just call the correspondent URL that can be found in the Run Dialog (e.g. http://nbelzein:8065/?name=plants). We recommend to use the command line. In this blog I will show you how to schedule an Xtract Universal extraction that is as easy as calling the command line with the right parameters. Xtract…continue reading →

How to load SAP-data with Xtract Universal to Microsoft Access (and Excel)

Xtract Universal is since 2011 the newest member of the Xtract product line. Eight different SAP extraction types allow the BI architect to create an optimal, stable and fast data layer between SAP and different consumer applications. Xtract Universal essentially consists of two components: a server component and a designer (client). The server component is responsible for the actual extraction. The consumer application communicates with the Server component, and these in turn with SAP. You use the Xtract designer for the design and configuration of the extractions. In this blog, I will show…continue reading →