webenq4_reporting

Scripts and documentation for reporting in webenq4 including etl-scripts

Tools

• datamodel tool: SQL Power Architect
• etl: Pentaho

Working with ETL scripts

• Install the Pentaho Data Integration suite
• Clone this repository
• Add the settings from /etl/kettle.properties to ~/.kettle/kettle.properties and adapt to indicate your database
• Start Spoon and define a file-based repository with the /etl directory of this repository as the base