Message-ID: <504219e66f6d45d9ce6a91f2ab022b2af86fbfe7.camel@ucll.be>
Subject: Re: Are you working on both pentaho and postgresql?
From: Wim Bertels <wim.bertels@ucll.be>
Reply-To: wim.bertels@ucll.be
To: pgsql-admin@lists.postgresql.org
Date: Fri, 26 Nov 2021 14:48:38 +0100
In-Reply-To: 
 <CAFnD8DVZGPCb6At+UOLR7PrTPt4fi7soa_pB6jFVtUZCgWAPVQ@mail.gmail.com>
References: 
 <CAK_Ha4yABYGEGAMzfNJaxeepeQNFRTFaqYRsns3GCPFeQWEWhQ@mail.gmail.com>
	 <CAFnD8DVZGPCb6At+UOLR7PrTPt4fi7soa_pB6jFVtUZCgWAPVQ@mail.gmail.com>
Organization: UC Leuven-Limburg
Content-Type: text/plain; charset="UTF-8"
User-Agent: Evolution 3.38.3-1 
Content-Transfer-Encoding: 8bit
MIME-Version: 1.0
X-MS-Exchange-AntiSpam-MessageData-ChunkCount: 1
X-MS-Exchange-AntiSpam-MessageData-0: 
	=?utf-8?B?RnRGZHU0NlNmWjVaVnRiQ3BkL29WUUpmdzNmeDZsVUR1REVUUFpzQnpxVzE2?=
 =?utf-8?B?UUM1Umx2VGNoWHpEQkF6ZEdXV3hlTDYwdXRiaUUyd2VNMVhpV21ZeUZBL2tP?=
 =?utf-8?B?bTFWaWt6d1Q4SDRMNGdXTUI0NUNxdGNWU1FadURIWWNYTDVXb1B0M0RZdkl2?=
 =?utf-8?B?bkFaemttbjhtbHJkeElmUkVhd1RzeVV5NWlKLzFyMjdRNWZ0WkNEdTh6Z3FV?=
 =?utf-8?B?UHVtMDV3Q1MzMmEwY2JoQ05Wb3FUY0VMRGphNlh4US9MNVNsb3Fyd2Nkd1pV?=
 =?utf-8?B?ZVBJUktzY000YVBVbW5OUFVaUTd1Z0o0czFIekJlS1g4Q0s5OXFqdUFqcnFm?=
 =?utf-8?B?Zkp6V2l3UUdzTi9RdFRUaVhHVDNtdWdrRUJKWlhVOVJJU3U4blg0azN1Z2ZB?=
 =?utf-8?B?c014MldjeW1aZkNIazl4YktkUlJPbTM2WGxZbmpaMkZiYVN2ckZHWSs3KzNH?=
 =?utf-8?B?aWJQSUswWU5kQzUxRE15ZHBSTlowV2RENVNVWHZGR3lEU2pZWVVQS1BERklo?=
 =?utf-8?B?S0JqdzhleDBpYzF3Rnk3QktqN1J3UXJHQjdVSFJ6ODlhVjBIZEhyNjVSaW1G?=
 =?utf-8?B?SUdtc1ZJeHBnTkVydTRYbm1USE04dzIyYkdUL0VLaGhXMWdIMklNa3c0bGxF?=
 =?utf-8?B?UkR5a0JzdUhnMXJqRHpUWVJLZ3lYZ3ovL01rYzVlTG5LenduWUQ1U29mVkN0?=
 =?utf-8?B?VnRtM282elFiNmV6T3phd3graDJCUCt1c3ZrSVNKQkVwVkxGb0FLay9vQXYw?=
 =?utf-8?B?b0pmRnB3OFJndCs2YStRUGI1SHRkL1EvOWNERkt1K3g5bHdwQTVLY1RQRWVx?=
 =?utf-8?B?dW9vVmp6cWFWdXZxanBDZzlQMHc1dk1BRCsyOTZBZm1uVkxDcnlQRVRFMGlu?=
 =?utf-8?B?ejYzUlJiVXpxL3YwQUR5bGdtd2hGYTY3VW0rQ2JjT2g1SmZSSFVtZkZSNUdG?=
 =?utf-8?B?bWpKWVUrSS9uUDBuZ3d1elJFNXJZWnJnaDV1Wk54cDk2Qm5jOC96b1RRaCts?=
 =?utf-8?B?cXg2QndPalN3MFE0TDBSSmJ3YnRLa0ZvclVLOEpvUEI4OUFDWjVJVDl6Ym9K?=
 =?utf-8?B?WGZwRzRZZEtBcG1LUlZ2STFIakZZVFJpRGhoTnVqSHdrSzJXcWcwLzJhNk53?=
 =?utf-8?B?ZHAra3pwV2MwNi9xMVhnc0RoZzYweFJoVzI1NGZ3SUh6MjBwY3lNSlZ2UTRJ?=
 =?utf-8?B?QmJMRHV1VlE0ZGo3ZXNaR05JblQvSERPRDRUbktzVFdLK2VTeXpSUXVQUHpw?=
 =?utf-8?B?UW1tU0k1WWNzOFZFWXhhVy9jU3BYemtyWVErakVmbmtrTTUvYjN5YWx1dVlw?=
 =?utf-8?B?V0tjR01PNUhQUUxSbGZlMkRaS0Y1aDJZdlJmVDk5ZXdaR2M0YTRHV2dVbTNF?=
 =?utf-8?B?LzkyUlhRQ0RjdEpMN205RnNHdDU1cHNFblJzMEk3RVkvbzQzQlcvUFVkcTll?=
 =?utf-8?B?bkRKb1F5MFovbUc5ZkR1RWxsRllycmJ1eGxPc0JDemtwaG1Fd2tSODRMUnJC?=
 =?utf-8?B?WU54U0NGQWMxelpNa1I0UFNtaWp1MGVvVGEvOXhKMGpTV1dGSWpUVjNxOXF5?=
 =?utf-8?B?NHNuSHJ2QkZVUGZ1SWpFVnY3YTAwYkFKem80U2N3MjZKMHJXRlpBSkhQRHQw?=
 =?utf-8?B?eVFMd3FhVDNhWjlRMHYzU2tqUlpNZFkvdThCdVBkempNU1AvOWZrK3FITWNn?=
 =?utf-8?B?MHNvbllFbTNvVVMxMGlMbHFobjMrSDBZanFrOUNqM29VMDBJZHZ0RDdXR2pq?=
 =?utf-8?B?V2xHV3lPV1dzNlpsSkQ0Z2kvWlFreXNoUUx2UHA3WTBvcFFuVlIxdGJpcW52?=
 =?utf-8?B?L21DZkFpa3VEYWxOVy9kbzhpTlViVXlabFJGOHZmZDlzTkM1WjZDSkt0eW9X?=
 =?utf-8?B?UUhlSGdyQ1hqdVBKUkpMd1RUNFdkcjNzRmhIQ0x2ZEF6TE42eTBWZ0pncEhH?=
 =?utf-8?B?TkNId0h1d2dMZzJuQkZ1NTBoQmJra2NjOXRmNFZoeCtlYXVtZHZDZzJSblk5?=
 =?utf-8?B?clp0cm9QeEJucFh2TVZ6VkRKU2k5M1p0VnhXeTJ2bTQyK3MzZDVuNkJ4aVln?=
 =?utf-8?B?SGQ5TTBCQW5ZZzRsSklGdk5vVFNKdVltMHR4cE90V2crNXl5UGY2eTBTSElp?=
 =?utf-8?B?T2tqbHEvbTZPYThTa1pTbzQwSHU4RU1oL1ovNjFPb3RMbDdlNjNiTmNxbVkz?=
 =?utf-8?B?MWJMdlRCRkJ6UE5lYWw1Q1BZNHpuN3Q4Q1dTcUliQ21FT0tYaGR1NDF3VkZO?=
 =?utf-8?Q?pu2T/fSI2BykH+gm9PNfYs8R1A0/Il5Q+6l/fZ9SBY=3D?=
X-OriginatorOrg: ucll.be
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 e1541668-ea1f-4f66-b47b-08d9b0e373a6
X-MS-Exchange-CrossTenant-AuthSource: AM9P195MB0790.EURP195.PROD.OUTLOOK.COM
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-OriginalArrivalTime: 26 Nov 2021 13:48:39.5379
 (UTC)
X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted
X-MS-Exchange-CrossTenant-Id: e638861b-15d9-4de6-a65d-b48789ae1f08
X-MS-Exchange-CrossTenant-MailboxType: HOSTED
X-MS-Exchange-CrossTenant-UserPrincipalName: 
 rkVotALMBM9dK0ecEXOOof2Qntldba3AUnPC2FjZuy43x5A3dmQB3WaTjstB286hoipFxYaivnm7ZM1JmfCazw==
X-MS-Exchange-Transport-CrossTenantHeadersStamped: AM9P195MB1172
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/504219e66f6d45d9ce6a91f2ab022b2af86fbfe7.camel%40ucll.be>
Precedence: bulk

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