Hi, I am new to cloveretl. How do we create and generate reports other than excel on CloverETL? we have MySQL database. is there a BI server for analytical reports? we are in the process of deciding open source ETL. I think Pentaho can do dashboards and it has BI server, web reports, etc. But our company is going with CloverETL.
CloverETL is primarily a tool for data manipulation. It can implement business rules that extract information from source systems and transform it to business knowledge. Apart from Excel file, CloverETL can create HTML, Text, and XML and CSV outputs of your data using the StructuredWriter or the XMLWriter components.
Anyway, CloverETL GUI is an Eclipse plugin and thus “embeddable” into any other Eclipse application, e.g., an application providing a nice graphical layout to your report.