Stack Overflow
Stack Overflow

Questions tagged [pentaho-data-integration]

Tag to be used for Pentaho Data Integration (all versions). Pentaho Data Integration prepares and blends data to create a complete picture of your business that drives actionable insights.

Pentaho Data Integration prepares and blends data to create a complete picture of your business that drives actionable insights.

It provides intuitive drag-and-drop data integration coupled with data agnostic connectivity spanning from flat files and RDBMS to Hadoop and beyond.

Features:

  • Graphical extract-transform-load (ETL) designer to simplify the creation of data pipelines
  • Rich library of pre-built components to access, prepare, and blend data from relational sources, big data stores, enterprise applications, and more
  • Powerful orchestration capabilities to coordinate and combine transformations, including notifications and alerts
  • Agile views for modeling and visualizing data on the fly during the data preparation process
  • Integrated enterprise scheduler for coordinating workflows and debugger for testing and tuning job execution
825 questions
2
votes
5 answers

PDI "Google Spreadsheet Input/Output" plugin compatible with Google Sheets API v4?

I am using the "Google Spreadsheet Input/Output" plugin from the Pentaho Data Integration marketplace, which is no longer maintained. Github repository link. Recently I have received an email from Google with the subject: [Action Required] Google…
stack_lech
  • 990
  • 2
  • 10
  • 28
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
2
votes
1 answer

How mysql repository works in Pentaho User console?

Based on Pentaho guideline (https://help.pentaho.com/Documentation/8.2/Setup/Installation/Archive/MySQL_Repository) I successfully converted pentaho File based repository to MySQL database repository. Now does anyone have any idea how MySQL…
NP007
  • 659
  • 8
  • 21
2
votes
1 answer

Where do I upload p12 file received from Google Analytics to Pentaho Server?

I am using Pentaho community version and using PDI on my local machine. I am trying to integrate PDI with Google Analytics and I am able to do so with my local machine. But when I put the same transformation file on to the server (PUC upload), It is…
Rosh Verma
  • 157
  • 1
  • 1
  • 8
2
votes
1 answer

can I get parameters from URL in pentaho?

Can I use a parameter from Carte's URL in a Job? Something like this: http://localhost:8080/kettle/startJob/?name=myjob&xml=Y&testvar=filename.txt I want to do this because I have a job to transform an input file but I want to change that filename…
Ms13
  • 151
  • 2
  • 2
  • 14
2
votes
1 answer

Pentaho Spoon:How to modify all the values of a column?

I am new to Pentaho spoon and even after a long time of research, didn't resolve my problem: I have a table, and want to multiply by 3 all the values of few columns. For instance, if I have inside of a column (5, 10, 3) then it becomes (15, 30,…
user11492726
2
votes
2 answers

Pentaho Kitchen Parameters not Being Passed Through to Pentaho Job

Use Pentaho Kitchen to run Spoon / PDI Job. Define parameters in main job that should be set by Kitchen params at run time. Running under Windows. The following does not work: C:\pentaho8.0\data-integration\kitchen…
NBessmer
  • 87
  • 2
  • 9
2
votes
1 answer

How to Synchronise two database using Pentaho?

I'm using Pentaho service to import all tables and data from a SQL database to a pgSQL database. I'm using the 'sort row' transformation for this. Now what I need is to sync the two databases frequently. (ie, changes occurred in SQL db needs to…
lekshmi
  • 21
  • 4
2
votes
0 answers

Pentaho Filter Rows sends a single null Row to output

I´m using Pentaho 8.1 and have a problem on filter rows step. It´s testing a value on a certain field and if its true go to an output step. The problem is when any row satisfy filter criteria. I expect not to be done, but instead, is an single row…
Vanderci Curvelo Junior
  • 152
  • 14
2
votes
1 answer

Pentaho DI Opening transformation: [null] in directory

guys! I have problem with starting kettle job from server. I have simple job with one trasformation. Trasformation is saved in the repository server. job in spoon If i start job from Pentaho local machine, the job runs successful, but transformation…
Nelli
  • 31
  • 2
2
votes
1 answer

PDI: Output only if no errors

i want to transform a csv-file to an XML-file. In the Transformation i have also a small Validation of data, for example length of a string must be < 50. So i have a Textfile Input Step > Modified JavaScript Step with two hops to Abort Step (for the…
Marko Unverzagt
  • 23
  • 2
2
votes
1 answer

Can we call GET/POST ajax call from Pentaho data integration spoon

I am using Django, Neo4j, and pentaho. In Pentaho Data Integration, we can use the javascript for any transaction. My question is that can we call ajax from the PDI javasticpt to django server method. Actually i want to send success msg to server…
Ravindra Gupta
  • 1,256
  • 12
  • 42
2
votes
1 answer

PDI - How to monitor kettle Transformation and Jobs?

I'm try to create web app to monitor my transformation and job. I will show all the status (begin datetime, run time duration, finish datetime, status, etc) on web app in live(my web app will refresh automatically to check the status). Is there any…
Rio Odestila
  • 125
  • 2
  • 19
2
votes
1 answer

Merge Rows (diff) is comparing row by row, not one row to entire rows of other table

I am comparing two sheets using Merge Rows (diff). 1st excel sheet: 2nd excel sheet: and my pentaho transaction: in preview data showing, that id 2.0 at 2nd row is add new row and at 4 row its showing same data is delete, its suppose to…
Ravindra Gupta
  • 1,256
  • 12
  • 42
2
votes
1 answer

Pentaho Kettle Database Repository

Currently we have multiple file based kettle repositories, we are planning to move them to database . Some of these repositories have transformations with same name, we have a oracle back end and when we are trying to import the repositories into…
Ravi
  • 2,470
  • 3
  • 26
  • 32
1 2
3
…
54 55