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 https://theobald-software.com/en/xtract-universal/

or the online help: https://help.theobald-software.com/en/xtract-universal

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.

Step 4: Check the result in the Oracle database.

Check the table created in the oracle database:

and the SAP data loaded to the Oracle table:

Written by Khoder Elzein

Khoder is responsible for presales and always has an attentive ear for our customers, prospectives and partners. When travelling in Germany or abroad, he provides customer support at PoCs, workshops and on training courses. He also looks after the further development of our software solutions. Khoder has been working in IT since the turn of the millennium; he has been a member of team Theobald since 2009. When it comes to private interests, family, nature and reading feature at the top of his list – along with innovative fusion cuisine, as you may infer from his favourite dish of Swabian cheese noodles with tabouleh.