Khoder Elzein's Blog: 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 jobs and transformations.

Step 1: Create an SAP extraction in Xtract Universal to load it into Oracle. In the first step I will create an SAP extraction based on an SAP query.

The destination is an Oracle database.

The Oracle database runs on the localhost:

The table on the Oracle Database will be automatically created.

For more information watch the videos on http://www.theobald-software.com/en/download/xtractuniversal.htm or the online help: http://help.theobald-software.com/TheobaldSoftwareGmbH/default.aspx?pageid=xtract_mt&skin=Xtract_U_EN&product=Xtract%20Universal

Step 2: Create a batch file to call the Xtract Universal extraction Xtract Universal Command line tool allows running an Xtract Universal extraction. Create a batch file with following line. Xtract Universal server is installed on a remote machine with the IP: 54.221.193.235.

"C:\Program Files\XtractUniversal\XtractUniversalCmd.exe" http://54.221.193.235:8065/?name=demo

Step 3: Use Kettle to run the Xtract Universal extraction Create a new Kettle Job. Add the shell script component. Set the field Script file name to the path of the batch file:

Execute the Kettle Job:

The job has been successfully executed. The destination table in the Oracle database is created with 21 columns. 5930 rows are inserted, as you can see in the log.