Pentaho Data Integration Valuable Features

Specialist in Relational Databases and Nosql at a computer software company with 5,001-10,000 employees
One important feature, in my opinion, is the Metadata Injection. It gives flexibility to the scripts due to the fact that the scripts don't depend on a fixed structure or a fixed data model. Instead, you can develop transformations that are not dependant on the fixed structure or data models. Let me give a pair of examples. Sometimes your tables change, adding fields or dropping some of them. When this happens if you have a transformation without using Metadata Injection your transformation fails or doesn't manage the whole info from the table. If you use Metadata Injection instead, the new fields are included and the dropped columns are excluded from the transformation. Other times you have a complex transformation to apply to a lot of different tables. Traditionally, without the Metadata Injection feature, you had to repeat the transformation for each table, adapting the transformation to the concrete structure of each table. Fortunately, with the Metadata Injection, the same transformation is valid for all the tables you want to treat. A little bit effort gives you a great benefit. Furthermore, the solution has a free to use community version. The solution is easy to set up, very intuitive, clear to understand and easy to maintain. View full review »
Find out what your peers are saying about Hitachi, Microsoft, IBM and others in Data Integration Tools. Updated: August 2020.
437,064 professionals have used our research since 2012.