Re: Are you working on both pentaho and postgresql?

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

On Fri, 26 Nov 2021 at 14:48, Wim Bertels <wim(dot)bertels(at)ucll(dot)be> wrote:

> 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
>
>
>
>
>