Profile

Johan Hammink

Inergy

Contact Details

Inergy

My Content

1 to 20 of 50+ total

RE: pentaho 9.2 community version installation

Posted By Johan Hammink 04-19-2022 10:11
Found In Egroup: Pentaho \ view thread
I didn't encounter any problem when upgrading to version 9.2. ------------------------------ Johan Hammink Business Development Manager Inergy ------------------------------

RE: Connecting Web Services in Pentaho

Posted By Johan Hammink 02-04-2022 08:44
Found In Egroup: Pentaho \ view thread
In a transformation with a REST Client or a Web service lookup step ------------------------------ Johan Hammink Business Development Manager Inergy ------------------------------

RE: Error when trying to change a Tranformation step's settings in a job in PDI 9 community edition

Posted By Johan Hammink 10-13-2020 12:35
Found In Community: Pentaho \ view thread
I got the same error in version 9.0. But in version 9.1 all works as expected. So I guess they solved the problem

RE: Issue with spoon

Posted By Johan Hammink 09-04-2019 08:15
Found In Community: Pentaho \ view thread
What kind of error message do you get when you try to connect to the database? Which driver file are you using? Java8 is not supporting ODBC connections

RE: Kettle Jobs Won't Run Transformations

Posted By Johan Hammink 08-23-2019 07:34
Found In Community: Pentaho \ view thread
Where are the transformations stored? It is now looking in the directory /public/transformations. The variable $(Internal.Job.Repository.Directory) is pointing to that directory. When transformation for exemple is stored in /home/admin folder you can also point to that transformation as /home/admin/trasformation ...

RE: How do I delete folders and files in my pentaho directory using rest api

Posted By Johan Hammink 08-23-2019 07:05
Found In Community: Pentaho \ view thread
For documentation about api in Pentaho see : https://help.pentaho.com/Documentation/8.3/Developer_center/REST_API_Reference/File_Management/0O0

RE: "Not enough rights to object" error

Posted By Johan Hammink 08-01-2019 11:46
Found In Community: Pentaho \ view thread
The h2 database is a file situated in ..\data-integration\samples\db\sampledb.h2.db. I think you dint have permissions to change that file.

RE: Analysis scheme not found when creating new Analysis report

Posted By Johan Hammink 07-26-2019 05:37
Found In Community: Pentaho \ view thread
Are you sure the the mondrian xml is correct? Did you refresh the Mondrian Schema Cache in the Pentaho server? Talking about Analysis Report, you are working with the Enterprise Edition. So you are a customer of Pentaho and can also ask the Pentaho support

RE: Fareinheit to celsius conversion

Posted By Johan Hammink 07-25-2019 04:50
Found In Community: Pentaho \ view thread
Just calculate it with for example a formula step ([temp_fahrenheit]-32)/1.8

RE: Restart Carte server every 24 hours on Windows VM server

Posted By Johan Hammink 07-24-2019 05:38
Found In Community: Pentaho \ view thread
The command to stop carte is : carte.bat 127.0.0.1 8080 -s -p password -u user see: https://help.pentaho.com/Documentation/8.3/Products/Use_Carte_Clusters These settings I use for jobs which are always running and the sceduling is set in the job

RE: Restart Carte server every 24 hours on Windows VM server

Posted By Johan Hammink 07-23-2019 05:25
Found In Community: Pentaho \ view thread
just put the command line to start the carte server in a bat file. I would put 2 lines in the bat file. First to stop the carte server example when carte.bat file in same directory as bat file carte.bat 127.0.0.1 8080 -s -p password -u user and the second line to start the server carte.bat 127.0.0.1 ...

RE: How to integrate PDI and BI Server

Posted By Johan Hammink 07-22-2019 05:23
Found In Community: Pentaho \ view thread
When you use a Pentaho repository to store your transformations and jobs. You can execute them from whithin the pentaho server. You dont need xaction files to do that

RE: Optimal way to join multiple files and output without creating multiple transformations

Posted By Johan Hammink 07-17-2019 05:05
Found In Community: Pentaho \ view thread
All the steps are supported by Metadata Injection.

RE: How to expose job as api using carte sever

Posted By Johan Hammink 07-15-2019 05:36
Found In Community: Pentaho \ view thread
Something like http://localhost:8080/kettle/executeJob?job=c:/directorie/job.kjb

RE: How to read a html file as input?

Posted By Johan Hammink 07-12-2019 09:26
Found In Community: Pentaho \ view thread
There is a plugin in the Marketplace HTML to XML. That step in inspired by a blogpost by Roland Bouwman http://rpbouman.blogspot.com/2011/05/using-tidy-to-clean-webpages-with.html

RE: Establishing connection with MS SQL server in spoon

Posted By Johan Hammink 07-11-2019 06:08
Found In Community: Pentaho \ view thread
Yes you should enable that. Also check in properties if it is enabled

RE: Establishing connection with MS SQL server in spoon

Posted By Johan Hammink 07-10-2019 10:50
Found In Community: Pentaho \ view thread
Is in the SQL server Network Configuration the TCP/IP enabled for port 1433 ?

RE: Data Validation before moving on to the next step

Posted By Johan Hammink 07-09-2019 12:52
Found In Community: Pentaho \ view thread
And of course you can also use the Data Validator step

RE: Truncate table in Table Output step

Posted By Johan Hammink 07-08-2019 09:55
Found In Community: Pentaho \ view thread
You are correct that the truncation will be rollback when an error occur when Make the tranformation database transactional in the Miscellaneous tab in the Transformation properties. The database must also allow that

RE: No plugin in the marketplace

Posted By Johan Hammink 07-02-2019 10:38
Found In Community: Pentaho \ view thread
When nothing happens when executing spoon it is offen due to the fact it cant find the Java installation. See  Set Environment Variables in https://help.pentaho.com/Documentation/8.2/Setup/Installation/Manual/Linux_Environment And you work with a VM. Has the VM internet access? Installing plugins needs ...