Qlik Compose - Target to PostgreSQL

[Fasims]

Good evening community,

i was wondering if anyone succeded in targeting a PostgreSQL using Qlik Compose.

We haven't found anything about PostgreSQL as Target in the Compose Community/Documentation.

Thank you,

Fabio

[TimGarrod]

PostgreSQL is not a supported target for Compose. Only cloud DW's (Snowflake, Redshift, Synapse, BigQuery ) and Oracle / SQL Server are supported

[Fasims]

Hi @TimGarrod, thank you very much for your Reply!

We currently have a Qlik Replicate installation to move data from a DB2 to Postgres, but need to setup some ETL processes (through Qlik Compose) to write refined data to Postgres. 

Could you give us any tips on achieving our goal?

Thank you again!

Best regards,

Fabio

[samsu]

I am also looking for similar solution like Fabio is asking for and if this can be acheived using Qlik Replicate and Compose.

Source for Qlik Replicate: DB2 on z/OS

Target for Qlik Replicate(Source for Compose): PostgreSQL

Target for Qlik Compose(warehouse): Oracle

Is this achievable ?

[Dana_Baldwin · Accepted solution]

Hi @samsu 

At this time Postgres is not a supported data source for Compose, please refer to our documentation here:

Support matrix #Support matrix | Qlik Compose Help

If this is a feature you would like to see in the product, I encourage you to please submit a feature request here which goes to our Product Management team. Other users will have the opportunity to vote on it to increase the chances at adoption and to set the priority: https://community.qlik.com/t5/Ideas/idb-p/qlik-ideas

Thanks,

Dana