Profile

Stephen Donovan

Hitachi Vantara

Contact Details

Hitachi Vantara

My Content

1 to 20 of 50+ total

RE: Pentaho 9.4 BigQuery input/output?

Posted By Stephen Donovan 04-11-2024 12:16
Found In Egroup: Pentaho \ view thread
The standard JDBC steps are part of CE, but the Bulk loaders are additional plugin-in in the EE version. CE EE ------------------------------ Stephen Donovan General IT Consulting & Implementation Pre-eminent Professional Hitachi Vantara ------------------------------

RE: Pentaho write to SAP BW

Posted By Stephen Donovan 01-09-2024 10:24
Found In Egroup: Pentaho \ view thread
I quick read of SAP BW it seems to be in memory backed by SAP HANA. https://help.sap.com/doc/saphelp_nw74/7.4.16/en-us/b2/e50138fede083de10000009b38f8cf/content.htm?no_cache=true You can use their driver and PDI to connect to Hana through strandard JDBC. https://blogs.sap.com/2014/09/04/creating-a- ...

RE: Hive data warehouse issues related to kerberos

Posted By Stephen Donovan 01-08-2024 08:45
Found In Community: Pentaho \ view thread
Not an answer to your version or CE issues.  But Pentaho 9.5 EE is CDP certified and uses Kerberos.  https://help.hitachivantara.com/Documentation/Pentaho/Data_Integration_and_Analytics/9.5/What's_new_in_Pentaho_9.5

RE: maven build problem: Failed to transfer file: https://repo.orl.eng.hitachivantara.com/artifactory/pnt-mvn/pentaho/mondrian/3.14.0.19-174/mondrian-3.14.0.19-174.pom.

Posted By Stephen Donovan 01-05-2024 10:21
Found In Community: Pentaho \ view thread
Worked for me today and not on VPN.  The 'trial license expired' may point to your own local issues with your build environment.

RE: Latest version of PDI (Pentaho)

Posted By Stephen Donovan 12-22-2023 12:29
Found In Egroup: Pentaho \ view thread
EE is currently at 10.0 (Nov '23).   There are service packs for the EE 9 series though 9.3.0.5 , 9.5.0.1 (Sep '23)  CE's current release is 9.4 (Nov '22) We began some more dramatic shifts towards containers and repackaging larger plugins in 9.4.  The result is a much thinner engine and faster start ...

RE: AES Password Encoder doesn't search kettle.properties in KETTLE_HOME env

Posted By Stephen Donovan 12-20-2023 17:39
Found In Community: Pentaho \ view thread
Tobias, AES Encryption is an EE feature.  If you have an EE license and are still having issues, please file a Support ticket and we will attempt to assist.   If you are using CE, you will likely dig deep enough to see a null pointer or class not found exception.

RE: Pentaho 9.5 community download

Posted By Stephen Donovan 12-20-2023 11:45
Found In Egroup: Pentaho \ view thread
I did want to take the opportunity to explain the old forums.  It was a definitely a point of multiple discussions internally.  The software that was used had fallen out of support.  We were able to transition the old forums to read only mode, while the new one was created.  Unfortunately, a security ...

RE: PDI 9.2 : Edit jobs/transformations - 401 unauthorized

Posted By Stephen Donovan 12-20-2023 11:31
Found In Egroup: Pentaho \ view thread
From the client side error, I would think it could be related to caching as you shift the client between 9.2 to 9.4.   Clear the dbcache from ~/.kettle.  To allow cleaner switching between versions I use $KETTLE_HOME and change per version, so that I do not use the same ~/.kettle folder.  You can check ...

RE: Pentaho 9.5 community download

Posted By Stephen Donovan 12-18-2023 13:34
Found In Egroup: Pentaho \ view thread
The link to our build site was temporarily exposed and available.  This inadvertent mistake was fixed, as you surmised. We are currently undergoing a cloud deployment transition and are moving forward under new licensing models for 9.5 and 10.0.  While 9.3 EE is an LTS release, it is continuing to ...

RE: Performance issue with SQL query using Tableinput on Postgresql

Posted By Stephen Donovan 12-08-2023 11:43
Found In Egroup: Pentaho \ view thread
I want to clarify what you posted.  You are saying the same query run though pgAdmin SQL window and the table input step do not have the same execution plan?  I can honestly say I have not seen that.  The query is passed along through the jdbc driver, it should not be "different". Let's look for differences ...

RE: Restricting access to .../pentaho/kettle/status

Posted By Stephen Donovan 11-30-2023 14:12
Found In Community: Pentaho \ view thread
"Asking a HV person how to work around CE limitations is probably pushing my luck" #facts You may indeed be able to work with tomcat restrictions to limit access to those URL endpoints.  Not my skillset.  There may be options in the authentication filter chain in Spring.   I will have to defer to the ...

RE: Restricting access to .../pentaho/kettle/status

Posted By Stephen Donovan 11-30-2023 11:19
Found In Community: Pentaho \ view thread
I believe that I may have mislead you.  As I dug in, the UNAUTHORIZED message is from line 78 of RoleBoundCarteServlet.  Which is 'com.pentaho.pdi'. [aka Enterprise Edition]. 78: resp.sendError( HttpServletResponse.SC_UNAUTHORIZED, BaseMessages.getString( CLASS, "RoleBoundCarteServlet.Response.Unauthorized" ...

RE: Prerequisite to install Pentaho 9.4 community edition

Posted By Stephen Donovan 11-29-2023 09:27
Found In Community: Pentaho \ view thread
1) To add to Mladen's response, the machine images in both AWS and Azure are 9.5 EE and start with a PostgreSQL repository already configured.  You can be up and running in minutes and only pay for what you use.  As noted, they also come with a 30 day trial.  When you begin a trial, you will have access ...

RE: Restricting access to .../pentaho/kettle/status

Posted By Stephen Donovan 11-27-2023 16:22
Found In Community: Pentaho \ view thread
NOTE: if you have not, you can also add the status page to the Tools menu by editing tomcat/webapps/pentaho/mantle/xul/mantle.xul and uncommmenting the entry.

RE: Restricting access to .../pentaho/kettle/status

Posted By Stephen Donovan 11-27-2023 16:11
Found In Library: Pentaho

RE: Restricting access to .../pentaho/kettle/status

Posted By Stephen Donovan 11-27-2023 15:18
Found In Community: Pentaho \ view thread
I thought you can edit the /pentaho-solutions/system/kettle/slave-server-config.xml to restrict access to the /status directive, as well as, anything else.  Note, because you are blocking the API call, there is no message, just an error that something went wrong (as if the URL did not exist).  The page ...

RE: KTR's from PDI v7.0 not working in v9.3 - User defined java class step

Posted By Stephen Donovan 11-27-2023 09:37
Found In Community: Pentaho \ view thread
I was thinking Java 8 vs 11, base libraries, imports etc.  But Mike's test clears some of those concerns. One simple "test" is to do exactly what Mike did and drag a new UDJC step paste the code and attach it to the pipeline.  The "null" message may point to an XML element missing from the version 7 ...

RE: Transformation stays at idle PDI 9.4 with SQL Server 2016

Posted By Stephen Donovan 10-30-2023 11:45
Found In Community: Pentaho \ view thread
Good thnking.  SQL Server 2016 (and SQL server in general) is notorious for page level locking on indexes.  It is not a clean on maintaining a a red isolated view of the tables.  I think you can tell it to do so. However, you said you tested without targeting the output table and you still were blocked.  ...

RE: Pentaho Community Edition - can not run

Posted By Stephen Donovan 10-23-2023 11:16
Found In Egroup: Pentaho \ view thread
Agree with each response from @Petr Prochazka (server versus, client tools, root versus ubuntu).  The path above is likley inherited from JAVA_HOME, but you can override with PENTAHO_JAVA_HOME to make sure it find the right version.  You likely tried this in prior debugging under root and not ubuntu, ...

RE: Error adding data source

Posted By Stephen Donovan 10-09-2023 12:49
Found In Egroup: Pentaho \ view thread
How are you configured for the repository: File System or DB and which DB dialect?   We tried locally using a Postgres DB repo without issue.   I believe this is most likely a file system permission issue. ------------------------------ Stephen Donovan Digital Solutions Architect Hitachi Vantara - ...