Pentaho Data Integration
Pentaho Data Integration is a part of the Pentaho Open Source Business intelligence suite. It includes software for all areas of supporting business decisions making - the data warehouse managing utilities, data integration and analysis tools, software for managers and data mining tools.
Pentaho data integration is one of the most important components of this business intelligence platform and seems to be the most stable and reliable.
Pentaho Data Integration is well known for its ease of use and quick learning curve. PDI's implements a metadata-driven approach which means that the development is based on specifying WHAT to do, not HOW to do it.
Pentaho lets administrators and ETL developers create their own data manipulation jobs with a user friendly graphical creator, and without entering a single line of code.
Advanced users know, that not every user friendly solution is as effective as it could be, so skilled and experienced users can use advanced scripting and create custom components.
Pentaho Data Integration uses a common, shared repository which enables remote ETL execution, facilitates team work and simplifies the development proces
There are a few development tools for implementing ETL processes in Pentaho:
- Spoon - data modeling and development tool for ETL developers. It allows creation of transformations (elementary data flows) and jobs (execution sequences of transformations and other jobs)
- Pan - executes transformations modeled in Spoon
- Kitchen - is an an application which executes jobs designed in Spoon
- Carte - a simple webserver used for running and monitoring data integration tasks
Pentaho Enterprise Edition
The enterprise edition of the Pentaho Data Integration adds some extra components that extends the capabilities of Pentaho platform.
For ca. $15,000 per year, the enterprise edition gives you support from Pentaho specialists, access to documentation which makes problems and issues resolution easier and extra applications for administration and development of the Business Intelligence content.
The support is delivered through telephone and e-mail. The enterprise edition also gives you access to the latest patches and updates for which users of the community edition need to wait. The software maintenance for users of the enterprise edition is diffrent than for users of the free edition. Every user of the enterprise edition gets a professional engineer help in maintaining his business inteligence software. It means not only a person who will do the job, but also someone who can teach new developers and administrators everything about this platform.
Users of the enterprise edition can monitor performance of their data integration system with special tools. They also are able to administer their data warehouses remotely, and are alerted about special events in their systems.
The Pentaho Data Integration is a part of a great solution for companies and organizations that need business intelligence software with minimum cost and without experienced specialists.