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

Recent Activity

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
Bill Wallace
I have an issue with creating database connections in Spoon (pdi-ce-8.0.0.0-28) on Windows 10. The error I receive is: java.lang.IllegalArgumentException: Argument not valid Then subsequently: General error in dialog   The trace from the first error is attached.   I saw a similar error posted here however I am using Java 8 when the solution… (Show more)
in Data Integration
Alex Bitz
Hello, I'm not sure if this is the right place for this I am trying to connect to a Rest API through Pentaho Data Integration. Using API Tester I can connect and get a proper response body quite easily so I know it works, but I can't for the life of me get it to work in Pentaho. I keep getting a "Error finding field [Authorization] in incoming… (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
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
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
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
Load more items