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 correspondent URL that can be found in the Run Dialog (e.g. http://nbelzein:8065/?name=plants) In this blog I will show you how to schedule the run of the Xtract Universal extractions that is as easy as calling a URL. Xtract Universal delivers the command tool XtractUniversalCmd.exe (to be found in the installation folder, e.g. C:\Program Files\XtractUniversal) to run an extraction using the cmd.…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 →