Pentaho Data Integration

	Explore and Learn
	Resources Data Sheet User Forum Download Request a Quote Contact Us Popular Links Matt Casters, PDI Project Lead, Discusses Agile BI Pentaho Data Integration Announcement More about Pentaho Agile BI Forrester: Open Source ETL Healthcare Case Study More Links Related Webcasts Pentaho Defines a Better Way to Build BI Solutions Mozilla Case Study Webcast ZipRealty Web Seminar

Data is everywhere. Providing a consistent, single version of the truth across all sources of information is one of the biggest challenges faced by IT organizations today. Pentaho Data Integration delivers powerful Extraction, Transformation and Loading (ETL) capabilities using an innovative, metadata-driven approach. With an intuitive, graphical, drag and drop design environment, and a proven, scalable, standards-based architecture, Pentaho Data Integration is increasingly the choice for organizations over traditional, proprietary ETL or data integration tools.

With Pentaho Data Integration, Pentaho is redefining the way that BI applications are built and deployed.  Utilizing Pentaho’s Agile BI approach, Pentaho Data Integration unifies the ETL, modeling and visualization processes into a single, integrated environment that enables developers and end-users to work seamlessly together.  The end result is that BI developers and end users can build BI applications more quickly, easily and at a small fraction of the cost of traditional solutions.  Pentaho’s Agile BI:

• Powers instantaneous, iterative BI application development
• Enables seamless collaboration between developers and end users
• Merges complex BI development into a single process
• Dramatically reduces time and difficulty of building and deploying BI apps

Pentaho Data Integration's metadata-driven approach means you simply specify WHAT you want to do, but not HOW you want to do it. Now administrators can create complex transformations and jobs in a graphical, drag-and-drop environment without having to generate any custom code. Pentaho Data Integration is a full-featured ETL solution including:

• Rich transformation library with over 100 out-of-the-box mapping objects
• Broad data source support including packaged applications, over 30 open source and proprietary database platforms, flat files, Excel documents, and more
• Advanced data warehousing support for Slowly Changing and Junk Dimensions
• Proven enterprise-class performance and scalability
• Integration with the Pentaho BI Suite for Enterprise Information
• Integration (EII), advanced scheduling, and process integration
• Unified ETL, modeling and visualization development environment for design of BI applications

Zoom

Zoom

Zoom

Common use cases for Pentaho Data Integration include:

• Data warehouse population
• Agile design of BI applications
• Information enrichment by integrating data from various sources
• Data migration between applications
• Imports of data into databases from text-files, Excel spreadsheets, relational systems and more
• Data cleansing by applying complex conditions in data transformations
• Exploration of data in existing databases (tables, views, etc.)