Profile

John Craig

Henry Schein Practice Solutions

Contact Details

Henry Schein Practice Solutions

My Content

1 to 20 of 25 total

RE: Pentaho metadata editor tool standalone - exported XMI files hold connection password in plain text

Posted By John Craig 06-06-2023 10:52
Found In Community: Pentaho \ view thread
Subhashish, Your best option is to define a JNDI definition of your database in metadata-editor/simple-jndi/jdbc.properties and reference the JNDI name rather than set the explicit DB connection information in your metadata model. Using data source names, rather than explicit connection information is ...

RE: Where are the transctions and jobs importing?

Posted By John Craig 05-31-2023 15:41
Found In Egroup: Pentaho \ view thread
Hello Wen, If your MySQL DB is hosting the jackrabbit database, then the jobs and transformations are stored in that database (not as hidden files). That database is quite opaque though. All the info in it is serialized into binary so it's not very workable to use that directly. Use the PDI Client/Spoon ...

RE: pentaho job details

Posted By John Craig 05-31-2023 15:27
Found In Egroup: Pentaho \ view thread
Hi Divya, I'd focus on the master installation. I'm not sure which kind of "code" you're interested in. In general, most pieces of deployed PDI logic, Data Models, & Reports are contained in the jackrabbit database (data models are a bit odd, they appear to be stored elsewhere). In any case, everything ...

RE: Pentaho Metadata Editor - Can multiple Users Update the Model at the same time?

Posted By John Craig 05-31-2023 15:05
Found In Egroup: Pentaho \ view thread
Hi Vince, As far as my experience goes, I've never tried to do this, but I'm not sure how it would work. It seems to me that any change made by one user would be overwritten by the other user at the point of saving. Come to think of it, we've never even tried to have 2 instances of the Metadata Editor ...

RE: Is there a way for Pentaho job to run to only get new records and not rerun the old records?

Posted By John Craig 05-04-2023 13:42
Found In Community: Pentaho \ view thread
Hello Anna, I don't know how much control (if any) you have over the source data (BISource_one--I infer there's also a BISource_two?), but if your source data were tagged with a creation/modification date, then you could keep a table row in your BI_Target table with the last processed creation date. ...

RE: file api response is zip

Posted By John Craig 04-12-2023 15:32
Found In Community: Pentaho \ view thread
Hi, Sorry, I completely misunderstood the issue. If you want to retrieve a zip file via an API call and write it out (as noted by Peter Prochazka), you'll need to retrieve the file as an octet-stream. I was able to create a User-defined Java Class step to do this when I wanted to download the prpti files ...

RE: How to use a Bar Chart with Pentaho Report?

Posted By John Craig 04-04-2023 11:39
Found In Community: Pentaho \ view thread
Hi Claudio, Is that the Report Designer you're using? I'm afraid we avoid using that, so I'm not going to be much help--and unfortunately, having replied, you may not get others to look at the question. So, I'm doubly sorry. My approach would be to create a data model (via Schema Workbench) so that you'd ...

RE: file api response is zip

Posted By John Craig 04-04-2023 11:01
Found In Community: Pentaho \ view thread
The only really simple way I know to get a zip file as the output of a transformation is to output the files in whatever their native type is and then use the Utility > Zip file step to create a zip file. But that will save the zipped data to a file, not send the output to an HTTP client (which it sounds ...

RE: ERROR [org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.DataFactoryScriptingSupport] ...

Posted By John Craig 04-04-2023 10:58
Found In Egroup: Pentaho \ view thread
Making that change seems to have eliminated that error. Thanks! ------------------------------ John Craig Senior Software Engineer Henry Schein One ------------------------------

SQL Server JDBC Bulk Copy works on Windows, fails on Linux

Posted By John Craig 04-03-2023 07:32
Found In Community: Pentaho \ view thread
Hi Folks, Any suggestions? I have created a User-defined Java Class step that calls some external Java code to do a bulk copy using the mssql-jdbc-12.2.0.jre8.jar version of the SQL Server JDBC driver's com.microsoft.sqlserver.jdbc.SQLServerBulkCopy class. It works without any issues on Windows environments ...

RE: How to use a Bar Chart with Pentaho Report?

Posted By John Craig 03-31-2023 18:46
Found In Community: Pentaho \ view thread
Hi Claudio, The data model or the report itself will need to use calculated measures for the various fields you want ROUND( AVG( ... ) ) applied to. What chart you use isn't an issue to be concerned about as you can try both and see which one looks right to you. There is a complexity with ROUND--there's ...

RE: ERROR [org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.DataFactoryScriptingSupport] ...

Posted By John Craig 03-14-2023 13:05
Found In Egroup: Pentaho \ view thread
Thanks, Petr! That does indeed look like the file. On my 9.3.0.2 environment, it is not in a resources directory, but here: server/pentaho-server/tomcat/webapps/pentaho/WEB-INF/classes/classic-engine.properties Once I've had a change to test this, I'll have more info to share. ------------------------------ ...

ERROR [org.pentaho.reporting.engine.classic.core.modules.misc.datafactory.DataFactoryScriptingSupport] ...

Posted By John Craig 03-14-2023 11:33
Found In Egroup: Pentaho \ view thread
Hi Folks, Doing testing on 9.3.0.2. Does anyone know what is prevented from happening in reporting by this setting? Javascript for editing interactive reports, perhaps? The error message has this "helpful" message, but no indication of where the file is that contains the setting: The system administrator ...

RE: API-call to http(s)// /pentaho/api/repo/files/tree?filter=Abz*|FILES is CASE-SENSITIVE.

Posted By John Craig 03-09-2023 15:11
Found In Community: Pentaho \ view thread
Difficult. I think you'd have to retrieve the entire XML result (I don't recall if you can get it back as JSON or not) and then search that result w/o case sensitivity. You could deploy that logic as a servlet or JSP. Not much help; sorry. John

RE: PDI Table Exists job step error

Posted By John Craig 03-09-2023 15:05
Found In Community: Pentaho \ view thread
What is the database you are working with? Do you have a way to capture the SQL that Pentaho is generating (either on the server itself or using WireShark or similar)? I seem to remember we had this problem at one point and ended up coding up a SQL query to ask the DB's system tables if the user table ...

RE: JNDI connection

Posted By John Craig 03-09-2023 15:01
Found In Egroup: Pentaho \ view thread
We use DB alias names that can be the same in different environments with the JNDI definition of the alias pointing to distinct databases for each environment. It's very convenient. For example, if you used the JNDI name "Source" in your PDI extraction steps, you could have a separate database associated ...

RE: In Pentaho 9.1 version, how we can we upgrade Tomcat latest version?

Posted By John Craig 03-09-2023 14:40
Found In Egroup: Pentaho \ view thread
The simplest approach may be to install Tomcat (whatever version you want) and then try installing Pentaho on top of it--I'm not at all sure that Pentaho has instructions for this type of manual install. You're likely to run into incompatibilities between the versions of JAR files the latest Tomcat ...

RE: Where does Pentaho CE stores users, data sources and CD Dashboard?

Posted By John Craig 03-09-2023 14:32
Found In Egroup: Pentaho \ view thread
RE the question: "Is it accessible?" Not via SQL. If you look at jackrabbit tables, it's mostly serialized binary objects. So, there are at least 2 ways to make it accessible: the same Java code that is part of Pentaho (easier to just use the Pentaho User Console) use the API calls to access the ...

RE: How to temporarily save data in the process of conversion

Posted By John Craig 02-14-2023 13:49
Found In Community: Pentaho \ view thread
You can use the somewhat oddly-named "Blocking step"; this allows you can cache up data. Check the box to pass all rows; set how many rows are contained in memory. That may be what you need. We use this step when we have multiple paths through a transformation that need to be resynced at some point.

RE: Cannot import KTR / KJB files to Pentaho repository

Posted By John Craig 01-26-2023 12:46
Found In Egroup: Pentaho \ view thread
This is an old question so probably the OP doesn't need the answer anymore, but in case anyone else does, here's my take. I've never tried importing transformations or jobs via the PUC. You can import using the PDI Client (Spoon) or using the command line data-integration/import(.bat or .sh, as appropriate). ...