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

Error while exporting clob field from oracle to text field on Azure DB

I have a CLOB field on an Oracle Table that stores a PDF file. When I try export this field to SQL Server Db on Azure I got this error: 2017/01/19 11:14:32 - ImpostoRenda 2.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by…
Renatto Machado
  • 1,534
  • 2
  • 16
  • 33
9
votes
1 answer

Pentaho Kettle Java 11 Roadmap

Currently Pentaho Kettle (v.9.1) officially only support Java 8. This is a problem for us, since we are maintaining a plugin that needs Java 11 because of a essential library that needs Java 11. Does anyone have details on the roadmap for the…
Stefan
  • 157
  • 1
  • 7
7
votes
2 answers

How to run a pentaho job from Command Line

Have a job which takes around 1/2 minutes to finish, now trying to run this job through the command line just goes on forever and doesn't finish. It doesn't look like I get any errors from this either. So the job seems to be starting and I know the…
OCTAVIAN
  • 336
  • 5
  • 18
5
votes
2 answers

Pentaho Data Integration not starting on new Mac M1

I have an issue when I try running Pentaho Data Integration on Mac bigSur (M1). issue code in below: I'm sorry, this Mac platform [arm64] is not yet supported! Please try starting using 'Data Integration 32-bit' or 'Data Integration 64-bit' as…
Ivan Romanovych
  • 51
  • 2
  • 5
5
votes
5 answers

Passing Environment Variables to a Pentaho Kettle Transformation via script

I am required to parameterize all variables in my kettle job and a transformation (the jobs will be run in AWS and all params are passed in as environment variables). My connections, paths and various other parameters in the job and its attendant…
NullPumpkinException
  • 1,396
  • 1
  • 18
  • 22
5
votes
2 answers

Pass value from job to transformation in Pentaho

I have the following transformation in Pentaho PDI (note the question mark in the SQL statement): The transformation is called from a job. What I need is to get the value from the user when the job is run and pass it to the transformation so the…
ps0604
  • 1,227
  • 23
  • 133
  • 330
4
votes
4 answers

How to fix font color in PDI? currently all font is white

I have a version 9.1 installed in my local machine with macos 11.1 Need help in making the font color to black.
Angel Xandrea
  • 75
  • 10
4
votes
7 answers

Pantaho MySQL 8 connection error Driver class 'org.gjt.mm.mysql.Driver' could not be found

While upgrading ETL scripts for Mysql 5.8 to MySQL8 upgrade, as soon as I have updated the data-integration/lib jar to mysql-connector-java-8.0.xx.jar, it has started blowing with following error. Driver class 'org.gjt.mm.mysql.Driver' could not be…
Red Boy
  • 5,429
  • 3
  • 28
  • 41
4
votes
2 answers

how to check data exist in targeted table in pentaho pdi

M using pentaho spoon first time, i have one input table and i written one sql query, and want that the resulting data of the input table to store in different targeted table, but before storing the data in targeted table check whether the data all…
Ravindra Gupta
  • 1,256
  • 12
  • 42
4
votes
3 answers

Pentaho Data Integration (newest version) - Not detecting MySQL driver

I'm new to this tool and I'm trying to create MySQL connection to a database but when I press the 'Test' button it apears this message: Error connecting to database [MySQL (_configuracionesEF)] :org.pentaho.di.core.exception.KettleDatabaseException:…
MikeVelazco
  • 885
  • 2
  • 13
  • 30
4
votes
3 answers

Overflow Exception when trying to write to Sql Server column with decimal(38,0) type from Pentaho

I'm trying to run a job which moves data from a set of tables in an Oracle connection to an Sql Server One. But I'm getting the following exception which causes the job stopping : 2017/04/04 11:00:56 - read from [DEMANDE].0 - ERROR (version…
mounaim
  • 1,132
  • 7
  • 29
  • 56
4
votes
4 answers

Pentaho | GC overhead limit exceeded

I want to insert data from xlsx file into table. Excel has around 1,20,000 records. But while running transformation, I am getting below error: GC overhead limit exceeded I have changed in spoon.bat. Xmx2g -XX:MaxPermSize=1024m But still I am…
Nilesh Patil
  • 91
  • 2
  • 11
4
votes
1 answer

Want to convert String data type into Date data type in pentaho

I have a string which has a date in this format: n_date=2014-04-20 I want to convert it into date data type var Final_date = str2date(n_date,"yyyy-MM-dd"); but I get an error. I'm do this in pentaho
Mudi
  • 95
  • 1
  • 2
  • 13
3
votes
1 answer

REST API calls through Pentaho Data Integration (Spoon)

Hello Pentaho Experts, I am attempting to make a REST API call through REST Client in Pentaho. I have a Api key for authentication. I tried it in Postman, and it works perfectly fine, but Pentaho throws 403 status code. Below is the postman…
Nikhil
  • 621
  • 1
  • 13
  • 25
3
votes
1 answer

Google Dataproc writing from a client app uses cluster's internal IP for Datanodes

I have setup a Dataproc cluster on Google Cloud. It is sup and running and I can access HDFS and copy files from the SSH 'in browser" console. So the problem is not on the Dataproc side. I am now using Pentaho (ELT software) to copy files. Pentaho…
Jean-François Monteil-Lemoine
  • 102
  • 7
1
2 3
…
54 55