Hello everybody, in the PDI documentation it talks about an object that allows bulk load on Amazon Redshift Bulk load into Amazon Redshift but in my PDI installation I can't find it. I have searched both in jobs and transformations. I'm using the version 9.2.0.0-290 (Build date 2021-06-02) I can...
Im needing to pull out IP Address and Name from the following XML using the Get Data from XML step but cant figure it out. Since both values are at the same level, what do do do for xpath to get both values out into a single row / 2 columns for this server? ...
#PentahoDataIntegrationPDI #Kettle #Pentaho
Good morning everyone. Im having a problem with Pentaho. For example, I installed the PDI Client on the data team members Windows and Linux machines, and they are building the jobs by consuming .csv files from a directory on the network that has been mapped to their machine, and the jobs are...
After upgrading Mac OS to Big Sur 11.5.2, Pentaho spoon(spoon.sh) is crashing when opening the database connection wizard. Error from the command line: Assertion failed: (backing->lock access > 0), function CGSBackingStoreUnlockReader, file /System/Volumes/Data/SWE/macOS/BuildRoots/d7e177bcf5...
Hi, earlier i was using Pervasive ETL tool and have created number of ETLs and as now my organization has decided to use Kettle, can i migrate already created ETLs to Kettle tool ( with minor changes) #Kettle #PentahoDataIntegrationPDI #Pentaho
Hello, I am using PDI 9.1.0.0-324 (Community edition) with a MySQL 5.1 repository. I also use the mysql-connector-java-5.1.49-bin.jar library. When I want to open some transformations, I get the error: A database error occured reading a transformation from the repositoryorg.pentaho.di.core...
Hi Team, I am trying to download Pentaho PDI pdi-ce-8.1.0.0-365.zip in our aws server machines using below powershell scripts with download URL https://excellmedia.dl.sourceforge.net/project/pentaho/Pentaho%208.1/client-tools/pdi-ce-8.1.0.0-365.zip . It was working properly till last month. But...
I have a transformation that posts XML to a web service and then records the XML result in a field. I feed that field into the XML input stream. The XML input stream needs one row per element but I dont want to do the HTTP post 50 times each time. How can I get the input stream to add as many...
Hi I just downloaded and unzipped the latest PDI version 9.1-324 from sourceforge. I unzipped it on my win 10 laptop. Does anyone know where I can find the jar file that contains this missing class? Exception in thread main java.lang.NoClassDefFoundError: org/pentaho/vfs/ui/VfsResolver ...