This morning I stumbled upon a SAP import script written in my Integration Tag Language. The script is a little gem, it is probably written about 2008.
The script includes all code needed exporting data from a SAP rfc function into Mysql (including defining an import table in Mysql. I have removed parts not necessary for showing the complete export process from beginning to end.
The script starts defining the workflow, run time parameter and symbolics:
(The run time parameter sap points to a SAP system.)
Next we have two jobs truncate & getSapData:
1 Truncate the result table if it exists (only for full load)
2 GetSapData (the little gem)
This job is packed with relevant and succinct logic for SAP data extraction.
(I added some comments for your convenience.)
That’s it.
The script is a complex parallel process expressed in concise and well defined code.
I have not written the script myself, but I’m proud of the Integrated Lag Language (ITL) which I wrote in 2006 that makes this script possible.
If you have a better way of importing data from SAP, please drop me a note.
If you are the script author you must give me a call🙂
