published by whitemice on Wed, 08/08/2012 - 00:00
Performing export-transform-load type workflows starting with XLS, delimited, of fixed-record length files using OpenGroupware Coil's Integration Engine is simple; just define the format using a Format Definition and perform a read action. After that the resulting StandardXML can be channeled into your RDBMS using sqlInsertAction, sqlUpsertAction, etc... Such straight forward ETLs are almost trivial.
