Are you working on both pentaho and postgresql?

pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed

Are you working on both pentaho and postgresql?
3+ messages / 2 participants
[nested] [flat]

* Are you working on both pentaho and postgresql?
@ 2021-11-25 09:12 Jiankang Ji <myfloopi000@gmail.com>
  2021-11-26 13:48 ` Re: Are you working on both pentaho and postgresql? Wim Bertels <wim.bertels@ucll.be>
  0 siblings, 1 reply; 3+ messages in thread

From: Jiankang Ji @ 2021-11-25 09:12 UTC (permalink / raw)
  To: pgsql-admin

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

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Are you working on both pentaho and postgresql?
  2021-11-25 09:12 Are you working on both pentaho and postgresql? Jiankang Ji <myfloopi000@gmail.com>
@ 2021-11-26 13:48 ` Wim Bertels <wim.bertels@ucll.be>
  2021-12-02 09:16   ` Re: Are you working on both pentaho and postgresql? Jiankang Ji <myfloopi000@gmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Wim Bertels @ 2021-11-26 13:48 UTC (permalink / raw)
  To: pgsql-admin@lists.postgresql.org

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







^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Are you working on both pentaho and postgresql?
  2021-11-25 09:12 Are you working on both pentaho and postgresql? Jiankang Ji <myfloopi000@gmail.com>
  2021-11-26 13:48 ` Re: Are you working on both pentaho and postgresql? Wim Bertels <wim.bertels@ucll.be>
@ 2021-12-02 09:16   ` Jiankang Ji <myfloopi000@gmail.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Jiankang Ji @ 2021-12-02 09:16 UTC (permalink / raw)
  To: wim.bertels@ucll.be; +Cc: pgsql-admin@lists.postgresql.org

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.bertels@ucll.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
>
>
>
>
>

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2021-12-02 09:16 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-11-25 09:12 Are you working on both pentaho and postgresql? Jiankang Ji <myfloopi000@gmail.com>
2021-11-26 13:48 ` Wim Bertels <wim.bertels@ucll.be>
2021-12-02 09:16   ` Jiankang Ji <myfloopi000@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox