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:
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: 22.214.171.124.
“C:\Program Files\XtractUniversal\XtractUniversalCmd.exe” http://126.96.36.199: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: