I have several tables in a Postgres database (Order Data, Duty Rates, VAT Rates, Organization Lookup, etc.). I want to export each of these to an Excel file which I will use later for analysis. I have been trying all day to do this in one transform, but there have been all kinds of Java errors. Do I need to have a separate transform for each table? and can I write multiple sheets to one excel file? I know the Excel Writer configuration and help files "look" like this can be done, but I am losing confidence in this Pentaho platform.
My colleagues are recommending I use Tableau Prep instead. They finished in less than an hour what has taken me a week and still cannot do with Pentaho.
The workflow goes:
- extract data from EDW
- combine EDW data with lookup tables from a few different databases
- export those data to Excel file for Pivots, charts etc.
Pretty simple stuff but very messy in Pentaho