ETL transformation management

If transformation(s) of data going into EcoStruxure IT Advisor are needed this can be provide by our Professional Service Team.

The transformation(s) are executed using the Pentaho Data Integration (Kettle) engine. The transformations can be created and edited using the Spoon Tool

Once transformations are in place these are being executed by the Pentaho Data Integration (Kettle) Engine that are build into the IT Advisor server.

This requires the transformation file(s) to be transferred to the ITA server where they will automatically will be executed when located in the right folder on the server and the external system configuration is done in the ITA client.

The import files must be located in "data/pentaho/import" in order for ITA to execute the files/transformation(s). Export transformation files must be located in "data/pentaho/export".