Hi Wim,
Thanks. Nice to hear from you.
Now, let us go to practical issues, and hope I could share with your experience.
1. It seems that I can't find good examples on complex math calculation in Spoon's samples folder. I need to calculate a formula with all the Ln/Log, n-power, +-*/ conbination. Do you have a sample formula.ktr that I can share?
2. I need a watch-dog to launch transformation/job once an update of the input logdata file being detected. I'm not that far yet. The problem at present is that I use a Community free version of PDI, and have no Pentaho Repository connection, when I try to test Pan.sh --file:trans.ktr to automaticly run trans.ktr on a Ubuntu/Linux Terminal, error pops up. It asks me to create Repository. To create Pentaho Repository I have to be a registered user. I'm not. Any good ideas? Do I need to pay to become a registered user?
Thank you.
Best regards, Ji
Hello Ji,
normally this works,
with some of my students i use this combination of pdi and pg, starting
out with
https://www.packtpub.com/product/pentaho-data-integration-quick-start-guide/9781789343328
(PDI 8, but the same applies with PDI 9)
basically: reading/writing to plain pg from pdi should be ok in my
experience
Jiankang Ji schreef op do 25-11-2021 om 10:12 [+0100]:
> Hi Team Experts,
>
> I am new on using pentaho data integration(PDI) on postgesql to set
> up a ETL process to handle a time-series postgresql DB with data
> collected from a IoT network. I've encountered a lot of problems when
> set up this process from either the PDI tool or PostgreSQL or both.
> So, if you are familiar to both PDI and PostgreSQL, please give a
> hand. Thank you so much in advance for your assistance.
>
> Best regards,
> Ji
--
mvg,
Wim Bertels