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
0
votes
1 answer

Pentaho PDI - Reading data from MongoDB

I have installed Pentaho Data Integration version (ce-5.0.1.A-stable) in my machine and I am trying to retrive information from MongoDB using PDI. I have created a transformation with Mongo Input step. Now when I try to configure my MongoDB…
Aarthi Priyadharshini
  • 185
  • 6
  • 20
0
votes
2 answers

Pentaho Data integartion database connections

I have a question about Pentaho Data Integration (Community) I am creating a transformation and I create a database connection to a MySQL database. The connection works well, but when I create a second transformation and I am using a database step I…
Juan Vidal
  • 9
  • 3
0
votes
1 answer

Use a separate log file for each Pentaho Data Integration Job (kettle)

I would like to have each Job in Pentaho to log execution information a separate log file, instead of having one single file in /opt/pentaho/server/data-integration-server/logs/pentaho.log. Does anyone know how to make this happen? In alternative,…
Anto
  • 63
  • 9
0
votes
1 answer

Lookup using contains match

I have to design ETL to load data into a table. But, I shouldnt load values matching keys in a lookup table. Eg. *Input Table* Cab Ride Ride in Cab Booked Cab Self drive Car pooling *Lookup Table* Cab Taxi *Destination Table* Self drive Car…
Arjun
  • 1,049
  • 6
  • 23
  • 37
0
votes
1 answer

Can't access to remote pentaho bi-server

I uploaded mi "pentaho biserver-ce-6.0.1.0-386" to my hosting and set the variables needed but i keep getting error like this: 04-Mar-2016 11:14:27.427 SEVERE [localhost-startStop-1] …
Gerard Luque
  • 163
  • 2
  • 13
0
votes
2 answers

MySQL Error: Can't create/write to file Errcode: 17

We are working on a data migration project in which the source and target databases are MySql (Version : 5.0.45-community-nt). Currently both the source and target databases are hosted on my local machine (Windows XP SP2). We are using a tool called…
SBA
  • 1
  • 1
  • 1
  • 1
0
votes
1 answer

Pentaho Data Integration - Excel Writer Output File Size

Is PDI inefficient in terms of writing excel xlsx file with Microsoft Excel Writer. A transformed excel data file in Pentaho output seems to be three times the size, if the data was transformed manually. Is this inefficiency expected or is there a…
user2033024
  • 3
  • 4
0
votes
2 answers

Using a Database column Value in output file name in Pentaho kettle

I wish to use a database column value in the output file name. example: select max(id) from process; suppose the result of above query is 111 -- wish to use this value in the output file name as shown below. output file name: file_111 how can i…
Akn
  • 35
  • 6
0
votes
1 answer

Any idea about this weird type error in Pentaho Data Integration?

I have this : Insertion des données dans table some_table.0 - SOME_AUTO_GENERATED_DB_KEY Integer : There was a data type error: the data type of java.lang.Boolean object [true] does not correspond to value meta [Integer] What boolean??? Where do you…
Julien
  • 2,616
  • 1
  • 30
  • 43
0
votes
1 answer

Javascript: find asterisk in database field

I am checking a stream of data in Pentaho Data Integration and am using some Javascript. Certain fields may have one asterisk as the value. So I have: if (Workgroup = "*") { summary_level = "A"; } else { summary_level = "W"; } All values are…
urbanmojo
  • 737
  • 3
  • 12
  • 21
0
votes
1 answer

Running multiple Kettle transformation on single JVM

We want to use pan.sh to execute multiple kettle transformations. After exploring the script I found that it internally calls spoon.sh script which runs in PDI. Now the problem is every time a new transformation starts it create a separate JVM for…
Explorer
  • 1,491
  • 4
  • 26
  • 67
0
votes
1 answer

Datawharehouse Fact Table Geneate

Currently, I am building fact table base my ODS tables and dimension tables. My ODS Table like 1.dateWiseData sid_date total_impressions 2.devices(Mobile…
Gaurav Ashara
  • 462
  • 2
  • 6
  • 16
0
votes
1 answer

Pentaho Cassandra input : Column family does not exist in keyspace

I am trying to set up an input step from Cassandra in Pentaho Spoon UI. But when I try to show schema or run the task I get the following exception: java.lang.Exception: The column family local does not seem to exist in the keyspace system at…
Warren Reilly
  • 344
  • 3
  • 14
0
votes
1 answer

Pentaho Filter Regexp Excel Input

Ok, so what I'm trying to do now is take all the information off an Excel Input (all String columns), and then of these columns I want to make an specific filter for one of them, more specific on column NO_BIEN, this specific…
Enrique Bravo
  • 133
  • 1
  • 1
  • 11
0
votes
1 answer

Pentaho Kettle, Can't set Field defaults in Text File Input

I am importing a CSV file to be processed in a transformation. Originally I was using the CSV File Input. I later learned I could not have any null values. So I switched to the Text File Input because it had a Default Column in the Fields Tab that…
Andrew Soloninka
  • 45
  • 9
1 2 3
…
55 56