ETL jobs, ETL transforms, Spoon, Carte...
Dear Kettle fans, I'm just leaving a small sticky note to inform you of the general availability of Pentaho Data Integration (Kettle) version...
Hello Kettle, Pentaho Data Integration enthusiast! Thank you for taking the time to drop in for a visit to this forum. It's for certain one of...
You are obviously the stubborn or free-spirited kind. Especially YOU should read this post: http://forums.pentaho.org/showthread.php?t=71633
Has any one tried to do date time arithmitic using the PDI objects. I did find in the calculator object that you can add time to a data time but not...
Hello all, I am using PDI for my project and I am running it from java application. As PDI is using its own logging configuration I wanted to...
I'm using Kettle v.3.2.0-GA and I'm trying to share my connection informations so I can change it in the kettle.properties. To do this I'm working...
Hi, I created with Design Studio an action sequence to execute a Kettle job, but it fails and I don't see what I'm doing wrong. In fact, I reduced...
Hi everyone, I have developed an Open Source Google Analytics plugin for Kettle, that allows you to easily get data from Google Analytics using...
One of the ways we have been taught to identify changes for a slow changing dimension is to calculate and store a CRC value for the entire row. The...
Hi! I'm trying to create a table that allows me to know for each article the date(s) where it happen a stock zero or negative and the next date with...
Hi All, I am using Pentaho 3.2.0. I have a transformation like follows Excel Input -> Table Output. For automation I want to give the file...
I looked and searched but didn't see anything on how to do this. How can I use Pan to run a transform on a carte server. I have: - Setup...
Hi, Can I run the same transformation more than once at a time in Kettle 4.0 version Carte? Thanks, Tata
Hi Everyone, I have a requirement where i need to run set of transformations in parallel in Carte server. As Kettle 3.2.0 does not allow me run...
Hello everyone, I just read an article about SAP Connectivity with Pentaho 4 CE...
Hi All, I am using Pentaho 3.2.0. I have a transformation Table input ->Insert/Update. I want to truncate the target table after table input. I...
There appears to be a problem with Kitchen on 64 bit Vista. I say this because I have seen the problem with a few other java apps. Spoon works...
Dear Forum members, we are using PDI 4.0.0 together with Amazon EC2 and Amazon RDS. The solution works perfectly, but there are huge connection...
This is my first complaint: Gads the new format of the forum page is hard to get used to. I'm on the verge of writing a transform to download the...
Hi. At the moment using the Filter Row step is possible to use only one condition. If a record satisfy that condition it goes to TRU, otherwise it...
Hi All, Within a Job I have an "Get Files via FTP" job entry that uses REG EX within the Specify File(s) to retrieve and it works! I thought...
I've created a transformation and I've defined the transformation "fields to log" for it. After saving it when I open again the transformation...
Hello everyone, I'm new in all this whole datawarehousing topics but first I'd like to thank you all for this huge commmunity effort. My...
Hallo, as an internal service provider we want to internaly "sell" our ETL activities to our departments using the total amount of data...
Hi there ! I wish to get a file from a FTP where there is 10 files named similarly, with the date at the end. Example: file_20100826.csv...
Hi All, I've had a whole bunch of trouble connecting to my oracle db via OCI in 4.0.x I've tried looking at classpaths, environment variables...
Hi all, I am using PDI 4(Agile BI) on a windows platform. When I right click on "table output" and select visualize>>Analyzer , I am getting...
Hi guys, i have a problem with the xml structure that i want. Basically i have two tables one to many below: <STAFF> ID_STAFF|Name| 1|John|...
Hi all, I'm wondering if anyone knows of a way to execute VBA (or perhaps do something else) to manipulate an Excel file? Unfortunately, the...
Hello, Forgive me if it is a silly question. I have a file stream wich I get the follow collums: Field1, Field2, Field3, Field4 Then I'd...
Hi, I am using a PDI 4.0.0-stable Build Date: 2010-06-15 11.00.26 I am writing a very complex and big transformation in which I have lot of...
This may be obvious but I'm stumped ... using kitchen.sh and kitchen.bat, how can I pass a parameter to be used as "command line argument 1" used...
Hi all, i downloaded the RC1 of PDI Version 4 and i`m interested in using the experimental transformation step "Script". what must is do, for...
Use this control to limit the display of threads to those newer than the specified time frame.
Allows you to choose the data by which the thread list will be sorted.
Order threads in...
Note: when sorting by date, 'descending order' will show the newest results first.
Forum Rules