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