topic Re: Database connections are not updating post deployment in Qlik Compose

Database connections are not updating post deployment

akshaay_akkii — Fri, 14 Mar 2025 20:49:07 GMT

We are deploying the project to higher environment with changes in landing zone setting but the changes are not reflecting post deployment.

Example in LANDING zone "ORG_LANDING_ZONE" I have database "Organization". I have modified it as "Org". after deploying the changes in existing project on higher environment. It's still showing database as Organization only.

Re: Database connections are not updating post deployment

sureshkumar — Sat, 19 Aug 2023 20:07:55 GMT

Hello @akshaay_akkii

What is the Qlik Compose version in lower environment and higher environment?

And kindly let us know exact steps followed.

Regards,

Suresh

Re: Database connections are not updating post deployment

akshaay_akkii — Mon, 21 Aug 2023 07:56:22 GMT

Hi Suresh,

Compose version in both the environment is same 2022.5.0.743.

Steps:

In lower environment I have modified the database name in existing source connection and when I'm deploying it to higher environment it's still showing old database name only.

Re: Database connections are not updating post deployment

sureshkumar — Tue, 22 Aug 2023 07:14:21 GMT

Hello @akshaay_akkii

As i checked internally, this is expected behaviour.

"Note that as database settings are usually environment specific, the database settings in the target project will not be overwritten by those of the source project.
When deploying, Compose does not override existing connection parameters. This enables you to easily migrate projects from test to production"

https://help.qlik.com/en-US/compose/May2022/Content/ComposeDWDL/Main/DW/General/Project_Deployment.htm

Regards,
Suresh

Re: Database connections are not updating post deployment

TimGarrod — Tue, 22 Aug 2023 14:54:09 GMT

As Suresh said, this is by design, so that everytime you deploy you do not have to be concerned about adjusting db names and schemas. You set it once and that is it.

Having said that, if you do have a need to adjust these configurations as part of deployment, you can use environment variables, and apply a json file that has the overrides you wish to deploy. This is done via the ComposeCLI only today, as this is meant for automated deployment scenarios.

For more information please see the help docs - https://help.qlik.com/en-US/compose/May2022/Content/ComposeDWDL/Main/DW/Projects/Variables_templates.htm