Profile

Johan Hammink

Contact Details

My Content

1 to 20 of 50+ total
Posted By Johan Hammink Oct 13, 2020 12:35 PM
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
Posted By Johan Hammink Sep 4, 2019 8:15 AM
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
Posted By Johan Hammink Aug 23, 2019 7:34 AM
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 ...
Posted By Johan Hammink Aug 23, 2019 7:05 AM
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
Posted By Johan Hammink Aug 1, 2019 11:46 AM
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.
Posted By Johan Hammink Jul 26, 2019 5:37 AM
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
Posted By Johan Hammink Jul 25, 2019 4:50 AM
Found In Community: Pentaho
\ view thread
Just calculate it with for example a formula step ([temp_fahrenheit]-32)/1.8
Posted By Johan Hammink Jul 24, 2019 5:38 AM
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
Posted By Johan Hammink Jul 23, 2019 5:25 AM
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 ...
Posted By Johan Hammink Jul 22, 2019 5:23 AM
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
Posted By Johan Hammink Jul 17, 2019 5:05 AM
Found In Community: Pentaho
\ view thread
All the steps are supported by Metadata Injection.
Posted By Johan Hammink Jul 15, 2019 5:36 AM
Found In Community: Pentaho
\ view thread
Something like http://localhost:8080/kettle/executeJob?job=c:/directorie/job.kjb
Posted By Johan Hammink Jul 12, 2019 9:26 AM
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
Posted By Johan Hammink Jul 11, 2019 6:08 AM
Found In Community: Pentaho
\ view thread
Yes you should enable that. Also check in properties if it is enabled
Posted By Johan Hammink Jul 10, 2019 10:50 AM
Found In Community: Pentaho
\ view thread
Is in the SQL server Network Configuration the TCP/IP enabled for port 1433 ?
Posted By Johan Hammink Jul 9, 2019 12:52 PM
Found In Community: Pentaho
\ view thread
And of course you can also use the Data Validator step
Posted By Johan Hammink Jul 8, 2019 9:55 AM
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
Posted By Johan Hammink Jul 2, 2019 10:38 AM
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 ...
Posted By Johan Hammink Jul 2, 2019 5:15 AM
Found In Community: Pentaho
\ view thread
Is your CE installation a new / fresh installation? It should work. Otherwise you can download plugins : https://marketplace.hitachivantara.com/pentaho/ Place the plugin then in the correct directory. ..\data-integration\plugins or ..\data-integration\plugins\steps
Posted By Johan Hammink Jun 28, 2019 9:47 AM
Found In Community: Pentaho
\ view thread
All steps are initialized when a transformation start. Then also the truncation take place. So when in your first step there is an error and no data comes to the table output step. The table is already truncated