Profile

Ana Gonzalez

UDIMA

Contact Details

UDIMA

My Content

1 to 20 of 50+ total
Posted By Ana Gonzalez Oct 26, 2021 10:07 AM
Found In Community: Pentaho
\ view thread
Youll probably have better luck getting an answer opening an issue in the github page of the plugin, although it seems someone else has a similar issue and has already opened one.
Posted By Ana Gonzalez Oct 13, 2021 9:58 AM
Found In Community: Pentaho
\ view thread
This is probably more a Postgres question than a PDI question, and it probably has to do with how Postgres handle connections. I dont know about Postgres, but in Oracle you have DB locale settings and Connection locale settings, and this seems like in Postgres is similar. Probably theres some kind of ...
Posted By Ana Gonzalez Oct 8, 2021 9:05 AM
Found In Community: Pentaho
\ view thread
It should be possible, I played with it some years ago and I could make it work, I havent used it actively in production, so I cant help you. Have you tried the opposite? I mean, using a PDI transformation as datasource in a report, someone here some days ago found a thread in the old forum that helped ...
Posted By Ana Gonzalez Oct 8, 2021 8:57 AM
Found In Community: Pentaho
\ view thread
I cant help you there, I dont use the server to schedule the execution of PDI jobs and transformations, maybe you can find something in the old forum (https://forums.pentaho.com/) or in old blog posts, Diethards blog has a lot of useful information in PDI: https://diethardsteiner.github.io/list.html
Posted By Ana Gonzalez Oct 1, 2021 9:35 AM
Found In Community: Pentaho
\ view thread
If you install PDI in the server, you just call the kitchen.sh with the job file and parameters if needed. To run a transformation you use the pan.sh script. Look in Pentaho documentation the parameters you can pass to kitchen and pan scripts.
Posted By Ana Gonzalez Sep 17, 2021 10:01 AM
Found In Community: Pentaho
\ view thread
With Pentaho CE you dont have the Authentication menu option shown in the official Pentaho Documentation, you have to scroll down to set it up manually, go to the Manual Configuration section: https://help.hitachivantara.com/Documentation/Pentaho/9.2/Setup/LDAP_security Also, this refers to an old version ...
Posted By Ana Gonzalez Jul 26, 2021 9:00 AM
Found In Community: Pentaho
\ view thread
Yes, the server zip is for another setup (mainly to create dashboards, although it contains some things pertaining to Data Integration, but its not necessary if you are only interested in the data integration part), if you only want to execute jobs and transformations you have created in your desktop, ...
Posted By Ana Gonzalez Jul 23, 2021 9:26 AM
Found In Community: Pentaho
\ view thread
The installation is the same as with your desktop, you ensure you have Java 8 JDK, unzip and youre ready to roll. If you have added libraries (probably to connect to database), modified config files or added plugins in your PC youll have to do the same in the server. To program the execution of jobs ...
Posted By Ana Gonzalez Jul 13, 2021 8:40 AM
Found In Community: Pentaho
\ view thread
Its going to depend on the logic of your workflow, but in most cases, yes. I have some workflows where I dont mind if certain steps fail, or I force an error to stop the flow of data due to the internal logic, so in those workflows the ERRORS column is not going to help, but in most cases that column ...
Posted By Ana Gonzalez Jul 12, 2021 9:39 AM
Found In Community: Pentaho
\ view thread
Looking to the ERRORS column in Job Log table you should be able to see if the Job has completed successfully or if it has failed. Something that also works for me, is having a Send Mail step in the job and all the steps have a failed step transition that send the email, something like this:
Posted By Ana Gonzalez Jun 7, 2021 4:32 PM
Found In Community: Pentaho
\ view thread
Im connecting to MongoDB using Pentaho 8.2, its under the Big Data steps
Posted By Ana Gonzalez Jun 7, 2021 4:28 PM
Found In Community: Pentaho
\ view thread
You would need previous steps to calculate string length and search for the position of the whitespace, its probably easier using the Regex Evaluation step to get it done in one step. For example, with this expression: (.*)(\s.*) you get two strings as output, one with everything until the whitespace ...
Posted By Ana Gonzalez Jun 1, 2021 10:57 AM
Found In Community: Pentaho
\ view thread
You have a samples folder in your installation. Inside the transformations folder, you have the meta-inject folder with an example of how metadata injection works, precisely to read a csv file. Read the documentation about metadata injection also. When creating a new transformation with metadata injection, ...
Posted By Ana Gonzalez May 31, 2021 12:06 PM
Found In Community: Pentaho
\ view thread
You read the csv, you read the oracle table, sort the rows by the keys you want to use to join and merge the data of those inputs.
Posted By Ana Gonzalez May 31, 2021 11:59 AM
Found In Community: Pentaho
\ view thread
Youll have to work with Metadata Injection, first to read the excel file and pass to the excel input step all the date columns to read and then to the row normaliser step the names of the columns to normalise as date (and the values, that would be the same as the column name)
Posted By Ana Gonzalez Mar 10, 2021 12:38 PM
Found In Community: Pentaho
\ view thread
Is this Microsoft Task Scheduler running in the same machine within the same session as with the pan batch file? Could you verify if the session information is the same?
Posted By Ana Gonzalez Mar 9, 2021 11:27 AM
Found In Community: Pentaho
\ view thread
Maybe increasing the log lever when running the job will provide more information, I dont see anything wrong there.
Posted By Ana Gonzalez Mar 9, 2021 10:40 AM
Found In Community: Pentaho
\ view thread
Pentaho doesnt work with java 15, you have to install java 8 libraries
Posted By Ana Gonzalez Mar 9, 2021 10:39 AM
Found In Community: Pentaho
\ view thread
I dont see any error in your log file