Top "Pentaho-spoon" questions

Spoon is the graphical transformation and job designer associated with the Pentaho Data Integration suite — also known as the Kettle project.

Where to download sun.jdbc.odbc.JdbcOdbcDriver (trying to connect output csv from Spoon to SSMS)

I have a csv that I have transformed in Kettle/Spoon/PDI and I am trying to output it to …

ssms pentaho pentaho-spoon data-integration
Replace null value with NA using Pentaho Kettle

I have an input csv file with one column field value as empty. I want to replace that field value …

pentaho kettle data-integration pentaho-spoon
Remove special characters using Pentaho - Replace in String

I wanted to remove the special characters like ! @ # $ % ^ * _ = + | \ } { [ ] : ; < > ? / in a string field. I used the "Replace in String" …

regex pentaho kettle pentaho-spoon pdi
How to Change the date format yyyy/MM/dd HH:mm:ss to dd_mm_yy through modified java script value in pentaho

How to Change the date format yyyy/MM/dd HH:mm:ss to dd_mm_yy through modified java script …

pentaho kettle pentaho-spoon
Error when Installing pentaho data integration

I'm trying to install pentaho data integration and I have a problem with the configuration of spoon.bat. I updated …

installation pentaho java-home pentaho-spoon pdi
How do I transpose a table in Pentaho Kettle from rows to columns without the header column

I'm new to Pentaho and I need to transpose a table from rows to columns, but the first column doesn't …

pentaho transpose kettle pentaho-spoon
How to get Field value in User Defined Java Class in kettle?

I am trying to get the Link field in the User Defined Java Class step from my below transformation. Here …

pentaho kettle pentaho-spoon
Error connecting to database: (using class org.gjt.mm.mysql.Driver) The statement (1) has no open cursor

I am working on Pentaho Data Integration tool version 5.2. I am trying to connect to data base using 'Table Input' …

mysql pentaho kettle pentaho-spoon
How to check Pentaho kettle version from the command line?

I know I can check the Pentaho version by opening the spoon.sh in vi mode, but the Pentaho that …

pentaho kettle pentaho-spoon
Configure Pentaho data Integration to connect to Oracle DB

I have configured Oracle VirtualBox with DB, user and populated a small DB. In the same machine I've installed Pentaho …

oracle database-connection kettle pentaho-spoon