Pentaho Forum, Kettle Download, Kettle vs Spoon, Data Integration Tool
Pentaho is a business intelligence (BI) software that provides data integration, OLAP services, reporting, information dashboards, data mining and extract, transform, load (ETL) capabilities. It is headquartered in Orlando, Florida. This was acquired by Hitachi Data Systems in 2015. On September 19, 2017, this became part of Hitachi Vantara, a new company that unifies the operations of Pentaho, Hitachi Data Systems and Hitachi Insight Group. Pentaho Forum
Welcome to the Pentaho Community wiki. This wiki contains documentation and information for the Pentaho Open Source BI Suite Community Edition (CE). The suite includes ETL, OLAP analysis, metadata, data mining, reporting, dashboards and a platform that allows you to create complex solutions to business problems. The Pentaho community is an extraordinary group of people with many different talents who are dedicated to delivering a complete, well integrated, and high quality suite of business intelligence software. By using Pentaho CE software, you are also participating in the Pentaho community and contributing to an open source project. Pentaho Forum
Expectations – If you are unfamiliar with open source, this article is a good place to start. The open source community thrives on participation and cooperation. There are several communication channels available where people can help you, but they are not obligated to do so.
You are responsible for your own success which will require time, effort and a small amount technical ability. If you prefer to have a relationship with a known vendor who will answer questions over the phone, help you during your evaluation and support you in production; please visit Pentaho Forum.
- InfoWorld Bossie Award 2008, 2009, 2010, 2011, 2012.
- Ventana Research Leadership Award 2010 for StoneGate Senior Care.
- CRN Emerging Technology Vendor 2010.
- ROI Awards 2012 – Nucleus Research.
- BI Platform
- Saiku Analytics
- Flash Charts
- Data Access
- Agile BI
- Big Data
- Product Management
Pentaho Kettle Download
Pentaho tightly couples data integration with business analytics in a modern platform that brings together IT and business users to easily access, visualize and explore all data that impacts business results. Use it as a full suite or as individual components that are accessible on-premise in the cloud or on-the-go (mobile). Pentaho Kettle enables IT and developers to access and integrate data from any source, and deliver it to your business applications, all from within an intuitive and easy to use graphical tool.
Kettle Vs Spoon
What is Kettle(PDI) and functional of Kettle about Spoon,Pan etc.
Following the title, I don’t understand function of Kettle about spoon, pan ,kitchen and chef. They help for how to working in pentaho data integration. I studying about Pen. CE and try to answer for make a user manual for staff of my company. Thank you. Help me pls…
What is Spoon?
Kettle is an acronym for “Kettle E.T.T.L. Environment.” Kettle is designed to help you with your ETTL needs, which include the Extraction, Transformation, Transportation and Loading of data.
Spoon is a graphical user interface that allows you to design transformations and jobs that can be run with the Kettle tools — Pan and Kitchen. Pan is a data transformation engine that performs a multitude of functions such as reading, manipulating, and writing data to and from various data sources. Kitchen is a program that executes jobs designed by Spoon in XML or in a database repository. Jobs are usually scheduled in batch mode to be run automatically at regular intervals.
Note: For a complete description of Pan or Kitchen, see the Pan and Kitchen user guides.
Transformations and Jobs can describe themselves using an XML file or can be put in a Kettle database repository. Pan or Kitchen can then read the data to execute the steps described in the transformation or to run the job. In summary, Data Integration makes data warehouses easier to build, update, and maintain.
Follow the instructions below to install Spoon:
- Install the Sun Microsystems Java Runtime Environment version 1.5 or higher. You can download a JRE for free at Javasoft.
- Unzip the binary distribution zip-file in a directory of your choice.
- Under Unix-like environments (Solaris, Linux, MacOS, for example), you must make the shell scripts executable. Execute these commands to make all shell scripts in the Kettle directory executable:
The scripts below allow you to launch Spoon on different platforms:
- Spoon.bat: launch Spoon on the Windows platform.
- spoon.sh: launch Spoon on a Unix-like platform such as Linux, Apple OSX, Solaris
To make a shortcut under the Windows platform, an icon is provided. Use “spoon.ico” to set the correct icon. Point the shortcut to the spoon.bat file.
The Spoon GUI is supported on the following platforms: Pentaho Forum
- Microsoft Windows: all platforms since Windows 95, including Vista
- Linux GTK: on i386 and x86_64 processors, works best on Gnome
- Apple’s OSX: works both on PowerPC and Intel machines
- Solaris: using a Motif interface (GTK optional)
- AIX: using a Motif interface
- HP-UX: using a Motif interface (GTK optional)
- FreeBSD: preliminary support on i386, not yet on x86_64
Below is a list of known issues associated with Spoon.
Occasional JVM crashes running SuSE Linux and KDE. Running under Gnome presents no problems. (detected on SUSE Linux 10.1 but earlier versions also have the same problem).
Pentaho Data Integration Tool
Pentaho Data Integration (PDI, also called Kettle) is the component of Pentaho responsible for the Extract, Transform and Load (ETL) processes. Though ETL tools are most frequently used in data warehouses environments, PDI can also be used for other purposes:
- Migrating data between applications or databases
- Exporting data from databases to flat files
- Loading data massively into databases
- Data cleansing
- Integrating applications
PDI is easy to use. Every process is created with a graphical tool where you specify what to do without writing code to indicate how to do it; because of this, you could say that PDI is metadata oriented. Pentaho Forum
PDI can be used as a standalone application, or it can be used as part of the larger Pentaho Suite. As an ETL tool, it is the most popular open source tool available. PDI supports a vast array of input and output formats, including text files, data sheets, and commercial and free database engines. Moreover, the transformation capabilities of PDI allow you to manipulate data with very few limitations.
Through a simple “Hello world” example, this tutorial will to show you how easy it is to work with PDI and get you ready to make your own more complex Transformations.
- 01. Installing Kettle
- 02. Spoon Introduction
- 03. Hello World Example
- 04. Refining Hello World