Activity Stream - Pentaho Community Forums

Sort By	Time	Show
Recent Recent Popular Popular	Anytime Anytime Last 7 Days Last 7 Days Last 30 Days Last 30 Days	All All Photos Photos Forum Forums

Today, 12:45 AM

barney-2074 started a thread Extracting data from a headings in a text file in Pentaho Data Integration [Kettle]

Hello, I am trying to extract data from a file in the following format into a tabular form, with the text in red repeated for each record beneath...

0 replies | 34 view(s)

Yesterday, 05:24 AM

Ana GH replied to a thread Kettle 8.2: Database lookup error with sqlserver in Pentaho Data Integration [Kettle]

Yep, 8.1 had some nasty bugs, so beware for some other unpleasant surprises, maybe downgrading 8.0 would be safer if 8.2 has that bug stopping you....

3 replies | 63 view(s)

02-21-2019, 11:16 AM

Vineeth Modon started a thread Password not getting updated after recreating a user till server restart in BI Platform

Password not getting updated after recreating a user till server restart The issue can be reproduced by following below steps Log onto pentaho...

0 replies | 47 view(s)

02-21-2019, 06:52 AM

Sparkles replied to a thread Kettle 8.2: Database lookup error with sqlserver in Pentaho Data Integration [Kettle]

You downgraded from 8.2 to 8.1 because of a bug? I've heard others upgrade from 8.1 to 8.2 because of bugs... I'm still on 5.4, not sure if...

3 replies | 63 view(s)

02-21-2019, 05:36 AM

anietorp replied to a thread Kettle 8.2: Database lookup error with sqlserver in Pentaho Data Integration [Kettle]

Just to add information: If I try to get lookup fields, datetime field are filled with "none" type. I downloaded 8.1 PDI and it works! I think...

3 replies | 63 view(s)

02-21-2019, 04:52 AM

anietorp started a thread Kettle 8.2: Database lookup error with sqlserver in Pentaho Data Integration [Kettle]

Hi, I recently updated Kettle from 7.1 to 8.2. With 7.1 I had not problem. With 8.2 version, in Database lookup step with sql server (2008...

3 replies | 63 view(s)

02-20-2019, 02:49 PM

Sparkles replied to a thread Copy rows to result behavior in Pentaho Data Integration [Kettle]

That sounds good exactly how you describe it there. I created a jira ticket. It may very well not be intented for these sorts of things, but it is...

3 replies | 66 view(s)

02-20-2019, 12:57 PM

gutlez replied to a thread Copy rows to result behavior in Pentaho Data Integration [Kettle]

Hint: Detect Empty Rows step will send a row of all nulls if no rows reach it. It would probably be a good feature ask ( http://jira.pentaho.com )...

3 replies | 66 view(s)

02-20-2019, 12:48 PM

gutlez replied to a thread Regarding Select Value step in kettle in Pentaho Data Integration [Kettle]

From what I recall, rebuilding the row is an expensive step. So your best bet would be to do all your joins, and then before sending the data to the...

2 replies | 50 view(s)

02-20-2019, 07:03 AM

Sparkles replied to a thread Copy rows to result behavior in Pentaho Data Integration [Kettle]

I have never found any satisfying documentation for the dirty details of result rows. It seems like nobody knows exactly how this works. Only way to...

3 replies | 66 view(s)

02-20-2019, 06:44 AM

Sparkles replied to a thread Regarding Select Value step in kettle in Pentaho Data Integration [Kettle]

It could be potentially bad for performance, each step should be more "work". But removing fields could give great boost to some steps also. It can...

2 replies | 50 view(s)

02-20-2019, 03:49 AM

hsaxena20 started a thread Regarding Select Value step in kettle in Pentaho Data Integration [Kettle]

Hello, Is it good to use select value step many times in a dashboard kettle? Because if we are having 10 columns in the input stream and want to...

2 replies | 50 view(s)

02-19-2019, 05:17 PM

greyyfox7 started a thread BigQuery error with pentaho 8.2 using table output step in Pentaho Data Integration [Kettle]

We did a pentaho big query with a simple data row generator for 3 coloum and the same column was added to the target ( big query) . Here we used...

0 replies | 60 view(s)

02-19-2019, 12:41 PM

wisleyvelasco started a thread Execute R Script - Access Denied to jri.dll in Pentaho Data Integration [Kettle]

Hello! I'm using the "Execute R Script" step to execute R code, but, I'm having a problem executing a transform that uses this step. Because of...

0 replies | 38 view(s)

02-19-2019, 11:23 AM

clarkddc started a thread Copy rows to result behavior in Pentaho Data Integration [Kettle]

I'm following this guide located at https://www.clearpeaks.com/copy-rows-to-result-in-kettle/. I'm using the REST client in one transformation to...

3 replies | 66 view(s)

02-19-2019, 10:21 AM

R2-G2 started a thread Property Input not including subfolders in Pentaho Data Integration [Kettle]

When configuring the property input to use subfolders, it won't work, while the text file input will. Has anyone encountered the same thing? Am I...

0 replies | 50 view(s)

02-19-2019, 07:52 AM

Ana GH replied to a thread Scope of variables Different between kettle 5 and kettle 8 in Pentaho Data Integration [Kettle]

The buggy version with problems with variables was the Pentaho 8.1 version, Pentaho 8.0 and Pentaho 8.2 should be OK in that part. @zxx2403, sorry,...

2 replies | 67 view(s)

02-18-2019, 09:33 AM

Sparkles replied to a thread Scope of variables Different between kettle 5 and kettle 8 in Pentaho Data Integration [Kettle]

Hasn't there been several discussions about bugs in version 8? I would try the latest version before looking for differences or bugs.

2 replies | 67 view(s)

02-18-2019, 04:47 AM

zxx2403 started a thread Scope of variables Different between kettle 5 and kettle 8 in Pentaho Data Integration [Kettle]

Hi All, I have a job run at kettle 5.0.0.CE successfully. but when i run the same job on kettle 8.0.0.5 CE . It raise a error. I check the...

2 replies | 67 view(s)

02-18-2019, 12:08 AM

dobeslao replied to a thread PDI (8.2) Status SVG file not found in Pentaho Data Integration [Kettle]

Thanks Hiromu for the references, i will look for the code patch.

2 replies | 111 view(s)

02-15-2019, 02:27 PM

hiromu replied to a thread Diff utility for KTR files in Pentaho Data Integration [Kettle]

Please try SpoonGit (https://github.com/HiromuHota/pdi-git-plugin), which has visualdiff feature. This plugin is also available from the Marketplace.

3 replies | 834 view(s)

02-15-2019, 02:25 PM

hiromu replied to a thread PDI (8.2) Status SVG file not found in Pentaho Data Integration [Kettle]

This is a known issue (https://jira.pentaho.com/browse/PDI-17760) and has been resolved by...

2 replies | 111 view(s)

02-15-2019, 08:50 AM

KnifeFite started a thread 8.2 CE Google Drive API how to see folders in Pentaho Data Integration [Kettle]

Hi, I am exploring new feature to connect to Google Drive, following a blog i found online(not sure if i am allowed to post a link here). I have...

0 replies | 57 view(s)

02-15-2019, 07:55 AM

mashraf replied to a thread HTTPS call failing when calling the rest API in Pentaho Data Integration [Kettle]

can you pls advise what params did you set ?

2 replies | 553 view(s)

02-15-2019, 06:18 AM

Jahnavi started a thread Replace new line character(\n) in String using "Replace in String" step in Pentaho Data Integration [Kettle]

Hi All, Please suggest me how to replace new line character(\n) in String using "Replace in String" step. I have tried with \n in "Replace in...

0 replies | 52 view(s)

02-12-2019, 07:56 PM

MacPhotoBiker started a thread Looking for efficient way to transfer a large table (Partitioning the input table?) in Pentaho Data Integration [Kettle]

Hi, I'm trying to transfer a local Oracle table with 22 million rows to an Azure SQL database (plain transfer, no transformations). On the "table...

0 replies | 71 view(s)

02-12-2019, 02:38 PM

renato.droguett replied to a thread Rest API CDA for Report in Pentaho Data Integration [Kettle]

anyone?

1 replies | 121 view(s)

02-12-2019, 12:26 PM

gutlez replied to a thread Longest match in Pentaho Data Integration [Kettle]

I feel like tree string splitting this with string structures would be more CPU efficient (and also time efficient), and potentially a way to...

4 replies | 109 view(s)

02-12-2019, 12:00 PM

nif replied to a thread Error : CDF : Object type *Component* can't be mapped to a valid class in Community Tools - CTools

Pic of error : https://nsa40.casimages.com/img/2019/02/13/190213041459560182.jpg

1 replies | 96 view(s)