PLEASE NOTE: This documentation applies to an earlier version. For the most recent documentation, visit the Pentaho Enterprise Edition documentation site. |
The ETL Metadata Injection step is capable of injecting step metadata into a template transformation. So instead of statically entering ETL metadata in a step dialog, you pass it at run-time. It is possible to solve repetitive ETL workloads like loading of text files, data migration and so on.
The following steps support Metadata Injection:
Step | Version | Fields Supporting Metadata Injection |
---|---|---|
5.1 | All fields | |
4.1 | See CSV File Input for a list of supported field | |
5.1 | All fields | |
4.1 | See Fixed File Input for a list of supported field | |
5.0 | See Get Data from XML for a list of supported field | |
5.1 | All fields | |
5.0 | All fields | |
5.2 | All fields | |
5.0 | See Microsoft Access Input for a list of supported field | |
4.1 | See Microsoft Excel Input for a list of supported field | |
5.1 | See Microsoft Excel Output for a list of supported field | |
5.3 | See Microsoft Excel Writer for a list of supported field | |
5.0 | All fields | |
5.1 | All fields | |
4.2 | See Row Denormaliser for a list of supported field | |
4.2 | See Row Normaliser for a list of supported field | |
4.1 | All fields | |
5.0 | All fields | |
5.0 | See Split Field for a list of supported field | |
5.2 | See Table Input for a list of supported field | |
5.1 | See Table Output for a list of supported field | |
5.0 | All fields | |
5.2 | All fields | |
5.2 | All fields |
Since version 5.1 this step is capable of streaming data from one transformation into another.
To pass data from your template transformation (after injection, during execution) to your current transformation, specify the "Template step to read from". You can also specify the expected output fields so that it's easier to design the steps which come after the ETL Metadata Injection step.
To pass data from a source step into the template transformation (again, after injection) you can specify the "Streaming source step" and the "Streaming target step" in the template transformation.
http://diethardsteiner.blogspot.com/2011/07/metadata-driven-etl-and-reporting.html
http://www.ambientbi.co.uk/?p=634