Qlik Community

Qlik Compose for Data Warehouses

Discussion board for collaboration on Qlik Compose for Data Warehouses.

Announcements
Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Helmut__Schuster
Contributor
Contributor

Restore Qlik Compose project after server rebuild using existing data warehouse tables

We had to rebuild our virtual machine where Qlik Compose runs.  We backed up all projects before the rebuild. After the rebuild, we deployed the existing projects.  However, we had to delete all tables and views in the data warehouse and data mart schema. Only then we could "Create" the data warehouse from the Qlik Compose GUI and then continue with Development.

Is is possible to use the existing tables and views of a data warehouse for the same project?

I am worried what happens when this occurs on a Production machine where lots of data is stored in the warehouse tables.

Labels (1)
1 Solution

Accepted Solutions
TimGarrod
Employee
Employee

Hi,   Yes it is possible to do this.    When you first deploy a project in Compose via the UI, Compose anticipates this is a new project.   That may not always be the case (as in your scenario).  

 

Deploy the project via the UI.  You will only be presented with the 'Create' button.   Go into the project menu and project settings and check the  check box - 

TimGarrod_0-1648586537275.png

Then Click Create.   Compose will generate create scripts, but not deploy them / execute them. 

Once done - uncheck the check box, and clear the metadata cache in Compose (this forces Compose to re-hydrate the DW metadata cache).  Click Validate to validate the DW again - you can then generate code and run ETL processes. 

Please note - if you have the data folder and need to migrate to another server, you can place the data folder in the correct directory (Program Files\Qlik\Compose) and run the installer, and Qlik Compose will use your existing data folder and projects, with their current status.   You may need to reset passwords when performing this action as the master pwd used for encryption could be different between environments. 

 

Hope this helps!

 

View solution in original post

2 Replies
Seanog_Murphy
Creator III
Creator III

TimGarrod
Employee
Employee

Hi,   Yes it is possible to do this.    When you first deploy a project in Compose via the UI, Compose anticipates this is a new project.   That may not always be the case (as in your scenario).  

 

Deploy the project via the UI.  You will only be presented with the 'Create' button.   Go into the project menu and project settings and check the  check box - 

TimGarrod_0-1648586537275.png

Then Click Create.   Compose will generate create scripts, but not deploy them / execute them. 

Once done - uncheck the check box, and clear the metadata cache in Compose (this forces Compose to re-hydrate the DW metadata cache).  Click Validate to validate the DW again - you can then generate code and run ETL processes. 

Please note - if you have the data folder and need to migrate to another server, you can place the data folder in the correct directory (Program Files\Qlik\Compose) and run the installer, and Qlik Compose will use your existing data folder and projects, with their current status.   You may need to reset passwords when performing this action as the master pwd used for encryption could be different between environments. 

 

Hope this helps!