Skip navigation
Log in to follow, share, and participate in this community.

Recent Activity

Shankar Panda
Hi,   I tried to multithread it by appending the sql script "where clientid % ${Internal.Step.Unique.Count} = ${Internal.Step.Unique.Number}" and used 2 no's of copy to next step. But only one copy is processing data, not the other one.   Could you please help me on how to multithread it to process parallely. Note: The data should not be… (Show more)
in Data Integration
Kamil Nesetril
I want to let users store input files (csv, Excel) the Pentaho repository and I want to use it by PDI. I know that Pentaho repository is not a file system (but can be sync with it by Pentaho Repository Synchronizer).
in Data Integration
Rik Bormans
Until now I used Pentaho DI 6 without any problems to extract data from SAP via SAP input and RFC. But whenever I try to use a higher version of pentaho, the app crashes. I've installed the latest SAPJCO version (patch17) but still it crashes. Could anyone please help in this?
in Data Integration
Jakub Zbudniewek
I'm missing GEO features in PDI which I used to use in GeoKettle (Open Source GeoBI » GeoKettle ). How both solutions now relate? Should I use them as separate installations or can I have everything in one place?
in Data Integration
Michael Zandstra
Hi, I was wondering if somebody could help me with probably something relatively easy. I would like to use https://api.fixer.io/latest to add some currencies into my Date Warehouse. I would like to add them row by row so in a table like ( currency CHAR(4), value REAL). Is this possible with the JSON Input? Or should I go for a table like (AUD… (Show more)
in Data Integration
Shankar Panda
HI All, I am joining 6 tables and writing the results to a target table in SQL server. One of the base table has data over:14702380 records. I tried 3 options. 1. Placed the sql query in the table input and tried to run. It took more than 45 minutes 2. Used merge join 5 times , this took more than 1 hour 3. Used multiway merge join, this gave… (Show more)
in Data Integration
Gert Wieland
Hi community,   I'm trying to dynamically generate a simple list of consecutive numbers, for example from 4 to 8000. The min and max values are calculated based on a separate list, but this list has gaps (e. g. 4, 5, 8, but 6 and 7 are  missing).   My goal is to merge the two lists, and filter for the gaps, so in the example above I'd only get 6… (Show more)
in Data Integration
Aslee Guirola
Saludo Comunidad. Estoy trabajando PDI_CE_8.0.0.0-28 y cuando pongo el steps SAP Input me devuelve un error com.sap.conn.jco.ConversionException: (122) JCO_ERROR_CONVERSION: Cannot convert field FECHA of type CHAR to StructureRecord. como puedo solucionarlo? La entrada de dato la hago mediante un Data Grid.
in Data Integration
Heena Kaushik
We are using Pentaho PDI data integration to run transformation and output the data to  oracle database table. But before uploading the files to the database table I want to Delete old backup table. Create a new backup table using data from old table Then upload the file in the database Example use case– Ideally The output of the above ktr… (Show more)
in Data Integration
Load more items