Dump any SQL resultset to MS Excel

Abstract: Kettle's provides an Excel output step but you always need to manually configure its fields. Use this job to generate a transformation that dumps a SQL resultset to Excel on the fly, and execute that generated transformation immediately.

Authors: Roland Bouman

License: LGPL

Kettle versions:Kettle 3.2.0 and up

Attachments

• kexcetle.kjb - Kettle Job that takes parameters to specify JDBC connection info, an SQL statement text, and a directory and file for the excel file. Running it will dump the resultset of the SQL statement to the specified MS Excel file.
• gen-ktr.ktr - A Kettle transformation that takes parameters to specify JDBC connection info, an SQL statement text, and a directory and file for the excel file. Running it will generate a transformation called gen.ktr that actually executes the SQL statement and dumps the results to the specified Excel file
• ktr-template.ktr - A transformation template. This is used by the gen-ktr.ktr transformation as a basis for generating an actual transformation by injecting the necessary metadata about the field layout of the SQL resultset into the definition of the Excel output step to configure its fields

Download all

Background

No IT solution is complete as long as it can't dump data to excel.

...