Profile

David da Guia Carvalho

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

Contact Details

My Content

1 to 20 of 50+ total

RE: pivot4J don't work on pentaho CE 8.3

Posted By David da Guia Carvalho 02-06-2020 19:41
Found In Community: Pentaho \ view thread
Hi,   try this one: http://downloads.meteorite.bi/saiku3/saiku-plugin-p7.1-3.15.zip I just check it and the download was open to the public...   And the lincence works on all versions (as far as i could test).

RE: pivot4J don't work on pentaho CE 8.3

Posted By David da Guia Carvalho 02-04-2020 12:11
Found In Community: Pentaho \ view thread
Sorry by my delay on the response but my account at hitachi havent been working properly for some time, I end up several days without access and idk why!   Well short anwser is: NO you dont need another server. But even if you do you could make a integration with a SSO and open the saiku inside pentaho. ...

RE: pivot4J don't work on pentaho CE 8.3

Posted By David da Guia Carvalho 01-27-2020 13:06
Found In Community: Pentaho \ view thread
The best choice for olap on CE right now is Saiku

RE: Does Pentaho supports SSO through OKTA ?

Posted By David da Guia Carvalho 01-27-2020 13:02
Found In Community: Pentaho \ view thread
Short anwser is yes. I never try it with OKTA but as it supports SAML you could use it with pentaho. The way would be: https://help.pentaho.com/Documentation/8.1/Setup/Administration/User_Security/Implement_Advanced_Security/Set_Up_SAML_for_the_Pentaho_Server https://support.pentaho.com/hc/article_a ...

RE: PDI read/write to Firebase

Posted By David da Guia Carvalho 09-23-2019 18:54
Found In Community: Pentaho \ view thread
Hi,   Im not aware of any steps, plugins or pre-build to access read/write firebase, but you may have at least 2 ways to accomplish that. 1 - REST API (just make the calls using a REST step) https://firebase.google.com/docs/reference/rest/database/#section-query-parameters 2 - Java API (under development) ...

RE: Any dashboard to control transformations and jobs mess?

Posted By David da Guia Carvalho 09-23-2019 14:57
Found In Community: Pentaho \ view thread
You could make jobs that represent complete subjects and multiple jobs to connect them, also metadata on the jobs/transformations and steps (like descriptions) are very helpful. In the past we got kettle-cookbook that read metadata and output html... the documentation step is not as good as cookbook ...

RE: Where can I find the installation documentation for pdi-ce-8.3.0.0-371?

Posted By David da Guia Carvalho 09-19-2019 12:16
Found In Community: Pentaho \ view thread
Hi,   There is actually some documentation as reference such as: Pre-req: https://help.pentaho.com/Documentation/7.1/0D0/160/000 Installation Method: https://help.pentaho.com/Documentation/8.2/Setup/Installation/Tools/PDI_Client_and_plugins Extras: https://help.pentaho.com/Documentation/8.2/Setup/In ...

RE: Database Repository (Azure): Keep connection open

Posted By David da Guia Carvalho 09-17-2019 19:30
Found In Community: Pentaho \ view thread
Just a opnion! Overall, Im not much fan of PDI DB repo. In the past a got a bad experience with it where as the repo grows it was becoming slower (to the point where it was impossible). Ok it was far down the 3.x and 4.x and from that time to these days a have been using file system repo for most of ...

RE: Database Repository (Azure): Keep connection open

Posted By David da Guia Carvalho 09-17-2019 10:48
Found In Community: Pentaho \ view thread
Hi,   As a cloud service my guess is that you are bound to have some connection issues. If you are on windows you could try:   To avoid dropping idle connections by a network component, the following registry settings (or their non-Windows equivalents) should be set on the operating system where the ...

RE: How to set up PDI CE for production environment ?

Posted By David da Guia Carvalho 09-16-2019 12:11
Found In Community: Pentaho \ view thread
1 - Yes   2 - Just tunning java (xmx,xms) , connections, drivers;   The rest is extras per project (like sync with repo, logs, notification email, etc);

RE: Where can I find an example java source code that runs transforms and jobs using the kettle API?

Posted By David da Guia Carvalho 09-16-2019 11:49
Found In Community: Pentaho \ view thread
I didnt use it but seems to be this one:   https://github.com/pentaho/pdi-sdk-plugins /*! ******************************************************************************** Pentaho Data Integration** Copyright (C) 2002-2017 by Hitachi Vantara : http://www.pentaho.com*********************************** ...

RE: How to set up PDI CE for production environment ?

Posted By David da Guia Carvalho 09-16-2019 11:36
Found In Community: Pentaho \ view thread
You have a very simple requirement, so lets keep it simple!   Development; As you only process flatfiles, and dont have limitation on access to a source, Developement env. can be the dev. workstations; Make your repository on filesystem (you dont need to start a real pdi rep) that way you can use ANY ...

RE: How to get directories in a Pentaho repository from Linux command line tool?

Posted By David da Guia Carvalho 09-13-2019 14:09
Found In Community: Pentaho \ view thread
Try the change:   FROM: http://pentaho.uites.isciii.es/pentaho   TO: http://pentaho.uites.isciii.es:8080/pentaho

RE: How to set up PDI CE for production environment ?

Posted By David da Guia Carvalho 09-13-2019 14:01
Found In Community: Pentaho \ view thread
First what you whants to accomplish as production env.? A basic PDI server can be as simple as a desktop install (uncompress) and execute kitchen/pan, or as complex as a full solution with other systems involved (gitlab,jenkins,cc,ct, custom scripts, carte,etc..)   Some stuffs to consider: 1 - Repository ...

RE: How to get directories in a Pentaho repository from Linux command line tool?

Posted By David da Guia Carvalho 09-13-2019 13:18
Found In Community: Pentaho \ view thread
Port problem? You state : using a browser, and typing the command telnet pentaho.uites.isciii.es 8080 But the connection is trying: http://pentaho.uites.isciii.es/ (80) Your repository conf. might be missing the 8080?

RE: Can we use Pentaho Data Integration Community Edition in Production Environment ?

Posted By David da Guia Carvalho 09-10-2019 14:21
Found In Community: Pentaho \ view thread
1 Yes we can! You can setup carte and use it in the spoon by add slave servers (or you can add and app from BA, i didnt test it yet); I only use with it, it is possible to use BA Server but I never tested it (as a cluster);   4 PDI CE in production yes, the most common (classic) for me is linux server ...

RE: Update only one record when I use insert / update

Posted By David da Guia Carvalho 09-10-2019 11:57
Found In Community: Pentaho \ view thread
Ops... somethings wrong... when I post it there was no new flow... srry!   The point is your input is not compatible with your flow to reach the solution that you whants! If you have a ID as unique and you are updating based on it that means your flow are sending all rows to be updated by the same value ...

RE: Can we use Pentaho Data Integration Community Edition in Production Environment ?

Posted By David da Guia Carvalho 09-10-2019 10:55
Found In Community: Pentaho \ view thread
1 ) Yes (I only play with it to test) 2 ) Yes (But at version 8 > I got some erros, I dont use it in production any more) 3) Yes, you can use a job and make a schedule on it (by start step) but I do use external tools to do that (cron/git/CI-CD); 4) Yes, CE its very stable, EE version gets you extra ...

RE: How to get directories in a Pentaho repository from Linux command line tool?

Posted By David da Guia Carvalho 09-10-2019 10:41
Found In Community: Pentaho \ view thread
2) Its common task having to add certificates to cacerts on https usage, so you have to find where is the cacerts been used by your java install (it might have more then one) and add the certificate to it. To accomplish that, you can use keytools to check the cacerts and add the cert to it if needed. ...

RE: How to get xcdf tags value inside a dashboard template?

Posted By David da Guia Carvalho 09-09-2019 14:39
Found In Community: Pentaho \ view thread
Why not use the standard html/js?   $(document).ready(function() ( document.title = blah ));   Or... in case of a specific template object just use ID?