topic PostgreSQL as a target for Greenplum in Qlik Replicate

PostgreSQL as a target for Greenplum

melo666 — Fri, 13 Sep 2024 06:41:37 GMT

Hi Community,

I have a question: Can PostgreSQL be used as a target for Greenplum?

Re: PostgreSQL as a target for Greenplum

john_wang — Fri, 13 Sep 2024 07:20:48 GMT

Hello @melo666 ,

Welcome to Qlik Community forum and thanks for reaching out here!

PostgreSQL and GreenPlum are two different target endpoints in Qlik Replicate. Please take note that:

1. Greenplum are not supported anymore in higher versions of Qlik Replicate, eg version 2024.5;

2. Greenplum is a database warehouse which backend databases is based on PostgreSQL. You cannot use PostgreSQL pre-built endpoints to access Greenplum target database.

Hope this helps.

John.

Re: PostgreSQL as a target for Greenplum

melo666 — Fri, 13 Sep 2024 10:40:59 GMT

Hey @john_wang ,

Thank you for your response. However, could we use Greenplum's ODBC driver for the connectivity?

Re: PostgreSQL as a target for Greenplum

john_wang — Fri, 13 Sep 2024 11:36:55 GMT

Hello @melo666 ,

Yes, but please take note that,unless enabled through Professional Services and approved by your Account Manager, the ODBC target endpoint should not be used.

Regards,

John.