Stack Overflow
Stack Overflow

Questions tagged [kettle]

Kettle is a code name for Pentaho Data Integration Community Edition tool. It is an open source GUI-based ETL (Extraction, Transformation, and Loading) tool.

Kettle is a code name for Pentaho Data Integration Community Edition. It is an ETL tool (Extraction, Transformation and Loading) that uses a metadata-driven approach.

https://help.pentaho.com/Documentation/8.2/Products/Data_Integration

1387 questions
-2
votes
1 answer

Assign several values to one key Pentaho Kettle

Please help! I have two streams (columns), let's say col_1 and col_2. There are 50 unique rows in col_1 and 10 unique rows in col_2. I need to assign these 10 unique rows to EVERY row of col_2. Actually I need to populate every value from col_1 10…
Ivan Romanovych
  • 51
  • 2
  • 5
-2
votes
2 answers

Pentaho behave slowly on insert/update with PostgreSQL

Pentaho behaves slowly on insert/update with PostgreSQL, which is because jdbc driver will not accept prepared statements. After 2 million row Pentaho / PostgreSQL performance almost become 1 per 1 second. Post me an alternative solution with…
Sivasakthi Chandrasekaran
  • 25
  • 9
-2
votes
2 answers

Create a Pentaho Transformation & Steps using Java

I am very new to Pentaho/ETL and need expert advise to complete my assignment. Actually, we are trying to integrate Pentaho Steps/Jobs with our web based platform. We are designing a similar interface where user will get the list of steps and can…
Vaibhav Dixit
  • 165
  • 2
  • 8
-2
votes
1 answer

What is the Equivalent of SSIS Lookup in Kettle ( Pentaho Data Integration) or Talend

I'm looking for an equivalent of the SSIS Lookup componement in Pentaho Data Integration ( Kettle) or Talend. A componement which take 2 sources and return no matched rows
Saïd Assoumani
  • 3
  • 4
-2
votes
1 answer

How to monitor inventory javascript?

This is my first time in this web site, I hope that you may help me. Thanks in advance. Mainly I need two things. To create something with JavaScript for compare a field (inv_product.min_exi) from my database against existence of inventory. Wherein…
Gerardo P.
  • 26
  • 1
  • 5
-3
votes
1 answer

kettle problem : a parameter value didn't work, using "trans.sendToSlaveServer" to start a trans

i'm using Trans.setParameterValue("whereStr", ""); Trans.sendToSlaveServer(transMeta, transExecutionConfiguration, rep, null) to set a Parameter for a kettle Transformation, it will run on a remote server. However, the remote server can't find…
lucien
  • 1
  • 1
-3
votes
2 answers

Details of Pentaho Data Integration ( ETL kettle tool)

I need to convert the contents of Excel sheet to the corresponding tables in MySQL database. I referred the net and found that Pentaho data integration (ETL Kettle tool) can be used for this purpose. Can anyone suggest me which version can I…
Divya
  • 69
  • 1
  • 7
1 2 3
…
92
93