Profile

Rob Burgess

This individual is no longer active. Application functionality related to this individual is limited.

Contact Details

My Content

1 to 11 of 11 total

RE: Jdk-13.0.1 and Jdk-13.0.2 not working for PDI 9

Posted By Rob Burgess 02-11-2020 17:35
Found In Community: Pentaho \ view thread
Thanks Sebastian

RE: Jdk-13.0.1 and Jdk-13.0.2 not working for PDI 9

Posted By Rob Burgess 02-11-2020 17:19
Found In Community: Pentaho \ view thread
Thanks Ana   Do you know where I can download Oracle OpenJDK 8?

Jdk-13.0.1 and Jdk-13.0.2 not working for PDI 9

Posted By Rob Burgess 02-11-2020 01:08
Found In Community: Pentaho \ view thread
jdk-13.0.1 works for PDI 8.30 but I get the following error on Windows Server 2012 R2 when trying to open Spoon from the PDI 9 folder:   Error: Could not create Java Virtual Machine   The system variable JAVA_HOME = C:\Program Files\Java\jdk-13.0.1 and C:\Program Files\Java\jdk-13.0.1\bin has been added ...

RE: What is the best way to count the number of files in a folder that start with a particular letter (P)?

Posted By Rob Burgess 10-31-2019 00:55
Found In Community: Pentaho \ view thread
Thanks Dean. That worked well.

What is the best way to count the number of files in a folder that start with a particular letter (P)?

Posted By Rob Burgess 10-29-2019 03:52
Found In Community: Pentaho \ view thread
#PentahoDataIntegrationPDI #Kettle #Pentaho

Check if file exists in folder and return True or False

Posted By Rob Burgess 06-13-2018 17:59
Found In Community: Pentaho \ view thread
Whats the best way to check if a file exists in a folder using regex, then return true if the file exists or false if the file is not found. #Kettle #Pentaho #PentahoDataIntegrationPDI

List Files in AWS S3 Bucket

Posted By Rob Burgess 05-18-2018 18:14
Found In Community: Pentaho \ view thread
What is the best way to list the files in an AWS S3 bucket using a Job or Transformation? #Kettle #Pentaho #PentahoDataIntegrationPDI

RE: Return ResultSet from SQL Server Stored Procedure With Multiple Parameters

Posted By Rob Burgess 05-17-2018 20:44
Found In Community: Pentaho \ view thread
Thanks Lucas. I will try this.

Return ResultSet from SQL Server Stored Procedure With Multiple Parameters

Posted By Rob Burgess 05-17-2018 18:56
Found In Community: Pentaho \ view thread
How do you return a ResultSet from a SQL Server stored procedure with multiple parameters? I understand you can use the Table Input step but I am unsure of the syntax to execute the stored procedure with more than 1 parameter. #Kettle #Pentaho #PentahoDataIntegrationPDI

RE: Return Dataset using SQL Server Stored Procedure parameters

Posted By Rob Burgess 04-11-2018 23:41
Found In Community: Pentaho \ view thread
Thanks Rafael I want to run the Store Procedure then write the returned dataset to Excel. When I run the DB Procedure and click on the Preview data tab in Spoon I get three columns with no data. The first two column headings are called the IN parameters names  and last column is called result. The transformation ...

Return Dataset using SQL Server Stored Procedure parameters

Posted By Rob Burgess 04-11-2018 02:17
Found In Community: Pentaho \ view thread
How do I execute a SQL Server stored procedure with parameters and return a dataset in a Kettle transformation? #Pentaho #PentahoDataIntegrationPDI #Kettle