Added by Jens Bleuel, last edited by Bertrand Paquet on Feb 22, 2012  (view change)

Labels:

Enter labels to add to this page:
Wait Image 
Looking for a label? Just start typing.

This space is intended to list available Plug-Ins for Pentaho Data Integration and to keep the internal ID unique. 

Notes
  • If you want your Plug-In listed here, please contact communityconnection@pentaho.org. Include the information for the table below, the Kettle version (2, 3, 4 etc) and your wiki id.  You have the option to have the link point to a web page that you host or to have us create a wiki page that you maintain. If you need also a space in our subversion plugin space, we can add a project to svn://source.pentaho.org/svnkettleroot/plugins for you.
  • Unless stated otherwise, the plug-ins listed on this page are free to download and use, but are not officially supported as part of a paid Pentaho Subscription.
  • Plugins for version 2 are listed here.

 Plugins - Spoon perspectives

Name Short Description / Remarks
PDI
Version / Download
ScatterPlot3D Provides a Java3D-based visualization and a matrix of histograms visualization 4.x (bin) / (src)
Agile BI
Provides Modeler and Visualization Perspectives in PDI
 4.x (bin) / (src)

 Plugins - Job Entries

Unique ID Name Short Description / Remarks
PDI
Version / Download
DummyJob
Dummy Job Entry
Dummy plugin test job entry - this can be a blueprint for other job entries
3.x
- General
   
JabberMessage JabberJob Allows sending of Jabber messages (like to Google Talk) 3.x (bin) / (src)
MondrianOutput Mondrian Output Output the result of a mondrian MDX query to an excel file or chart. Jason Chu 3.x (info) / (bin) / (src)
- KFF
     
KjubeBatchId KFF Batch ID manager Automatically retrieves, sets and updates a batch ID. Part of the KFF project 3.2, 4.x
KjubeConfigurator KFF Configurator Automatically configures the KFF environment by using a few base parameters. Part of the KFF project 3.2, 4.x



 Plugins - Transformation Steps

Unique ID Name Short Description / Remarks
PDI
Version / Download
DummyPlugin Dummy Plugin Dummy plugin test step - this can be a blueprint for other steps 3.x
- Input Steps      
DateGenerator
Date Generator
Generates a sequence of consecutive dates.
3.0, 3.1
IMS Database Loader Proventa IMS Database Loader
Reading (large) IBM IMS Database dumps fast and easy.
This is a commercial (closed source) plugin by Proventa AG.
3.x
ITN Connector ERP ITN Connector ERP ITN Connector ERP provides functionality to extract data from SAP tables. Data may be extracted: all / selected fields / selected rows. This is an open source plugin by it-novum. 3.x, 4.x (doc)
ProERPCONN
PRORATIO - SAP Connector
ProERPCONN offers a comfortable and quick access to the entire SAP dataset.
This is a commercial (closed source) plugin by Proratio.
3.x
SalesforceInputPlugin SalesforceInputPlugin Allows you to read data from Salesforce. (Translation : US & FR)
Updated : 10 Dec. 2008
3.1
ShapeFileReader ESRI Shapefile Reader
Reads shape file data from an ESRI shape file and linked DBF file
3.x
SugarCRMModule
SugarCRM The SugarCRM Plugin allows you to access all data available in SugarCRM modules. 3.x
SuperCsvInput
Super CSV Input
Read CSV input files.
3.1
TypeExitGoogleAnalyticsInputStep
Google Analytics
Reads data from Google Analytics using Google's Export API. Plugin created by type-exit.org.
3.2, 4.0
TypeExitEdi2XmlStep EDI to XML Converts EDI text to generic XML. This will be included and supported in PDI 4.3 by PDI-7019.
4.x (doc)
com.legstar.pdi.zosfile z/OS File Input Reads IBM mainframe files with records described by COBOL copybooks. Project Page 4.x
- Input/Output Steps
   
PaloDimInput / PaloDimOutput / PaloCellInput / PaloCellOutput PaloKettlePlugin Use Palo Molap Database on your ETLs designed with Kettle. 3.x
Rss Input/Rss Output Rss Input/Output One plugin to read RSS feeds and another one to write feeds to file.
Note: This step has become a standard step in 3.2 and Pentaho Support is available. 		3.x
- Output Steps
   
ArffOutput
ARFF Output
Saves data to a file in WEKA's ARFF (Attribute Relation File Format).
Note: Pentaho Support is available for this plug in as part of a Pentaho Subscription.
3.x, 4.x
TypeExitExcelWriterStep
Excel Writer Supports template based writing and modification of xls and xlsx files. 3.2, 4.0
SuperCsvOutput
Super CSV Output
Output to a CSV file.
3.1
cmisput Put document via CMIS Outputs documents to CMIS compliant repositories like Alfresco. 4.x
- Transform Steps
   
Asciify
Asciify
Asciifies strings. It will replace characters that are outside of the 7-bit ASCII range (e.g. diacritics) with a close equivalent and it will replace or remove any other character it can't convert.
3.0, 3.1
DataGrid Data Grid This step allows you to enter rows of data directly into a step. Part of the KFF project. This step was contributed to Kettle and is now part of version 4.x.
3.2
DateTime Date-time calculator Assemble a date using 7 fields containing centuries, years, months, days, hours, minutes and seconds.  This date format is typically used in AS/400 RPG programs. Part of the KFF project. 3.2, 4.x
Decoder KFF Decoder Decode AS/400 encoded data using mask information and table-name mappings. Part of the KFF project. 3.2, 4.x
EncryptDecryptPlugin Encrypt/Decrypt Provides the ability to encrypt and decrypt the values of any field of a table/fixed file/CSV file. Plug-In posted by Persistent Systems Ltd. 3.x
FieldCalculatorPlugin Field Calculator This plug-in does the arithmatic operatios on the columns of a table. The derived values can be then store in a table/fixed file/CSV file. Plug-In posted by Persistent Systems Ltd. 3.x
Formula Formula Calculates values and evaluates expressions.
This is based on the Open Office standard for expressions.
Note: This step has become a standard step in 3.2 and Pentaho Support is available. 		3.x
Head Head Read first x rows of stream. 3.1
Rejects Rejects The Rejects steps handles rejected records in a standard fashion. Part of the KFF project. 3.2, 4.x
ReservoirSampling Reservoir Sampling Samples a fixed number of rows (with uniform probability) from the incoming stream.
Note: This step has become a standard step in 3.2 and Pentaho Support is available. 		3.x
TypeExitRubyStep
Ruby Scripting Allows to use the Ruby language in Kettle Transformations. Similar to the JavaScript step, but geared towards the Ruby language. 4.x
SeasonId Season ID calculator Assemble a unique (bi-yearly fashion industry) season ID using 3 fields containing centuries, years and a season number. Part of the KFF project. 3.2, 4.x
TableCompare Table Compare Compares 2 tables and gives back a detailed list of differences. Part of the KFF project. 3.2, 4.x
Tail Tail Read after first x rows of stream. 3.1
TrimStrings Trim Strings Trims string fields.  You can trim all fields, select fields or exclude fields.  Supports left, right and full trimming. Part of the KFF project. 3.2, 4.x
TrimCut TrimCut (Experimental) Trims and cuts string values to size. 3.0 3.1
UnivariateStats Univariate Stats Computes simple univariate statistics.  Available statistics include: N, minimum, maximum, mean, sample standard deviation, median and arbitrary percentiles (computed using a simple mid-point method or interpolation).
Note: This step has become a standard step in 3.2 and Pentaho Support is available. 		3.x
WekaScoring (Weka 3.6 or 3.7.0) Weka Scoring Appends predictions (labels or probability distributions) from a pre-built WEKA model (classifier, clusterer or PMML). Compatible with Weka 3.6.x and 3.7.0.
Note: Pentaho Support is available for this plug in as part of a Pentaho Subscription. 		3.x, 4.x
WekaScoring (Weka 3.7.2 - 3.7.4) Weka Scoring Appends predictions (labels or probability distributions) from a pre-built WEKA model (classifier, clusterer or PMML). Compatible with Weka 3.7.2 - 3.7.4.

Note: Pentaho Support is available for this plug in as part of a Pentaho Subscription. 		3.x, 4.x
WekaScoring (Weka >= 3.7.5) Weka Scoring Appends predictions (labels or probability distributions) from a pre-built WEKA model (classifier, clusterer or PMML). Compatible with Weka >= 3.7.5.

Note: Pentaho Support is available for this plug in as part of a Pentaho Subscription. 		4.x
- Join Steps      
kettle-history-join-plugin History Join This plugin supply a method to join two tables using the date-from and date-to history. It use the two dates that indicate the life of the record and join using a query (like the database join plugin) to resolve the record's story of the two entities. 4.x
- Data Warehouse Steps      
kettle-date-dimension-plugin Date dimension This plugin provides a function to resolve, and insert if it doesn't exist, the date dimension. It calculates all calendar data and you must supply the table info used to save the information. 4.x
- Lookup Steps      
MaxMindGeoIPLookup MaxMind GeoIP Lookup Lookup country, city, lat, long and much more from an IP address using the MaxMind Geo IP databases 4.x
Advanced HTTP Plugin Advanced HTTP Advanced HTTP plugin, with lot of new features : get and post, fail on error, ssl, basic auth, timeout ... Code is here. 3.x
 Bulk Loading Steps      
TeraFastPlugin Teradata bulk loader Maximum performance for large data loads into Teradata by Aschauer EDV.   This step is now included in Kettle 4.x. 3.x


Here are the attachments to the plugin development page, including the sample dummy step and job entry plugins for versions 2.5.x and 3.0.x.

Comments  (Hide Comments)

In

TypeExitExcelWriterStep
Excel Writer Supports template based writing and modification of xls and xlsx files. 3.2, 4.0

under "Supports template based writing and modification of xls and xlsx files." Add a sentence saying taht this step is included in 4.2? :

TypeExitExcelWriterStep
Excel Writer Supports template based writing and modification of xls and xlsx files.
Note: This step has become a standard step in 4.2
 3.2, 4.0
Comment: Posted by Nikolai Sandved at Aug 25, 2011 07:42