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

How to validate one csv data compare with another csv file using Pentaho?

I have two csv file . In one file i have 10 rows and in another list of data . What i want to do is , check the data of one filed of first csv and compare it with another csv file . So how can i achieve this ? Any help would be great .
Abhishek
  • 21
  • 8
0
votes
1 answer

Migrate data from Mysql to Mysql with Kettle Spoon changing Timezone

I'm migrating and changing some data from one Mysql db to another Mysql db with a slightly different structure. The main difference is that on the first database dates are expressed in local timezone (Europe/Rome), instead on the target db they are…
drenda
  • 5,846
  • 11
  • 68
  • 141
0
votes
0 answers

Is Pentaho Reporting Output component of PDI works without parameters

enter image description here Below is my requirement with example. 1.Base report will have data from this query.    Base report query:select * from Animals;    I used above query in prpt for base report. 2.I want to generate 2 saperate reports…
Pramod Lokare
  • 11
  • 3
0
votes
1 answer

(stderr) =256m""=="" was unexpected at this time in Pentaho Shell script

This question is almost similar to pentaho: error (stderr) =256m""=="" was unexpected at this time. while calling kitchen command (dos command using shell script job entry) from job But It differs in clarity as I am providing exact details and also…
KCK
  • 2,015
  • 2
  • 17
  • 35
0
votes
1 answer

Kettle does not fetch data into dashboard table

I'm trying to use kettle query in pentaho cde, I uploaded ktr file, then browse it from kettle query and determined the step of transformation but when I preview dashboard, table that use from kettle datasource is empty. What's the problem?
stella
  • 117
  • 1
  • 2
  • 8
0
votes
2 answers

Pentaho Spoon: Cannot split string in JavaScript Step

I am trying to use the JavaScript step in order to extract the first part of a string of the input field "name". An example entry for the field "name" would be: "14 Ri.". And I want to extract the "14" out of the string. For this, I have tried to do…
user7335295
  • 401
  • 2
  • 7
  • 31
0
votes
0 answers

failed to schedual xaction file for run PDI job

I want to run my Pentaho-data-integration job with xaction file. my job(schedualeJob.kjb) has one transformation(repository2.ktr)( without any schedule). the contetnt of my schedule.xaction file is:
stella
  • 117
  • 1
  • 2
  • 8
0
votes
1 answer

Pentaho Data Integration - Star schema (PostgreSQL)

I have a CSV file with data and the database I need for the star schema. However, the CSV file doesn't have the ID's of the dimensions tables (the primary keys), which means I only get those ID's after inserting the data into the dimension's tables…
João Amorim
  • 3
  • 4
0
votes
1 answer

Apache nifi and pentaho port issue

Both Apache nifi and Pentaho uses the same port. When I start the pentaho services. Unable to open the UI. ( http://localhost:8080/pentaho ). Receiving the error message as " Did you mean: /nifi You may have mistyped... " Please assist.
Prabhu Bentick
  • 3
  • 3
0
votes
0 answers

Can we integrate Pentaho Data Integration tool with .NET

I have Dot Net application, Now I want to integrate and call Pentaho Data Integration jobs with existing application asp.net c# is there any way to do this. How I could integrate Pentaho with .NET looking for some tutorials or articles but here is…
Sarmad
  • 11
  • 1
0
votes
0 answers

Why would New Repository Connection window not load?

I've freshly installed windows-10 Pro N(64-bit)(not activated & fully updated to date) and downloaded pentaho from this source. After installing java (64-bit) and creating an environment variable PENTAHO_JAVA_HOME with the path to its JRE folder I…
Nae
  • 14,209
  • 7
  • 52
  • 79
0
votes
0 answers

How to put condition into the XPATH while extracting XML using Pentaho?

Overview: …
Abhishek
  • 21
  • 8
0
votes
0 answers

How to extract data from the XML file includes the XSL content?

I have an XML file. In that file some dates are coming from the XSL file. So how can I get those dates. So basically I am using Pentaho and that read XML file. My XML file contains dates which is in another XSL file. So how can I get the dates from…
Abhishek
  • 21
  • 8
0
votes
1 answer

How to Skip a Transformation in Pentaho Data Intigration job

I have single Job to run multiple Transformations. I want to parameterize this single job by some parameter that decides if all the transformation has to run or a single transformation has to run based on the name passed. E.g Start --> …
Arpan Saini
  • 4,623
  • 1
  • 42
  • 50
0
votes
1 answer

How can i extract data from the XML using Pentaho when xml tag is repeating?

I am extracting data from the XML . In that i have two duplicate tag with different values . So how can i get this data in different columns ? …
Abhishek
  • 21
  • 8
1 2 3
…
55 56
A B
A1 B2