Stack Overflow
Stack Overflow

Questions tagged [pentaho-spoon]

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

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

Documentation: http://wiki.pentaho.com/display/EAI/Spoon%2BUser%2BGuide

828 questions
3
votes
1 answer

Pentaho Execute SQL Statements variable conversion to null

I am using PDI to delete and insert some data from a DB. I have the following issue. I create two variables called START_DATE and END_DATE that are used to select the data that will be deleted from my DB. I am able to get them and run my…
Diego Serrano
  • 846
  • 2
  • 15
  • 34
3
votes
1 answer

Getting fields from SQL Server Stored Procedure

I'm trying to build a transformation in Kettle that gets FIELDS from a SQL Server Stored Procedure and inserts it in a MySql table. The problem is that I can't find a way to get stored procedure "fields". I understand that Call DB Procedure task…
jfneis
  • 2,139
  • 18
  • 31
3
votes
1 answer

Get Max id mongodb in Pentaho spoon

I want to get the maximum id in mongodb using PDI spoon. I have this fields in my collection: Id String Genre String Before I insert new record I should get the maximum Id. Can you help me on how to get the maximum Id?
soup5
  • 103
  • 8
3
votes
2 answers

Database repository (Oracle) vs File system as a repository for Pentaho

I want to use Pentaho for my work. After a bit of research I found that to store the ktr/kjb files I can have either database as a repository or I can use file system as a repository. However I don't find any benefits of using database as a…
Explorer
  • 1,491
  • 4
  • 26
  • 67
3
votes
1 answer

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' step. but when I test the connection in this step it is giving me the below error message. I am able to connect to DB using the MySQL…
Ghost Rider
  • 688
  • 3
  • 17
  • 38
3
votes
3 answers

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 Data-Integration(Spoon), the JDBC driver and I'm trying to create a connection to Oracle DB but without success. This is where I'm…
Alg_D
  • 2,242
  • 6
  • 31
  • 63
3
votes
1 answer

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 the file with adding PENTAHO_JAVA= javaw.exe, also edited the environment variables (Computer > Properties > Advanced > Environment…
Fatim
  • 155
  • 3
  • 3
  • 13
2
votes
2 answers

Pentaho Data Integration (PDI) 9.4 Marketplace missing, how to install Plugin now?

I've just installed Pentaho Data Integration (PDI) version 9.4 (Community Edtition). I'm following this guide to install the new Plugin. The problem is I don't have "Marketplace" in "Tools -> Marketplace" like the guide said (the Show plugin…
Hoang Minh Quang FX15045
  • 733
  • 1
  • 4
  • 15
2
votes
1 answer

Pentaho Data Integration not working with Openjdk 16

After upgrading from openjdk 15 to openjdk 16, pentaho data integration (version pdi-ce-9.1.0.0-324) throws a java class error. To reproduce the error message download and install openjdk 16 from…
smha
  • 21
  • 1
  • 3
2
votes
2 answers

Pentaho treating empty string as null

Hello i'm particularly new to pentaho and why when the table_input has an empty string, and when do insert to table_output the data becoming null for example in the table input ID|name 1|dan 2| 3|itzy 4|kim 5|(null) i do preview my query, and it's…
Triaji Setiawan
  • 45
  • 1
  • 1
  • 8
2
votes
0 answers

PDI transformation does not send messages to Kafka server

I have a transformation in Pentaho Data Integration (PDI) that makes a query to NetSuite, builds JSON strings for each row and finally these strings are sent to Kafka. This is the transformation: When I test the transform against my local Kafka it…
alois.wirkes
  • 369
  • 2
  • 7
  • 20
2
votes
0 answers

Pentaho Kettle | Connect to HTTPS Repository (with cacerts file)

cacerts: Already added cacerts to JVM present at PENTAHO_JAVA_HOME Some Debugging Findings: Tomcat with HTTPS (all OK) Kettle sends a request https://pentaho.foo.com:2000/pentaho/webservices/unifiedRepository?wsdl Response XML ...
Srinath Ganesh
  • 2,496
  • 2
  • 30
  • 60
2
votes
0 answers

Pentaho PDI on Ubuntu 18

I have Pentaho setup and running on Windows 10, I am planning to migrate to Ubuntu. Has anyone setup Pentaho on Ubuntu 18.04? If yes, what is the configuration you are using? Pentaho documentation says mentions Ubuntu 14 and 16 to be used and are…
amey
  • 21
  • 2
2
votes
0 answers

Pentaho Spoon: Pass variable to MongoDB input

I'm trying to create a Job which is suppose to : Get me the maxID in a MongoDB collection Give me all documents from another collection verifying id < maxID In the first transformation I retrieve the maxID and set the…
Babacar Cisse
  • 21
  • 3
2
votes
1 answer

Error on opening any Kettle Transformation file in Pentaho Data Integration

I have been working with PDI since a long time and while opening the same file which used to work perfectly before is now showing the below error immediately after opening: java.lang.NullPointerException at…
KCK
  • 2,015
  • 2
  • 17
  • 35
1 2
3
…
55 56